how to add custom date or week range filters on top of query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

how to add custom date or week range filters on top of query

Post by swiftinitpvtltd »

how to add custom date or week range filters on top of query?
Suppose I have a query displaying some data from BO that contains weeks and dates then I want in same query on top showing weeks filter and dates filter similar to scheduler(but not using scheduler) or can I use appointment object above this query to filter the query?
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: how to add custom date or week range filters on top of q

Post by tford »

Not sure if you are looking for something like this:
https://www.awareim.com/forum/viewtopic.php?f=4&t=8229

Shows an advanced filter technique but no dates involved in my example. From / To dates can easily be added.
Tom - V8.8 build 3137 - MySql / PostGres
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: how to add custom date or week range filters on top of q

Post by swiftinitpvtltd »

Works for me. Thank you!
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: how to add custom date or week range filters on top of q

Post by swiftinitpvtltd »

The only issue is on refresh of a grid neither render or init script fire which is needed for us as we have few scripts written for some functionality. Does anyone know any workaround or is this a bug in aware?
Post Reply