Skip to content

Instantly share code, notes, and snippets.

View gsherman's full-sized avatar

Gary Sherman gsherman

View GitHub Profile
@gsherman
gsherman / activity-codes.dir
Created September 6, 2019 16:05
Activity Codes are simply a single-level application list
Export Object gbst_lst
Unique_Field = title
Where "title = 'Activity Name'"
Actions = Export
export_gbst_element (gbst_lst2gbst_elm)
;
Routine export_gbst_element
Object gbst_elm
To gbst_elm Through $1
@gsherman
gsherman / privileges.dir
Created September 6, 2019 16:04
Priv classes and Dovetail privileges
NO_EXPORT OBJECT ALL;
EXPORT OBJECT privclass
UNIQUE_FIELD=class_name
/*
WHERE "class_name like 'HC%' OR class_name = 'System Administrator'"
*/
ACTIONS = EXPORT
TO x_web_cmd THROUGH privclass2x_web_cmd
NO_EXPORT OBJECT ALL;
EXPORT OBJECT prop_name
/*
WHERE "prop_name in ('Email Log Notes','Phone Notes','Notes Text','Close Case Notes','Activity Name')"
*/
ACTIONS = EXPORT
;
@gsherman
gsherman / zipcode.schemascript.xml
Last active December 9, 2017 02:34
schemascript for zipcode table
<schemaScript xmlns="http://www.dovetailsoftware.com/2006/10/SchemaScript.xsd">
<addTable name="zipcode" id="3555">
<description>Stores zipcodes and related city, state, country, timezone info</description>
<groupName>Customer Srvc Mgr</groupName>
</addTable>
<addColumn name="objid" dataType="Integer" table="zipcode" >
<description>Internal record number</description>
<clarifyGenericFieldID>3</clarifyGenericFieldID>
@echo off
REM Make sure they supplied 1 param - which is the list element name to search for
REM If they didn't, show usage & exit
echo.
echo *** find lists (gbst and hgbst) that have a given element ***
echo.
if "%1" == "" goto usage
@gsherman
gsherman / 703.cbs
Created May 3, 2017 15:45
ClearBasic code to allow a new option (such as SMS) as a valid Notification Preference within the Clarify Classic Client
' Form 703 - Employee form
'
' Allow a new option (such as SMS) as a valid Notification Preference
Option Explicit
Dim normalBizHigh As String
Dim normalBizMid As String
Dim normalBizLow As String
Dim afterBizHigh As String
@gsherman
gsherman / 15250.dat
Created January 10, 2017 22:07
Form 15250. Business Rule Property GUI tool
OBJECT TYPE="window_db", NAME="WINDOW_DB_15250_10.1_dovetail"
UNIQUE_FIELD = id , ver_clarify, ver_customer, locale
FIELDS
title ="Property Names";
id=15250;
top_c=22;
bottom_c=522;
left_c=3;
right_c=728;
flags=0;
using System.Linq;
using Dovetail.SDK.Clarify;
using Dovetail.SDK.Properties;
using Dovetail.SDK.Properties.Functions;
using FubuCore;
namespace Dovetail.PropertyExtensionExamples.Functions
{
// NumberOfOpenChildCasesOnParent
public class NumberOfOpenChildCasesOnParent : IPropertyFunction
@gsherman
gsherman / bizrule.dir
Created December 5, 2016 18:02
Directive file for exporting a business rule
NO_EXPORT OBJECT ALL;
EXPORT OBJECT com_tmplte
UNIQUE_FIELD=title, rule_set,type
WHERE "title = 'test rule' and type = 1"
ACTIONS = EXPORT, DELETE
TO rule_cond THROUGH condition2rule_cond
UNIQUE_FIELD=type, operator, operand1, op1_type, operand2
UNIQUE_RELATION=parentrule2com_tmplte
@gsherman
gsherman / case.activities.filter.config
Last active November 14, 2016 19:47
Case Activities Filter Config. Allows for querying case activities within Dovetail Agent
<filter name="Case Activities" entity="Cases" allowAdhocQueries="true">
<privileges>
<addPrivilege value="Admin" />
</privileges>
<query from="case_alst">
<addFacet key="activity_name" field="act_name" dataType="string" >
<values>
<!-- Make sure this list has a default value! -->