Reference qualifier
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-13-2023 04:36 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-14-2023 05:12 AM
If I'm following correctly, you'll want a reference qualifier like this on your assignment group field:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2023 09:27 AM
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2023 10:59 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2023 11:08 AM
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