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

[Rita Coutinho]

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

[Michael Mueller]

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