CA Service Management

Expand all | Collapse all

Quick profile: tab with query using BREL field (child_hier)

  • 1.  Quick profile: tab with query using BREL field (child_hier)

    Posted 08-03-2018 07:12 AM

    Hi,

     

    We are trying to create a new tab in Quick Profile that will show all dependent CIs of a given CI that is related to the searched contact.

     

    We are trying the following search clause:

     

    pb_link("*Tab Name*", "list_nr", "nr", "QBE.EQ.cntref.cnt.id=$dobref.id+QBE.EQ.delete_flag=0+KEEP.forCntQP=1+KEEP.noCreateBtn=1+QBE.EQ.id.[parent]child_hier.child.name=*CI Name*" );

     

    However, it is not returning any results when it should. 

     

    We have tried this using the "additional search" field in the Service Desk forms for CI search, with the following where clause,

     

       id.[parent]child_hier.child.name=*CI Name*

     

    and it doesn't work either, however, for other BREL fields we have tried this syntax and it works.

     

    Has anyone had this problem?

     

    Thanks



  • 2.  Re: Quick profile: tab with query using BREL field (child_hier)

    Posted 08-15-2018 09:00 AM

    Hi.

    let us start with the "additional search" parameter:

    I understand that you have tried :

    id.[parent]child_hier.child.name=*CI Name*

     

    I am not sure about the real intention here :Are the stars (*) part of the name of the child CI ? Or are they intended to be wildcards ?

    In any case you should surround the literal with single quotes, so something like 

    id.[parent]child_hier.child.name='*CI Name*'

     

    for wildcard search I would use "like" instead of "=" and "%" instead of "*", for example

    id.[parent]child_hier.child.name like '%CI Name%'

     

    Let me know if this works for you. we might be able then to proceed to the tab question....

    Regards

    .........Michael