Re: [wnframework] How to add Filters for the Overloaded queries

1
Look at this example:

http://code.google.com/p/wnframework-modules/source/browse/trunk/accounts/search_criteria/srch_00069/srch_00069.js

There are a lot of other reports for your reference in the modules..

- Rushabh

On Apr 11, 2011, at 3:34 PM, Nikhil Kulkarni wrote:


Hi,

    We have created reports by making use of the overloaded query section in the webnotesframework.

    we want to add filters for some fields.

    How can we add..? 
 
    I have tried in the client side section but it is not working.

    please suggest.


Regards,
Nikhil

       
      

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
erpnext

World's most affordable ERP - Rs 299/user/month

https://www.erpnext.com

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

2



Hi,

I have tried with the below link example it is showing the filter but not getting the filtered result.

am using the overloaded section to create reports,my query is their in overloaded section.


For adding the filter for overloaded query is same as normal query…?

Regards,
Nikhil


On Tue, Apr 12, 2011 at 9:52 AM, Rushabh Mehta <rm…@gmail.com> wrote:

Look at this example:

http://code.google.com/p/wnframework-modules/source/browse/trunk/accounts/search_criteria/srch_00069/srch_00069.js

There are a lot of other reports for your reference in the modules..

- Rushabh

On Apr 11, 2011, at 3:34 PM, Nikhil Kulkarni wrote:


Hi,

We have created reports by making use of the overloaded query section in the webnotesframework.

we want to add filters for some fields.

How can we add..?
I have tried in the client side section but it is not working.

please suggest.


Regards,
Nikhil


--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
erpnext

World's most affordable ERP - Rs 299/user/month

–

You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.

To post to this group, send email to wn…@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un…@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

3
Hi Nikhil,

You will have to write the conditions for the filters in your query and where you want the values to appear, use %(fieldname)s and the query builder will replace them with the field values or ", so be sure to use like

for example - if you have added a site filter, add a condition in your overloaded query as

AND site LIKE '%(site)s'

- Rushabh

On Apr 13, 2011, at 11:31 AM, Nikhil Kulkarni wrote:



 Hi,

     I have tried with the below link example it is showing the filter but not getting the filtered result.
  
     am using the overloaded section to create reports,my query is their in overloaded section.
    
     For adding the filter for overloaded query is same as normal query...?
 
Regards,
Nikhil


On Tue, Apr 12, 2011 at 9:52 AM, Rushabh Mehta <rm...@gmail.com> wrote:
Look at this example:

http://code.google.com/p/wnframework-modules/source/browse/trunk/accounts/search_criteria/srch_00069/srch_00069.js

There are a lot of other reports for your reference in the modules..

- Rushabh

On Apr 11, 2011, at 3:34 PM, Nikhil Kulkarni wrote:


Hi,

    We have created reports by making use of the overloaded query section in the webnotesframework.

    we want to add filters for some fields.

    How can we add..? 
 
    I have tried in the client side section but it is not working.

    please suggest.


Regards,
Nikhil

       
      

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
erpnext

World's most affordable ERP - Rs 299/user/month


--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
erpnext

World's most affordable ERP - Rs 299/user/month

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.