Query shaping lab

Explore four query concepts without an IFS environment. This is a small local simulation, not a live endpoint or complete OData implementation. It does not accept credentials or send requests to an IFS system.

Your challenge

Return two Open records, ordered by Id, showing only Id and Amount. Predict the answer before running it. Read Shape a small data query for the concepts.

SIMULATION · FICTIONAL DATA · NO IFS CONNECTION

Maximum rows

Return these properties

Id Status Amount

Run simulation Reset example

Choose options, then run the simulation.

Example query

Run the simulation to build an example.

Simulated response

[]

View the complete fictional dataset

[
  { "Id": "DEMO-001", "Status": "Open", "Amount": 120 },
  { "Id": "DEMO-002", "Status": "Completed", "Amount": 60 },
  { "Id": "DEMO-003", "Status": "Open", "Amount": 80 },
  { "Id": "DEMO-004", "Status": "Cancelled", "Amount": 40 },
  { "Id": "DEMO-005", "Status": "Open", "Amount": 200 }
]

Check your result

The challenge returns DEMO-001 with amount 120 and DEMO-003 with amount 80. There are three matching Open records, but the limit returns only two. Try sorting by Amount and explain why the returned order changes.

Take it to a real environment

Discover the actual service contract and supported options first. Follow documented pagination and authorization rules. The fictional collection name above is not an IFS API.

Reference: OData basic tutorial.