User Documents Help Center
< All Topics

How To Build Custom Queries


Every CUSTOM QUERY needs instructions (criteria) that the FileOnQ Platform will follow when searching data for thespecific information you’re seeking. Most queries require several sets of criteria, which the system runs in a sequence (i.e. ‘first search for this, then eliminate that, then narrow it down to this). Some steps seek to include desired information, while other steps seek to exclude unwanted information.

For example, you might build a query to locate all of the firearms in the FileOnQ Platform, BUT, you only want to locate the firearms that are currently being stored, so you instruct the system to exclude all records for guns that have already been released to the owner, destroyed, or permanently removed otherwise from your control. Each set of criteria is put together using the CUSTOM QUERY tools, and each set is then added to the query, one by one, so that all necessary instructions will be followed by the system to bring back the specific data you want.

Skip to content
Protected by CleanTalk Anti-Spam