Dan Bergondy

Create a view with a calculated column to be used in Clarify CRM and Dovetail Agent.

Our customer would like to query all the cases including a column with a calculated number of "open" subcases related to each case record. They want to query for all of the cases that have any open subcases. A normal view would not work because it cannot calculate the count of related object with specified condition. Steps taken. 1. We showed it could be done in SQL (See SQL below). Note the nested SQL statement to calculate the number of open subcases. select c.objid, c.id_number, cond.title, cond.title, (SELECT count( * ) FROM table_subcase sc...
read more
Permalink: Thursday, December 20, 2007 3:27 PM
Posted by dbergondy | 2 Comments

Dovetail Software Blogs