If a query is used for a datatable it is providing data for the frontend. if a datatable has subtables, the query has to process this data by a subquery. 

Parameters:

  • Subquery
  • Temporary Table Approach
  • Use Link
  • Condition

Subquery

Temporary Table Approach

Condition

RESULT_TABLE_NAME replaced by dynamic tablename