I'm building a new model which will have a filters section with 3 pre defined filter that belong to known fields in the Data scheme.
another 3 fields that will be used as filters are unknown at the beginning, and only if the customer maps his own fields into them in the the Database they will have values inside and will be shown.
The architecture will look like this:
And Dim1,Dim2,Dim3 are either used or not. If they are used, they will be mapped with values from other tables, and there will be a meta data table that will hold the name of the mapped field and whether it should be used in the UI, for example:
At the beginning the filters in the model will show only the Date, Gender and birthday, while dim1, dim2,dim3 will be hidden.
I have 2 questions:
1) How can I change the name of the filter of dim1 to ValueSegment automatically without getting inside the code?
2) How can I hide or un-hide the filters according to their mapping?
Not sure if I understand what you are trying to do.
You can create a MAPPING table MapFieldNames from your metaData, then
RENAME FIELDS using MapFieldNames;
Alternatively, create a logic as I shown above to just show Dim1, etc. in list boxes, use the mapped field names as Title in the list boxes and check the available mappings to enable conditional show / hide in list box properties.
I would need to check if and how you can dynamically disable single fields from a multi box.
In general, it's easier to understand your request and to create a possible soultion, if you could upload a small sample QVW.