SDU - User contributions [en]

Crystal Reports

2008-04-03T16:36:32Z

Komodo: New page: == Crystal Formula Examples == '''Analyst''' (Example for Contacts) if IsNull ({ca_contact.last_name}) then "UNASSIGNED" else if IsNull ({ca_contact.first_name}) ...

== Crystal Formula Examples ==

'''[[Analyst]]''' (Example for Contacts)

if IsNull ({ca_contact.last_name})
then "UNASSIGNED"
else
if IsNull ({ca_contact.first_name})
then Uppercase ({ca_contact.last_name})
else Uppercase ({ca_contact.last_name} + ", " + {ca_contact.first_name})

'''[[CloseDate]]''' (Example for Requests)

''Note: Be sure the u2lpdmtime.dll is avaible for such calls''

PDMTimeToDateTime ({call_req.close_date})

'''[[OpenDate]]''' (Example for Requests)

''Note: Be sure the u2lpdmtime.dll is avaible for such calls''

PDMTimeToDateTime ({call_req.open_date})

'''[[TimeOpen]]''' (Example for Requests which Utilizes 'CloseDate' formula)

''Note: Be sure the u2lpdmtime.dll is avaible for such calls''

if isnull ({@CloseDate})
then ((DateTimeToPDMTime (CurrentDateTime) - {call_req.open_date})/60/60/24)
else ((DateTimeToPDMTime ({@CloseDate}) - {call_req.open_date})/60/60/24)

'''[[Category]]''' (Example for Request Area)

if isnull ({prob_ctg.sym}) OR {prob_ctg.sym} = ""
then "Currently no category specified"
else {prob_ctg.sym}

Sample Queries

2008-04-03T15:54:22Z

Komodo: /* SQL Query for Request Area */

'''
== SQL Query for Request Area ==
'''

''To obtain the most current listing, from the SQL Query Analyzer run the following query on the MDB.''

'''SELECT prob_ctg.persid, prob_ctg.sym, prob_ctg.description FROM [dbo].[prob_ctg] WHERE (prob_ctg.del = 0)'''

''This query will return a list of persistent ID's, Symbols (Request Areas) and Descriptions from SQL. Only ACTIVE Request Areas will be displayed by this query.''

----
== SQL Query Reference for Contact Types ==

''-- Select all Contact Types (ca_contact_type)''

'''SELECT id, name FROM dbo.ca_contact_type'''

''-- Select all Groups from (ca_contacts) ''

'''SELECT contact_uuid, last_name, contact_type FROM ca_contact
WHERE contact_type = 2308'''

