Read Data in AGENT
QUERY is now a read-only capability inside AGENT, not a separate selectable mode. Ask a question about your FileMaker data and specify the output you want when it matters.
Examples
Section titled “Examples”- “Show monthly invoice totals for this year as a table.”
- “Chart open support tickets by priority.”
- “Check whether any customer records are missing an email address.”
- “Compare this quarter with the previous quarter.”
Workflow
Section titled “Workflow”- Open AGENT.
- Ask the data question in ordinary language.
- Name the relevant table occurrence, fields, filters, grouping, and desired output when known.
- AGENT discovers or reads the needed metadata and uses read-only
SELECTSQL. - Review the answer, table, chart, or raw result.
Read-only Query is included for free. It cannot update records or schema.
Accuracy tips
Section titled “Accuracy tips”- Use exact table-occurrence and field names for critical reports.
- State date ranges, status filters, and grouping rules explicitly.
- Ask AGENT to show the assumptions behind an important result.
- Validate targeting with a read-only query before requesting a related DATA write.
Query versus DATA
Section titled “Query versus DATA”Query reads. DATA writes. If your request would change records or schema, AGENT must use the reviewed DATA capability instead. Coding Access is required for the exact executable write plan and Execute action.