CA Service Management

Expand all | Collapse all

location in datapartition & job title value

Jump to Best Answer
  • 1.  location in datapartition & job title value

    Posted 06-20-2019 07:21 AM


    Hello Team
     2 queries i have

    1.i need to create constraint in dataparition for ca_location table  for VIEW type only.

    following constraint not working as it works fine for category.

    (sym like 'location_name1') OR (sym like 'location_name2')

    what would be correct constraint for location?

    secondly,
    below  is readonly field for designation (jobtitle),...after the ticket save then we can see the designation. but before saving the ticket it doesnot show. what would be correct value?

    <PDM_MACRO name=dtlReadonly hdr="Designation" attr="customer.position" value="$cst.customer.position">


    #caservicedesk17.0 
    #caservicedesk14.1​​​​​


  • 2.  RE: location in datapartition & job title value

    Posted 06-20-2019 11:07 AM
    1. I think the attribute you need to use in the constraint is 'name' or 'location_name', not 'sym'.

    2. Please understand that pre-processor commands (like PDM_MACRO) are resolved at the server before the resulting html page is presented to your browser. On a new ticket the customer is yet to be selected so it is correct that the position does not show for the customer. After selecting the customer when completing the ticket the PDM_MACRO will not be resolved again until the ticket is submitted.

    As well, you do not need the value parameter in the PDM_MACRO. It should be simply this:
    <PDM_MACRO name=dtlReadonly hdr="Designation" attr="customer.position">

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    [City]
    ------------------------------



  • 3.  RE: location in datapartition & job title value

    Posted 06-20-2019 04:08 PM

    Hi Lindsay

    do you mean like this

    name like 'North Region'

    ?


  • 4.  RE: location in datapartition & job title value
    Best Answer

    Posted 06-21-2019 12:00 AM
    Yes, that's correct.

    I'm not sure why you are using the LIKE operator when the literal you are comparing has no wildcard characters. You could also code:

    name = 'North Region'

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    [City]
    ------------------------------



  • 5.  RE: location in datapartition & job title value

    Posted 06-23-2019 05:01 PM
    Hi Lindsay

    thanks for your input..data partition is working for me now..

    for second query,
    let me explain more , our sdm contact are synced with job titles and it should reflect to employee interface ticket page when the user open the ticket form to create the ticket, job title should reflect there before saving.

    same like we have below user id field on employee detail_cr page and when the the user click to create an incident or request, its userid appears. same thing we want for job title also.

    <PDM_MACRO name=dtlTextbox hdr="Staff ID" attr="customer.userid" value="$cst.userid">


  • 6.  RE: location in datapartition & job title value

    Posted 06-23-2019 07:03 PM
    The answer here is the same as I gave you for Job Title. The value is not going to show until after you save the ticket:

    <PDM_MACRO name=dtlReadonly hdr="Staff ID" attr="customer.userid">

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    [City]
    ------------------------------