Query-Global Filters

[Former Member]

Hi experts

where can I change a global filter in a query?I am trying to see many years data for a query.but was able to see only for 2008.I I clicked on one button 'Global Filters' and there for year, its displaying 2008.I think its because of this settings its not displaying data for other years because in infoprovider we have data for years 2006,2007,2008.whats the purpose of global settings?how can I do to see data for all years....

Thanks.

Schand

[Pravender · Accepted solution]

You can restrict the year by a variable then you can enter any value for year dynamically while executing the query and see the data. In the filter tab of the query remove the hard coded restriction and change it to variable.

[former_member202718]

Hi Schand,

In the Query Designer .U might have hardcoded the Year 2008 only in the Filters ...for the Year Object.I guess u may have to remove that..

then will be able to view for all the years.....

also just check your inout variable which has Year as Input...Dont out anythig there..such that it diplays for all the years or include whichever u want to view the data for...

Rgds

SVU123

Edited by: svu123 on May 21, 2010 9:08 AM

[shanthi_bhaskar]

just remove 2008 from restriction and save the query it will display all the years data..