Dear All,
I have the needs to "fetch" the parameters input by the users in the standard query form highlighted below:
I clearly have easily the possibility to fetch my custom parameters , but due to performance reasons I still need the user to fill also the "standard query".
In fact, if we leave the "standard query parameters" empty, at runtime the ER engine:
-First, fetches the WHOLE TABLE RECORDS;
-Second, it applies the Filter based on a formula I write using my custom parameters.
i.e. If I want to fetch all main account transactions of a specific account from 01092019 to 30092019, with the query below it takes 5 minutes:
while if I "duplicate" the input parameters specifying them also in the standard query it takes 5 seconds!
this is clearly quite "UGLY" as we need to tell the user to input the parameters 2 times:
1)in my custom fields for being able to print them in the header and make some other calculations I want to do;
2)in the standard query for being able to filter properly the tables "at runtime" due to performance issues described above.
My desire is to at least being able to "fetch" properly the standard query parameters input by the user, to avoid telling the user to input them twice.
Kind Regards and Thanks
