Tag: Filters

How to Include Calculated Data in Query Results

September 19, 2017 I've blogged before about the Filter Config and Filter Overrides within Dovetail Agent. I totally dig this feature, as it makes it super easy to customize the queries within the app without having to write code. We know it's easy to show data that comes from a database column within the query results - such as a contact's name or phone number. But what if we wanted to show something that is more dynamic? i.e. something that needs to be calculated?   For example, in the result set for contact queries, what if we wanted to show the number of open cases that a customer has? There's not an existing field in the database that contains this data. The number of open cases needs to be summed up. So how can we do this in a query? SQL Views to…