Complex Dynamique filter

[MalikB]

Hello! Thanks in advance for thoses who can really help me im asked to do Dynamic Filters: Depending on the profile in field 4, you must filter the scopes to be proposed (Derogatory, Non-Derogatory, or both):

· Display derogatory position types if: Empty profile or Non-empty profile AND there is a record in the "table_dotation_profils" table with constraints different from "restricted" and type_dotation_tbl="poste_standard_derog" or "poste_non_standard_derog"  and key=derogatoire,value=Oui· Display non-derogatory position types only if: There is a record in the "table_dotation_profils" table with constraints ="db" or "fac" and type_dotation_tbl="poste_standard" or "poste_non_standard" and key=derogatoirevalue=Non for the beneficiary's profile And Profile not empty in both it should return the record from table u_sncf_global linked to u_sncf_global_attributes by u_reference field type string in it and u_number in global type string And for another complex filter of another field dependent of the choices - If 7 = From a specific workstation for individual use --> Display only the perimeters with Type_of_workstation = individual and add for this one only the dynamic filter - If 7 = From a kiosk / Display screen --> Display only the perimeters with Type_of_workstation = Kiosk - If 7 = From a multi-user workstation --> Display only the perimeters with Type_of_workstation = multi-user