Skip to Content

SQL generated by the call--dynamic joins

This section shows the SQL generated by the preceding examples:

Warning

Important

In this example, an AR System administrator made the API call, and the form did not use row-level security. If a non-administrator makes the API call and the form uses row-level security, the SQL generated by the call will differ from this example.

Related topic

Retrieving-entries-from-multiple-forms

SELECT J0.C1, J0.C536870913, J0.C536870914, J0.C536870915,
       J1.C1, J1.C536870913, J1.C536870914
FROM T169 J0 INNER JOIN T168 J1 ON (J0.C536870914 = J1.C536870914)
ORDER BY J0.C536870914 ASC, J1.C536870914 ASC, J0.C1 ASC

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Helix Innovation Suite 25.1