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