Configurable and Customizable Queries in Dovetail Agent
November 8, 2016
I’ve talked in the past about the power of queries within Dovetail Agent and how end users can build and use them.In this post, I’ll dive a bit deeper into how queries are configured, and how they can be configured and customized. Query ConfigurationQueries within the app are driven by filter config files. This includes:Adhoc Queries available from the top-level Query menu, including:Work Items (Case/Subcase/Solution/Change Request/Part Request)Accounts, Contacts, Contracts, Employees, Site Parts, SitesCustom queriesTabs that contain filterable queries (such as the Contacts tab on the Site page) Filter Config FilesFilter Config Files are XML files that define:what tables/views are being queriedjoinswhat filters (facets) are available for the user to filter the query bywhat non-facet fields are queried for use in output datawhat output data is returned to the front-end of the application (columns)required privilege to make the entry available in the top-level…