CA Service Management

 View Only
  • 1.  Data Partition Help

    Posted Mar 15, 2019 03:48 PM

    Hoping someone can help me with my Data Partition query for the following:


    Database Field Settings via Schema Designer and Published

    • table = cr (Request)
    • name = zDC_Call
    • Field Type = SREL
    • SRel Table = bool (Boolean)


    Maintenance tab file set in Request form file

    • cr_maintenance_tab.htmpl
    • <PDM_MACRO name=dtlDropdown hdr="Is this a DC Call" attr="zDC_Call">


    Data Partition Constraint

    • Only set for the DC Analyst Role 
    • Create
    • Call_Req
    • zDC_Call is not null and type = 'R'
    • Error Message: You must make a selection for the DC Call question ... see Additional Info > Maintenance tab below.


    Trying to accomplish

    1. This custom field is only used by the DC Analyst role people, however it is displayed for all roles as I added it to a custom tab (Maintenance) we created at the bottom of the Request form.
    2. I would like this field to be required only for Request tickets and only when the person creating the ticket is logged in using the DC Analyst role.


    Testing Results after adding the DP to the DC Analyst role

    1. logged in as DC Analyst and create request when box is empty ... I get my error message
    2. logged in as DC Analyst and create request when box is set to yes or no ... ticket is created
    3. logged in as DC Analyst and create incident ticket ... I get my error message 
      • why do I get the error message since this is an Incident ticket and in my DP constraint I specified it was only for Request tickets ???



    thank you


  • 2.  Re: Data Partition Help
    Best Answer

    Posted Mar 16, 2019 10:13 AM


    because Incident is outside of contstarint, try this one:

    (zDC_Call is not NULL AND type = 'R') OR (type != 'R')


  • 3.  Re: Data Partition Help

    Posted Mar 18, 2019 11:35 AM

    This worked great ... thank you so much for the help and explanation.