Hi,
In my rad grid currently i am applying a default filter in Filter expression like(FilterExpression = "([JourneyClass] NOT LIKE '%Economy%')) and I want to apply one more default filter onload of grid so that it should load the Journey data of last seven days only.
For second the db query like (select * from Journey where JourneyDate >= dateadd(day, datediff(day, 0, getdate()), -7)).this query is working fine in DB. But I have no idea how to put it for default filtering odf rad grid with the condition ((FilterExpression = "([JourneyClass] NOT LIKE '%Economy%')) ).
Please help me regarding this.
Regards,
Dheeraj
In my rad grid currently i am applying a default filter in Filter expression like(FilterExpression = "([JourneyClass] NOT LIKE '%Economy%')) and I want to apply one more default filter onload of grid so that it should load the Journey data of last seven days only.
For second the db query like (select * from Journey where JourneyDate >= dateadd(day, datediff(day, 0, getdate()), -7)).this query is working fine in DB. But I have no idea how to put it for default filtering odf rad grid with the condition ((FilterExpression = "([JourneyClass] NOT LIKE '%Economy%')) ).
Please help me regarding this.
Regards,
Dheeraj