Queries Query Fields Subqueries Having OrderBy GroupBy Join Union Where Replacing Values Show and Explain Query Caching Action: clear_query_cache Bootstrapped Queries Aggregate Filter: wr_query_replace_placeholder Subqueries: 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 Use Link Condition