Full Where Clause (Magic xpa 4.x)
Magic xpa displays the entire WHERE clause as used in the SQL statement generated by Magic xpa in the Full Where Clause area. Click the SHOW button at the bottom of the screen to refresh the Full Where clause.
The Full Where Clause consists of three parts:
-
The Where clause expressions from the Data View Editor (consist of ranges on the variables and the Link Inner Join/Left Outer Join).
-
The Magic xpa SQL Where clause, added in parenthesis with an AND clause, to concatenate it to the Data View Range.
-
The DB SQL Where clause, added in parenthesis with an AND clause, to concatenate it to the Data View Range.
The Full Where Clause replaces every occurrence of a variable from the Variable list. Columns from the Main and Joined tables, are replaced in the format of ‘column DB name’ or ‘A. column DB name’, and virtual variables are replaced with their description.
The Full Where Clause is added to every SELECT statement. The variables’ values are evaluated only once when entering the task, and no re-compute is done.
The only time in which the DB SQL range or Magic xpa SQL range is not used is when Magic xpa generates the SELECT statements for the internal Get Current and Hook (determined by the locking strategy) operations. In these operations Magic xpa uses the position key to get the record, and the SQL range is not needed.
