Greetings,
I have 2 lookup filters: Province and CSO. I want to filter the values displayed in CSO based on the value choosen in ProvinceList. Please note that this is in a section page so using businessrules wont apply
"ProvinceList": {
dataValueType: this.Terrasoft.DataValueType.LOOKUP,
type: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
caption: { "bindTo": "Resources.Strings.ProvinceCaption" },
hideActions: true,
value: {
value: "",
displayValue: ""
},
isLookup: false,
referenceSchema: {
name: "Region",
primaryColumnName: "Id",
primaryDisplayColumnName: "Name"
},
referenceSchemaName: "Region"
},
"CSOList": {
dataValueType: this.Terrasoft.DataValueType.LOOKUP,
type: Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
caption: { "bindTo": "Resources.Strings.CSOCaption" },
hideActions: true,
value: {
value: "",
displayValue: ""
},
isLookup: false,
referenceSchema: {
name: "CSO",
primaryColumnName: "Id",
primaryDisplayColumnName: "Name"
},
referenceSchemaName: "StCSO"
},
Like
Hello Mohammad,
You can add a lookupListConfig with a filter that adds an ESQ filter to the definition for CSOList based on the value from ProvinceList as described here:
https://customerfx.com/article/filtering-lookups-in-creatio-formerly-bpmonline/
Ryan