Reference qualifier

users00024520
Tera Contributor

I need to make this filter, I have "Defined by Supplier" field and Assignment Group field.

The assignment group field has a company field (provider-defined)

When selecting the supplier, the assignment group field only shows me that they are associated with the supplier


It must be a reference qualifier.

 

Samuel9_1-1694648041905.png

 

7 REPLIES 7

Brad Bowman
Kilo Patron
Kilo Patron

If I'm following correctly, you'll want a reference qualifier like this on your assignment group field:

BradBowman_1-1694693395950.png

where 'company' is the name of the field on the group table, and 'supplier' is the name of the field shown on this form, so update those to your field names.  The company field on the group table also needs to be the type of reference, referencing the same table as the supplier field so that it stores the sys_id of the company record, which would match one of the sys_ids stored on the supplier field.

Hello, thank you very much for your answer.

I have added the code but it does not work.


"u_slx_proveedor" is the name of the field of the group table,
"u_slx_proveedor_definido.vendor" is the field that defines the filter.

If the company "Seidor" is chosen in the assigned group field, it should only show us the groups associated with "seidor"

 

 

users00024520_0-1694794805220.png

 

Brad Bowman
Kilo Patron
Kilo Patron

 So "u_slx_proveedor_definido.vendor" is the name of the assigned group list field?  Since this is a list and not a reference, you need IN instead of = in the reference qualifier.  Is u_slx_proveedor on the group table a reference type field, referencing the same table as the assigned group list field?

Hello my friend! 🙂

 

The "Proveedor asignado" field is of type list and has a "Vendor" (Seidor)

The "Grupo asignado" field has a "Proveedor" (Seidor)

The filter:
When selecting a supplier defined with seller Seidor, I am shown only the different groups that have "vendor" seidor

 

users00024520_0-1694800829781.png

 

 

 

 

 

users00024520_1-1694800870785.png