Debugging AQL Queries
You can debug AQL queries by going to the AQL Query Editor with the 'debug' parameter set to '1'.
For example, if you were working with the default site on your ARDI server at yourardisite, you'd type the address http://yourardisite/s/default/aql/show?debug=1.
When you run the query, the debugging output will appear below.
Reading Debugging Data
The debugging output shows the state of the stack at each point in your query execution.
The debugging output for the query 'TE101' ASSET is below…
Added Item to Stack (const) ------ 1: const TE101 -------
Called **ASSET** (fn_asset_c) in 0.0019338130950928 seconds. ------ 1: assetlist Array ( [0] => 58 ) -------
The first section shows the const value 'TE101' being added to the stack, the second shows the command ASSET being run, which results in the actual asset ID being looked up.
Note that in your debugging output, only the item IDs are shown. So for asset lists, property lists, relationship lists etc, you'll only see numeric values for their unique ARDI ID.