Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Speed up big queries

Milan_Vucetic
Community Advisor
Community Advisor

Hi all,

I am looking for best approach to execute workflow below several times per day. There are two big tables (connection via FDA !!!) . Table AUDIT contains IDs and timestamp of records in CORE table which are modified. Let's say workflow will start every 30 minutes and we need to fetch data from CORE which is modified after last execution of workflow.

1826970_pastedImage_0.png

  • how to pass a date of last execution into AUDIT query (for example for an option which will be created to store date) ?
  • What about passing IDs from AUDIT results to CORE query? This can be done in JS file for sure, but in GUI is it possible? It is ORACLE behind, so we probably can expect an error if we pass more than 1000 values in IN clause (... where ID  in (1000 different values)...)

Is there any better way to optimize fetching data from these tables via FDA in general?

Thanks in advance.

Regards,

Milan

1 Accepted Solution
saikatk2447661
Correct answer by
Level 4
Level 4

Hi Milan,

You can join them using the Add a linked table option on the ID

1826999_pastedImage_0.png

Then in Edit query you can pass an option like this

1827000_pastedImage_1.png

Thanks,

Saikat

View solution in original post

2 Replies
saikatk2447661
Correct answer by
Level 4
Level 4

Hi Milan,

You can join them using the Add a linked table option on the ID

1826999_pastedImage_0.png

Then in Edit query you can pass an option like this

1827000_pastedImage_1.png

Thanks,

Saikat

Milan_Vucetic
Community Advisor
Community Advisor

Hi Saikat,

works perfectly 

Regards,

Milan