Share
Report
10Please, help to solve the problem.
I have a table 'List of sites'. It has columns: Site Name - the data in this column is generated by a drop-down list, which is taken from the third table and CCCM agency status - the data is taken from Entity, which is called "CCCM agency status list". In an application that fills out another table, I need to create a ComboBox that will display the Site Name column data, filtered by CCCM agency status.
I tried next code:
Filter(Choices('List of sites'.cr15c_SiteName); Value('CCCM agency status') = "Active level 1")
Where:
- List of sites - Name of the table, from what i took info
- cr15c_SiteName - schema name of the column I want to display in the dropdown list
- CCCM agency status - name of the filtered column
- Active level 1 - Filtering option
In this code I get the error “Incompatible comparison types. It is impossible to compare these types: Control, OptionSetValue (CCCM agency status list)
Where CCCM agency status list - Entity, from what i take options for dropdown for CCCM agency status3 column
How can I solve the type compatibility comparison types problem and how can I edit the code
All responses (
Answers (
