Custom Queries

Sometimes, DevResults doesn't provide you the information you want in the exact way you need. For example: perhaps you need a specific export of your Activities list for status review meetings, or you want to see a list of all activities that report on certain indicators and the provinces those activities work in.

When you have these questions or requests and it's not something supported by Pito or the existing exports on various pages, your site administrator can request a custom query be created and made available to your site. You define what you need; we build and save the query for you; and you can run it at any time in the site itself or download the results into Excel.

If you have custom queries in your site, they're really easy to access and run. Go to the Administration menu and click on Custom Queries.

Note: If you do not see Custom Queries in your Administration menu, you do not have permission to access this feature. Contact your site administrator to gain access.

This will open a page displaying all the custom queries in your site that you have access to:

From here, you have a couple options:

  1. If you know this is the query you want and you just need it in Excel, you can click the Download button to prompt a download of the query's current results into Excel.
  2. If you want to preview the query's results, you can click the View button. This will display what the export will contain; you can then download from there:

Didn't answer your question? Please email us at