Skip to content

Data queries

A data query is a saved question against Fishbowl that you run whenever you need it. ILC MCP writes and saves the query; you run it by name, filling in whatever it asks for — a date range, a location, a customer.

Use one when you want the same list again and again without re-explaining it: open orders by rep, low-stock parts, this month’s shipments.

Describe the list and say you want to keep it.

Save me a query for all open sales orders, so I can run it by customer whenever I want.

Make a reusable report of parts below their reorder point, with location as a parameter.

ILC MCP writes the query, names it, and saves it. It tells you what the query asks for when it runs — for example, a location or a date range.

Once saved, a data query is yours to run any time. Ask for it by name and give the values it needs:

Run the open sales orders query for Acme Foods.

The answer comes back in the chat. Running a saved query is read-only — it never changes Fishbowl — so it needs no approval.

You can save and run only the queries your access allows. Ask “what saved queries can I run?” to see the list and what each one needs.