See the exact query a dataset sends
The Queries tab shows the request a dataset sends to the other system. It's for reference only: nothing is run. It's useful for checking your filters, or for sharing the request with the other system's supplier or Three 17 support.
Steps
-
Open the Queries tab
Open the dataset on the AutomatedOn site and select Queries.
-
Read the query
The card shows a readable version of the query:
- OData datasets:
SELECTwith each field and itsASname,FROMthe entity set, andWHEREwith each filter joined byAND. - REST datasets:
SELECT,FROM GETthe resource path,ITEMSthe items path,WITH PARAMETERSandPAGING, which describes how further pages are fetched.
Underneath is the full request address.
- OData datasets:
-
Copy what you need
Select Copy query or Copy URL. The button briefly shows Copied!. Select Refresh to rebuild the query after making changes.
More detail
Good to know
{aoParam:...},$$...$$and{aoLastRun:...}tokens are shown as written, because their values are only known when the dataset runs.{aoDynamic...}tokens are shown filled in with the current date and time.- No row limit is added, because the real fetch isn't limited.
- If you see No query could be built for this dataset., the message above it explains what's missing, such as Entity Set is not set on the dataset.