''-- Select all Analysts from (ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2307'''

''-- Select all Customers and Employees from (ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2305 or contact_type = 2310'''

''-- Select all NULL contact_type(ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type is NULL'''

''-- Select all Help Desk from (ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2306'''

''-- Select all Managers from (ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2301'''

''-- Select all Operators from (ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2300'''

''-- Select all Technician from (ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2304'''

''-- Select all Users from (ca_contacts)''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2302'''

''-- Select all Vendors from (ca_contacts) ''

'''SELECT contact_uuid, last_name, first_name, contact_type FROM ca_contact
WHERE contact_type = 2303'''

Sample Queries

2008-04-03T14:37:24Z

Komodo: /* SQL Query for Request Area */

Sample Queries

2008-04-03T14:35:56Z

Komodo:

Sample Queries

2008-04-03T14:34:19Z

Komodo: SQL Query for Request Areas

To obtain the most current listing, from the SQL Query Analyzer run the following query on the MDB.

SELECT prob_ctg.persid, prob_ctg.sym, prob_ctg.description
FROM [dbo].[prob_ctg]
WHERE (prob_ctg.del = 0)

This query will return a list of persistent ID's, Symbols (Request Areas) and Descriptions from SQL. Only ACTIVE Request Areas will be displayed by this query.

Yellow Pages:Appia Incorporated

2008-02-22T18:56:20Z

Komodo:

[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]

----

'''''Unparalleled Complete Life-Cycle Solutions . . . Your Complete Solution!''

Yellow Pages:Appia Incorporated

2008-02-22T18:56:04Z

Komodo:

[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]

'''''Unparalleled Complete Life-Cycle Solutions . . . Your Complete Solution!''

Yellow Pages:Appia Incorporated

2008-02-22T18:49:44Z

Komodo:

[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]

'''''Unparalleled Complete Life-Cycle Solutions . . . [[Image:AppiaEngage.gif|APPIA-Your 360degree Solution!|1-800-60-APPIA]]''

File:AppiaEngage.gif

2008-02-22T18:46:09Z

Komodo:

Yellow Pages:Appia Incorporated

2008-02-22T18:45:43Z

Komodo:

[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]
----

== '''''Unparalleled Complete Life-Cycle Solutions . . . [[Image:AppiaEngage.gif|APPIA-Your 360degree Solution!|1-800-60-APPIA]]. . . .Your 360-degree Solution!''==

Yellow Pages:Appia Incorporated

2008-02-22T18:36:07Z

Komodo:

[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]
----

== '''''Unparalleled Complete Life-Cycle Solutions . . . . . . .Your 360-degree Solution!''==

Yellow Pages:Appia Incorporated

2008-02-22T18:34:45Z

Komodo:

[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

[[Image:Appia Incorporated print2.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]
We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]
----

== '''''Unparalleled Complete Life-Cycle Solutions . . . . . . .Your 360-degree Solution!''==

Yellow Pages:Appia Incorporated

2008-02-22T18:32:34Z

Komodo:

[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]
----

== '''''Unparalleled Complete Life-Cycle Solutions . . . . . . .Your 360-degree Solution!''==

Yellow Pages:Appia Incorporated

2008-02-22T18:29:37Z

Komodo: /* '''APPIA INCORPORATED 1-888-60-APPIA''' */

Appia Incorporated
[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]
----

== '''''Unparalleled Complete Life-Cycle Solutions . . . . . . .Your 360-degree Solution!''==

File:Appia Incorporated.png

2008-02-22T18:27:06Z

Komodo:

Yellow Pages:Appia Incorporated

2008-02-22T18:24:26Z

Komodo:

Appia Incorporated
[[Image:Appia_Incorporated.png|APPIA-Your 360degree Solution!|1-800-60-APPIA]]

== '''APPIA INCORPORATED 1-888-60-APPIA''' ==
=== '''360-degree Vision: Engage . . . Execute . . . Empower''' ===

We have been working with Computer Associates Product Suites since 1996, when CA acquired Paradigm as part of the Legent acquisition. We have architected, developed, and deployed hundreds of business solutions since that time.

'''Our Team's proficiencies span through the CA product sets as well as custom and third-party integrations.'''

*Architecture
*Compliance
*Workflow
*Software Customization and Specialized Development
*Integration
*Education and Training
*Business Process Guidance
*Technical Support

'''Contact Us Today! 1-888-602-7742 '''
;Technical Support
: [mailto:support@appia.us support@appia.us]
;Sales Team
: [mailto:sales@appia.us sales@appia.us]
;Opportunities
: [mailto:hr@appia.us hr@appia.us]
----
== '''''Unparalleled Complete Life-Cycle Solutions . . . . . . .Your 360-degree Solution!''==

Automatically Set Assignee to Closing Analyst

2008-02-07T03:02:09Z

Komodo: /* Step 3. Publish the Schema changes */

This article provides instructions for having system generated [[Activity|Activities]] set to ''Internal'' so it cannot be viewed by users of the Employee or Customer Interfaces.

== Step 1. Create the script ==
A script is created as an [[.spl file]] and placed in the [[NX_ROOT]]/site/mods/majic directory. When the Service Desk service starts, the contents of the majic directory are processed and cached. You can use any naming scheme you like for your [[.spl file]], but it is recommended that the file be preceded with a 'z' for easy identification as a custom file (eg zMyCompany.spl, zcr_scripts.spl, zMyScripts.spl).

<source lang="javascript">// Use 'cr' for Requests, Incidents & Problems, 'chg' for Changes, and 'iss' for Issues
cr::zmyscript(...){
if(is_null(assignee)){
// Use 'int' in place of 'uuid' in the line below if for pre-r11 releases
uuid userid;
send_wait(0, top_object(), "call_attr", "cr", "current_user_id");
userid = msg[0];
assignee = userid;
}
}</source>

The trigger that will be created in step 2 is the first level filtering. If you need further filtering then utilize an [[if statement]] in the [[spel code]] above.

== Step 2. Create the trigger ==
This step is to create the trigger that will initiate the script. The methods used to implement the trigger vary based on the Service Desk release. In the examples to follow, the trigger is designed to fire if the [[Status]] is being changed to 'Resolved'. Use whatever filter you like for attaching your [[Event|event]].

For r11.x releases triggers are created via the [[Schema Designer]] utility. Simply add the following code as a [[Site-Defined Trigger]] to the '''[[cr|cr (Request)]]''', '''[[chg|chg (Change Order)]]''', or '''[[iss|iss (Issue)]]''' table.
POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});
 
For older releases triggers are made by creating a [[.mod file]] and placing it in the [[NX_ROOT]]/site/mods/majic directory. Name the [[.mod file|.mod]] anything you like, but it is recommended that it be preceded with a 'z'.

MODIFY cr POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});
MODIFY chg status POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});
MODIFY iss status POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});

== Step 3. Publish the Schema changes ==
The methods used to publish schema changes vary based on the Service Desk release.

For r11.x releases, follow these steps:
#Save and Publish your Schema changes (under File menu of Schema Designer)
#Stop the Service Desk service
#Run [[pdm_publish]] from a command line
#Start the Service Desk service

For older release recycle the Service Desk service.

----
<div align='center'>To make corrections or additions to this article, select the ''edit'' tab above. 
To discuss or ask questions about this article, select the ''discussion'' tab above.</div>

[[Category:Customizations]]

Automatically Set Assignee to Closing Analyst

2008-02-07T03:01:12Z

Komodo: /* Step 2. Create the trigger */

This article provides instructions for having system generated [[Activity|Activities]] set to ''Internal'' so it cannot be viewed by users of the Employee or Customer Interfaces.

== Step 1. Create the script ==
A script is created as an [[.spl file]] and placed in the [[NX_ROOT]]/site/mods/majic directory. When the Service Desk service starts, the contents of the majic directory are processed and cached. You can use any naming scheme you like for your [[.spl file]], but it is recommended that the file be preceded with a 'z' for easy identification as a custom file (eg zMyCompany.spl, zcr_scripts.spl, zMyScripts.spl).

<source lang="javascript">// Use 'cr' for Requests, Incidents & Problems, 'chg' for Changes, and 'iss' for Issues
cr::zmyscript(...){
if(is_null(assignee)){
// Use 'int' in place of 'uuid' in the line below if for pre-r11 releases
uuid userid;
send_wait(0, top_object(), "call_attr", "cr", "current_user_id");
userid = msg[0];
assignee = userid;
}
}</source>

The trigger that will be created in step 2 is the first level filtering. If you need further filtering then utilize an [[if statement]] in the [[spel code]] above.

== Step 2. Create the trigger ==
This step is to create the trigger that will initiate the script. The methods used to implement the trigger vary based on the Service Desk release. In the examples to follow, the trigger is designed to fire if the [[Status]] is being changed to 'Resolved'. Use whatever filter you like for attaching your [[Event|event]].

For r11.x releases triggers are created via the [[Schema Designer]] utility. Simply add the following code as a [[Site-Defined Trigger]] to the '''[[cr|cr (Request)]]''', '''[[chg|chg (Change Order)]]''', or '''[[iss|iss (Issue)]]''' table.
POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});
 
For older releases triggers are made by creating a [[.mod file]] and placing it in the [[NX_ROOT]]/site/mods/majic directory. Name the [[.mod file|.mod]] anything you like, but it is recommended that it be preceded with a 'z'.

MODIFY cr POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});
MODIFY chg status POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});
MODIFY iss status POST_VALIDATE zmyscript() 111 FILTER(EVENT("UPDATE") && status{->'CL'});

== Step 3. Publish the Schema changes ==
The methods used to publish schema changes vary based on the Service Desk release.

For r11.x releases, follow these steps:
#Save your Schema changes
#Stop the Service Desk service
#Run [[pdm_publish]] from a command line
#Start the Service Desk service

For older release recycle the Service Desk service.

----
<div align='center'>To make corrections or additions to this article, select the ''edit'' tab above. 
To discuss or ask questions about this article, select the ''discussion'' tab above.</div>

[[Category:Customizations]]