CA Service Management

Expand all | Collapse all

stored query for custom shcema

Jump to Best Answer
  • 1.  stored query for custom shcema

    Posted 10-23-2019 08:34 AM
    Hi Team

    We have a custom dropdown whose schema is 'z_quarter' which has three values 'quarter 1' , 'quarter2' & 'quarter3'

    we want see tickets who has quarter1  selected in dropdown , those tickets will appear only.. so i write below constraint in stored query but its not working.

    z_quarter = 'quarter1'

    #cr_stored_queries
    #ca_sdm_17.1

    Please help



    ​​


  • 2.  RE: stored query for custom shcema
    Best Answer

    Broadcom Employee
    Posted 10-23-2019 10:01 AM
    Since you mentioned that z_quarter ia drop down. I think the value stored on the ticket for that field is not a string but an integer value. So try updating your constraint to:

    z_quarter = z_quarter.quarter1

    OR

    z_quarter = <ID> (where ID is the unique value of the record on the referencing table.


    ------------------------------
    Kind Regards,
    Brian
    ------------------------------