SQL Query Report

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:




regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.

Thank you

On 15 Aug 2014 22:10, "Rushabh Mehta" <rm...@gmail.com> wrote:


On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:



regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdiukJ5Qz1M%3Dj%3D99W0YSJ8VOF27fJxa3%3Dv2rhCgV71uYA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Hi,

I was successful in using the following TYPE of Custom report, but today it is giving an error :

Query Report :

select * from `tabItem` where name like %(name)s

Javascript:

frappe.query_reports['Test Query Parameter'] = {

"filters": [

{

"fieldname":"name",

"label":__("Item Name"),

"fieldtype": "Data",

}

]

}


Error :

Traceback (innermost last):

File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application

response = frappe.handler.handle()

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle

execute_cmd(cmd)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd

ret = frappe.call(method, **frappe.form_dict)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 529, in call

return fn(*args, **newargs)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/query_report.py", line 81, in run

result = [list(t) for t in frappe.db.sql(report.query, filters)]

File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 108, in sql

self._cursor.execute(query, values)

File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute

for key, item in args.iteritems())

KeyError: 'name'


Any Idea?


regards

Akshay



On Sat, Aug 16, 2014 at 12:50 PM, Akshay Mehta <me...@gmail.com> wrote:

Thank you

On 15 Aug 2014 22:10, "Rushabh Mehta" <rm...@gmail.com> wrote:


On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:



regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdgkV_p0gh-%2BjQiLZ%2Baq_n4NW2%3DtekOur2D0rHL1yoyuA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

also set "reqd": 1 for that filter and try.

-Anand.


On Mon, Sep 1, 2014 at 1:31 PM, Akshay Mehta <me...@gmail.com> wrote:
Hi,

I was successful in using the following TYPE of Custom report, but today it is giving an error :

Query Report :

select * from `tabItem` where name like %(name)s

Javascript:

frappe.query_reports['Test Query Parameter'] = {

"filters": [

{

"fieldname":"name",

"label":__("Item Name"),

"fieldtype": "Data",

}

]

}


Error :

Traceback (innermost last):

File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application

response = frappe.handler.handle()

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle

execute_cmd(cmd)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd

ret = frappe.call(method, **frappe.form_dict)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 529, in call

return fn(*args, **newargs)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/query_report.py", line 81, in run

result = [list(t) for t in frappe.db.sql(report.query, filters)]

File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 108, in sql

self._cursor.execute(query, values)

File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute

for key, item in args.iteritems())

KeyError: 'name'


Any Idea?


regards

Akshay



On Sat, Aug 16, 2014 at 12:50 PM, Akshay Mehta <me...@gmail.com> wrote:

Thank you

On 15 Aug 2014 22:10, "Rushabh Mehta" <rm...@gmail.com> wrote:


On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:



regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdgkV_p0gh-%2BjQiLZ%2Baq_n4NW2%3DtekOur2D0rHL1yoyuA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1p%2B-wJWibC7jSOE%2BHkRJ%2BVgFrz0cJwsSRtL_DHCmHjYw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

does not work ... same error

akshay


On Mon, Sep 1, 2014 at 3:55 PM, Anand Doshi <an...@erpnext.com> wrote:
also set "reqd": 1 for that filter and try.

-Anand.


On Mon, Sep 1, 2014 at 1:31 PM, Akshay Mehta <me...@gmail.com> wrote:
Hi,

I was successful in using the following TYPE of Custom report, but today it is giving an error :

Query Report :

select * from `tabItem` where name like %(name)s

Javascript:

frappe.query_reports['Test Query Parameter'] = {

"filters": [

{

"fieldname":"name",

"label":__("Item Name"),

"fieldtype": "Data",

}

]

}


Error :

Traceback (innermost last):

File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application

response = frappe.handler.handle()

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle

execute_cmd(cmd)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd

ret = frappe.call(method, **frappe.form_dict)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 529, in call

return fn(*args, **newargs)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/query_report.py", line 81, in run

result = [list(t) for t in frappe.db.sql(report.query, filters)]

File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 108, in sql

self._cursor.execute(query, values)

File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute

for key, item in args.iteritems())

KeyError: 'name'


Any Idea?


regards

Akshay



On Sat, Aug 16, 2014 at 12:50 PM, Akshay Mehta <me...@gmail.com> wrote:

Thank you

On 15 Aug 2014 22:10, "Rushabh Mehta" <rm...@gmail.com> wrote:


On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:



regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdgkV_p0gh-%2BjQiLZ%2Baq_n4NW2%3DtekOur2D0rHL1yoyuA%40mail.gmail.com.



For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1p%2B-wJWibC7jSOE%2BHkRJ%2BVgFrz0cJwsSRtL_DHCmHjYw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3Dkcw7Nuz-SuXqtZKa%2BGOjd-E-uDTKsBHao7-FgAyWrCRCA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Check if you are passing some value in "Item Code".

Also, confirm if the report's name is "Test Query Report", since you are using frappe.query_reports['Test Query Parameter']


On Mon, Sep 1, 2014 at 4:11 PM, Akshay Mehta <me...@gmail.com> wrote:
does not work ... same error

akshay


On Mon, Sep 1, 2014 at 3:55 PM, Anand Doshi <an…@erpnext.com> wrote:

also set "reqd": 1 for that filter and try.

-Anand.



On Mon, Sep 1, 2014 at 1:31 PM, Akshay Mehta <me…@gmail.com> wrote:
Hi,

I was successful in using the following TYPE of Custom report, but today it is giving an error :

Query Report :

select * from `tabItem` where name like %(name)s

Javascript:

frappe.query_reports['Test Query Parameter'] = {

"filters": [

{

"fieldname":"name",

"label":__("Item Name"),

"fieldtype": "Data",

}

]

}


Error :

Traceback (innermost last):

File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application

response = frappe.handler.handle()

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle

execute_cmd(cmd)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd

ret = frappe.call(method, **frappe.form_dict)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 529, in call

return fn(*args, **newargs)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/query_report.py", line 81, in run

result = [list(t) for t in frappe.db.sql(report.query, filters)]

File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 108, in sql

self._cursor.execute(query, values)

File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute

for key, item in args.iteritems())

KeyError: 'name'


Any Idea?


regards

Akshay



On Sat, Aug 16, 2014 at 12:50 PM, Akshay Mehta <me...@gmail.com> wrote:

Thank you

On 15 Aug 2014 22:10, "Rushabh Mehta" <rm...@gmail.com> wrote:


On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:



regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdgkV_p0gh-%2BjQiLZ%2Baq_n4NW2%3DtekOur2D0rHL1yoyuA%40mail.gmail.com.


For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1p%2B-wJWibC7jSOE%2BHkRJ%2BVgFrz0cJwsSRtL_DHCmHjYw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3Dkcw7Nuz-SuXqtZKa%2BGOjd-E-uDTKsBHao7-FgAyWrCRCA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF2upYAmx8QOHSLZ1STrKb0bQ2ykSbD_HkMUmWsrA-GEGw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Yes I think I was not putting any value in the field ....

Is it possible to set "default":"%%"? I tried this but did not work.

Akshay



On Mon, Sep 1, 2014 at 4:19 PM, Anand Doshi <an...@erpnext.com> wrote:
Check if you are passing some value in "Item Code".

Also, confirm if the report's name is "Test Query Report", since you are using frappe.query_reports['Test Query Parameter']


On Mon, Sep 1, 2014 at 4:11 PM, Akshay Mehta <me...@gmail.com> wrote:
does not work ... same error

akshay


On Mon, Sep 1, 2014 at 3:55 PM, Anand Doshi <an…@erpnext.com> wrote:

also set "reqd": 1 for that filter and try.

-Anand.



On Mon, Sep 1, 2014 at 1:31 PM, Akshay Mehta <me…@gmail.com> wrote:
Hi,

I was successful in using the following TYPE of Custom report, but today it is giving an error :

Query Report :

select * from `tabItem` where name like %(name)s

Javascript:

frappe.query_reports['Test Query Parameter'] = {

"filters": [

{

"fieldname":"name",

"label":__("Item Name"),

"fieldtype": "Data",

}

]

}


Error :

Traceback (innermost last):

File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application

response = frappe.handler.handle()

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle

execute_cmd(cmd)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd

ret = frappe.call(method, **frappe.form_dict)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 529, in call

return fn(*args, **newargs)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/query_report.py", line 81, in run

result = [list(t) for t in frappe.db.sql(report.query, filters)]

File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 108, in sql

self._cursor.execute(query, values)

File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute

for key, item in args.iteritems())

KeyError: 'name'


Any Idea?


regards

Akshay



On Sat, Aug 16, 2014 at 12:50 PM, Akshay Mehta <me...@gmail.com> wrote:

Thank you

On 15 Aug 2014 22:10, "Rushabh Mehta" <rm...@gmail.com> wrote:


On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:



regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdgkV_p0gh-%2BjQiLZ%2Baq_n4NW2%3DtekOur2D0rHL1yoyuA%40mail.gmail.com.


For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1p%2B-wJWibC7jSOE%2BHkRJ%2BVgFrz0cJwsSRtL_DHCmHjYw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3Dkcw7Nuz-SuXqtZKa%2BGOjd-E-uDTKsBHao7-FgAyWrCRCA%40mail.gmail.com.



For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF2upYAmx8QOHSLZ1STrKb0bQ2ykSbD_HkMUmWsrA-GEGw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3Dkdno_vEW6DF%2B7%2B8F42BbS98__-CXLWd-GfuUgY94sOYxQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Hi Akshay,

Should work. After saving the report, go to Help > Clear Cache and try after that

-Anand.


On Tue, Sep 2, 2014 at 1:19 PM, Akshay Mehta <me...@gmail.com> wrote:
Yes I think I was not putting any value in the field ....

Is it possible to set "default":"%%"? I tried this but did not work.

Akshay



On Mon, Sep 1, 2014 at 4:19 PM, Anand Doshi <an...@erpnext.com> wrote:
Check if you are passing some value in "Item Code".

Also, confirm if the report's name is "Test Query Report", since you are using frappe.query_reports['Test Query Parameter']


On Mon, Sep 1, 2014 at 4:11 PM, Akshay Mehta <me...@gmail.com> wrote:
does not work ... same error

akshay



On Mon, Sep 1, 2014 at 3:55 PM, Anand Doshi <an…@erpnext.com> wrote:

also set "reqd": 1 for that filter and try.

-Anand.



On Mon, Sep 1, 2014 at 1:31 PM, Akshay Mehta <me…@gmail.com> wrote:
Hi,

I was successful in using the following TYPE of Custom report, but today it is giving an error :

Query Report :

select * from `tabItem` where name like %(name)s

Javascript:

frappe.query_reports['Test Query Parameter'] = {

"filters": [

{

"fieldname":"name",

"label":__("Item Name"),

"fieldtype": "Data",

}

]

}


Error :

Traceback (innermost last):

File "/home/erpnext/frappe-bench/apps/frappe/frappe/app.py", line 49, in application

response = frappe.handler.handle()

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 66, in handle

execute_cmd(cmd)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/handler.py", line 89, in execute_cmd

ret = frappe.call(method, **frappe.form_dict)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/__init__.py", line 529, in call

return fn(*args, **newargs)

File "/home/erpnext/frappe-bench/apps/frappe/frappe/widgets/query_report.py", line 81, in run

result = [list(t) for t in frappe.db.sql(report.query, filters)]

File "/home/erpnext/frappe-bench/apps/frappe/frappe/database.py", line 108, in sql

self._cursor.execute(query, values)

File "/home/erpnext/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 185, in execute

for key, item in args.iteritems())

KeyError: 'name'


Any Idea?


regards

Akshay



On Sat, Aug 16, 2014 at 12:50 PM, Akshay Mehta <me...@gmail.com> wrote:

Thank you

On 15 Aug 2014 22:10, "Rushabh Mehta" <rm...@gmail.com> wrote:


On 15-Aug-2014, at 1:52 pm, Akshay Mehta <me...@gmail.com> wrote:

Hi,

Is there a way we can add and work with Parameters (?) in the SQL Query Report? If yes can anybody quote an example.

Check how you can set filters:



regards
Akshay Mehta



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkeQPCjUMysn8EgtTNtC%3DC_jLpZUPpjPtHt7j3UwDLfGDA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/73ADF3DE-7075-427B-8A00-1A43490E9ADD%40gmail.com.

For more options, visit https://groups.google.com/d/optout.





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3DkdgkV_p0gh-%2BjQiLZ%2Baq_n4NW2%3DtekOur2D0rHL1yoyuA%40mail.gmail.com.


For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1p%2B-wJWibC7jSOE%2BHkRJ%2BVgFrz0cJwsSRtL_DHCmHjYw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3Dkcw7Nuz-SuXqtZKa%2BGOjd-E-uDTKsBHao7-FgAyWrCRCA%40mail.gmail.com.


For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF2upYAmx8QOHSLZ1STrKb0bQ2ykSbD_HkMUmWsrA-GEGw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMgq%3Dkdno_vEW6DF%2B7%2B8F42BbS98__-CXLWd-GfuUgY94sOYxQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1hsoc%3DCsOHK7cvxNf-xxV%2B4rFoH0a2DRvyrV%2Bg_hvMJA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.