Multiple query execution

Ns7703 — Fri, 15 Nov 2024 20:56:03 GMT

I need to merge three reports in one application, Which displayed as worksheets in that one application. Lets call it X,Y,Z reports . In X reports I need to display all the projects with PSP _ELEMENT but in report Y I only need to display project with limited number of projects which holds some conditions like where where "PSP_ELEMENT" like '%-BZ-%' OR "PSP_ELEMENT" like '%-BZ%'. I want to ask how to write query in Data load editior in such a way that one worksheets display all the projects and another reports will display projects with some conditions

Re: Multiple query execution

marksouzacosta — Thu, 27 Jun 2024 18:26:02 GMT

Not sure if I understand the problem, but you can combine different data sets originated from different queries. Something like:

MyTable:
SQL SELECT * FROM TableA WHERE Z = Y .....;

Concatenate(MyTable)
SQL SELECT * FROM TableB WHERE A = ''some search' OR .....;

Concatenate(MyTable)
SQL SELECT * FROM TableC WHERE Some other condition .....;

topic Multiple query execution in App Development

Multiple query execution

Re: Multiple query execution