Same Panel operation in different queries

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
JoshK131
Posts: 47
Joined: Tue Jan 26, 2021 11:09 pm

Same Panel operation in different queries

Post by JoshK131 »

Hello.

I have a panel operation where users can pick the filters to apply to a query.
I want to generalize the process so I can use the same process in all the queries I have.

I there 2 are problems I am facing with this.

1. How can i get the processes being called to know what query the process is being called from.
2. If i use "PICK FROM FilterBO WHERE FilterBO .Query = QUERY_NAME" how can i choose which columns to display is the chosen query.


If the above is not possible,
I have also created a Query for FilterBO with ask at runtime options hoping to poulate the value in the process.
This approach would mean i need to write 1 process per query.

Best case scenario is 1 process for all queries.
If not possible, I can write a process for each query.
Otherwise i need to write a process and custom FilterBO Query for each query.

Thanks
Post Reply