Hello All, I have added return query to a link field. when i type “abc” in filter it should display values containing string “abc” but it shows all values . If i remove return query it works fine for key searching. Is there any thing i miss.
Regards, Gangadhar kadam
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
Like I said earlier, our magic eye system is not working. Please share what query you are using. The more information you give us, the faster we (or anyone) can reply to your question. Hope you keep this in mind for future queries on the forum.
On 23-May-2013, at 10:44 AM, gangadhar kadam <em...@gmail.com> wrote:
Hello All, I have added return query to a link field. when i type "abc" in filter it should display values containing string "abc" but it shows all values . If i remove return query it works fine for key searching. Is there any thing i miss.
Regards, Gangadhar kadam
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
cur_frm.fields_dict['group_opm'].get_query = function(doc, cdt, cdn) { return "select p.name from tabProfile p,tabUserRole u where u.parent=p.name and u.role='Group Operations Manager'";
}
I am using this query to filter profile having Group operation manager. If I use this query, I get correct result of query , if I type "abc" then it should display profile having Group operation manager role, but it displays all profiles having Group operation manager role .If i remove this script filter works correctly. Should i tried this also
cur_frm.fields_dict['group_opm'].get_query = function(doc, cdt, cdn) { return "select p.name from tabProfile p,tabUserRole u where u.parent=p.name and u.role='Group Operations Manager' and p.name like ' %"+doc.group_opm+"%' ";
}
Thank you.
On 23 May 2013 10:47, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,
Like I said earlier, our magic eye system is not working. Please share what query you are using. The more information you give us, the faster we (or anyone) can reply to your question. Hope you keep this in mind for future queries on the forum.
On 23-May-2013, at 10:44 AM, gangadhar kadam <em...@gmail.com> wrote:
Hello All, I have added return query to a link field. when i type "abc" in filter it should display values containing string "abc" but it shows all values . If i remove return query it works fine for key searching. Is there any thing i miss.
Regards, Gangadhar kadam
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We have started shifting the get queries to server side. If you have access to modifying server side code, you can use this system.
Check cost_center get query in journal_voucher.js and its called method "get_cost_center_list" in accounts/utils.py
Else your query should be something like:
"select p.name from `tabProfile` p, `tabUserRole` u where u.parent=p.name and u.role=\"Group Operations Manager\" \
and %(key)s like \"%s%%\" "
Thanks,
Anand.
On 23-May-2013, at 1:12 PM, गंगाधर कदम <em...@gmail.com> wrote:
Sorry sir,
I am using following query
cur_frm.fields_dict['group_opm'].get_query = function(doc, cdt, cdn) { return "select p.name from tabProfile p,tabUserRole u where u.parent=p.name and u.role='Group Operations Manager'";
}
I am using this query to filter profile having Group operation manager. If I use this query, I get correct result of query , if I type "abc" then it should display profile having Group operation manager role, but it displays all profiles having Group operation manager role .If i remove this script filter works correctly. Should i tried this also
cur_frm.fields_dict['group_opm'].get_query = function(doc, cdt, cdn) { return "select p.name from tabProfile p,tabUserRole u where u.parent=p.name and u.role='Group Operations Manager' and p.name like ' %"+doc.group_opm+"%' ";
}
Thank you.
On 23 May 2013 10:47, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,
Like I said earlier, our magic eye system is not working. Please share what query you are using. The more information you give us, the faster we (or anyone) can reply to your question. Hope you keep this in mind for future queries on the forum.
On 23-May-2013, at 10:44 AM, gangadhar kadam <em...@gmail.com> wrote:
Hello All, I have added return query to a link field. when i type "abc" in filter it should display values containing string "abc" but it shows all values . If i remove return query it works fine for key searching. Is there any thing i miss.
Regards, Gangadhar kadam
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.