Ref Qual not working

Idan Ben Yehuda
Tera Contributor

Hello.

 

I have a 'Contact' table with The fields: Portal Domain, and Portal Group.

They are both part of 'sys_group' table.

 

Portal Domain doesn't have a parent

and Portal Group has a parent (one of the domains).

 

The Group choice list is defined by the Domain value.

 

This all works.

 

I want to show those field on another table called 'Case' which has a Contact field.

I added those fields to the Case list view

 

However the Ref qualifier doesn't work there.

 

what can I do? 

 

 

 

1 REPLY 1

Tony Chatfield1
Kilo Patron

Hi, unfortunately your post does not make your configuration clear and I suspect by sys_group table you mean sys_user_group?

Based on your description, for the 'case' table I think your query would need to dot.walk the 'contact' record,

so something like 'parent=' + current.contactField.targetField;