Tag: schemascript

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…

Case Aging, including “pauses”

October 7, 2011 Over the years of working with Clarify, I’ve seen a request come up a few times for calculating case aging, including “pauses”. It’s easy to calculate a total case age. For open cases, it’s the difference between now and the time the case was opened. For closed cases, it’s the difference between case open time and case close time. But what about the workflows where a case can be paused? For example, the customer may go on vacation, or any other myriad of reasons where we want to pause the clock on the case. The common approach to this from an application standpoint is to have a new case Status value of Paused (or something similar), so that we simply change the status to Paused to pause the case, and then change it to something else to…

Schema 101 Webinar Follow-up

May 17, 2011 Big Thanks! to all those that attended today’s webinar on Schema 101. Slides The slides from today’s presentation are available on Slideshare. Recording The webinar recording is available for playback. Links More Info on Dovetail SchemaEditor: http://dovetal.es/dtSchema More Info (and free download) for Dovetail BOLT: http://dovetal.es/dtBolt Schema 201 Interested in a more advanced session? I’m considering doing a Schema 201 session, including items such as SQL Views, Database Flags, Change Fields, Pseudo Relations, MTM tables, ADP in more detail, etc. If this is something you’re interested in – please let me know! I’ll probably only do this if there’s enough interest up front. You can leave a comment here, or drop me an email at gary@dovetailsoftware.com

Reminder: Schema 101 webinar this week

May 16, 2011 Just a little reminder that I will be hosting a webinar on Tuesday of this week covering the basics of your Clarify/Dovetail schema. This will be a good overview for those who are new to a Clarify/Dovetail system, and a good refresher for those who have been around for a while. Topics Schema and database concepts Viewing your schema Editing your schema Schema tools A walkthrough of customizing your schema using SchemaScript Assorted tips and tricks for working with your schema When Thursday, May 17, 2011 11:00 AM - 12:00 PM (Central Time) Register Register at: https://dovetailsoftwareevents.webex.com/dovetailsoftwareevents/onstage/g.php?t=a&d=669385476

Dovetail SchemaEditor vs. ddcomp – or – why is ddcomp so slow?

May 2, 2011 While doing some prep for my upcoming webinar on Clarify/Dovetail Schema 101, I started doing some closer looking into what SchemaEditor and ddcomp actually do under the hood. We’ve had some good reports from customers on how much faster schema changes get applied when using Dovetail SchemaEditor. I knew it as well, but I didn’t really know why. So I put on my Encyclopedia Brown hat and started my investigation. The scenario My test case was pretty simple: add a new column to the case table. A pretty common scenario. Dovetail SchemaEditor I ran SchemaEditor, adding a new x_test_integer column. I examined the logs emitted by SchemaEditor, as well as the SQL Profiler trace. Here are the changes SchemaEditor made to the database: 1. Add the new column to the metadata (adp_sch_info table) INSERT INTO adp_sch_info (…) VALUES…

Webinar: Clarify / Dovetail Schema 101

April 27, 2011 In this complimentary webinar, I’ll be covering the basics of your Clarify/Dovetail schema. This will be a good overview for those who are new to a Clarify/Dovetail system, and a good refresher for those who have been around for a while. Topics Schema and database concepts Viewing your schema Editing your schema Schema tools A walkthrough of customizing your schema using SchemaScript Assorted tips and tricks for working with your schema When Thursday, May 17, 2011 11:00 AM - 12:00 PM (Central Time) Register Register at: https://dovetailsoftwareevents.webex.com/dovetailsoftwareevents/onstage/g.php?t=a&d=669385476 Schema 201 Interested in a more advanced session? I’m considering doing a Schema 201 session, including items such as SQL Views, Database Flags, Change Fields, Pseudo Relations, MTM tables, ADP in more detail, etc. If this is something you’re interested in – please let me know! I’ll probably only do this if there’s…

Using UltraEdit’s function list with Dovetail Schema files

January 31, 2011 A question recently came up on how to use UltraEdit to show the list of all of the objects in a Dovetail SchemaEditor Data Dictionary file. A Data Dictionary file is a complete definition of a schema. As I’ve mentioned in the past, I rarely use complete schema files, preferring instead to work with simpler schemascript files. Although I often use UltraEdit for editing text files, I rarely use UltraEdit for editing XML files. I prefer Visual Studio, with its integrated support for XSD, which gives me intellisense and syntax checking. Regardless, I dove into UltraEdit configuration, and with a bit of help from Sam Tyson, I figured out how to make this work. Function List We’ll use UltraEdit’s function list functionality to make this work. In my version (UltraEdit 16), it’s accessed by the menu: View –> Views/Lists –>…