Query and report troubleshooting
AgentZ runs IQA queries in your iMIS site with your iMIS sign-in, so a query returns the records iMIS lets that staff account see. Use this article when your AI app says a query or report returned nothing, or less than you expected.
Your AI app says the query returned no rows
Section titled “Your AI app says the query returned no rows”Check the following:
- Whether the query returns rows in iMIS. In your iMIS staff site, open the query under RiSE > Intelligent Query Architect and run it. If it is empty there too, the query itself, or its filters, find nothing.
- The query’s filters and prompts. A filter such as a date range, a member type or a status can exclude every record. Ask your AI app which filters and values it used.
- The query’s sources and your access to them. Some IQA sources and folders are limited to iMIS security groups. If your staff account is not in the group, iMIS returns nothing to you, and to AgentZ.
- Which iMIS site AgentZ is in. The sidebar shows the site in use. A test site may not hold the same records as your live site.
- Who AgentZ is signed in as. Settings > iMIS, step 2 iMIS sign-in, shows the Saved username. The query runs as that person.
Your AI app says the query could not be found
Section titled “Your AI app says the query could not be found”Check the following:
- The query’s path in iMIS, for example
$/Common/Queries/…. Ask your AI app which path it used, and compare it with the query’s place in Intelligent Query Architect. - That the query is published and that your staff account can open its folder.
The report shows fewer rows than you expect
Section titled “The report shows fewer rows than you expect”- Whether the query, or the request, limits its rows, for example to one page of results. Ask your AI app to return all rows.
- Duplicates or joins. A query that joins to another source can leave out records with nothing to join to. Ask your AI app to explain how the query is built.
For what AgentZ can do with queries and reports, see What AgentZ can do in iMIS.
Why does a colleague get rows when I get none? Their iMIS security groups may differ from yours. Compare your access with whoever looks after iMIS.
Does running a query change anything in iMIS? No. Running a query only reads records.

