Handy MsSQL Snippets

Force Items To Top Of Order By
ORDER BY
    CASE
        WHEN guide_item_text like '%condemnation%' then '1' + guide_item_text
ELSE '2' + guide_item_text
    END DESC

Handy Crystal Report Snippets

For Formatting Month Name

if ToText({%Month}) = 'Dec' then 'December'
else if ToText({%Month}) = 'Jan' then 'January'
else if ToText({%Month}) = 'Feb' then 'February'
else if ToText({%Month}) = 'Mar' then 'March'
else if ToText({%Month}) = 'Apr' then 'April'
else if ToText({%Month}) = 'May' then 'May'
else if ToText({%Month}) = 'Jun' then 'June'
else if ToText({%Month}) = 'Jul' then 'July'
else if ToText({%Month}) = 'Aug' then 'August'
else if ToText({%Month}) = 'Sep' then 'September'
else if ToText({%Month}) = 'Oct' then 'October'
else if ToText({%Month}) = 'Nov' then 'November'

Great Links

http://www.ascii.cl/htmlcodes.htm

Accela Add New Event

1. Enable event in AA Admin --- Events --- Events and associate it with the appropriate script
2. Add EMSE activation code to AA Admin --- Standard Choices --- Event Name EMSE to EMSE 
1. ContactAddAfter
2. true ^ branch("CAA:" + appTypeArray[0] + "/*/*/*")
3. true ^ branch("CAA:" + appTypeArray[0] + "/" + appTypeArray[1] + "/*/*")
4. true ^ branch("CAA:" + appTypeArray[0] + "/" + appTypeArray[1] + "/" + appTypeArray[2] + "/*")
3. Add standard Choice catch --- CAA:Enforcement/Vacant Property/NA/NA
1. true ^ showDebug = false, showMessage = false;
2. isTaskActive("Property Remediation") && contactType =="Property Remediation Vendor" ^ updateTask("Property Remediation","Vendor Contacted","Closed by CAA Script","Closed by CAA Script");  updateAppStatus("Remediation","Updated by CAA Script");