Skip to Content

Default language.

SQL generated by the call--dynamic joins

This section shows the SQL generated by the preceding examples.

Warning

Note

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


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*

Remedy Action Request System 20.02