Hello,
we need to improve lookup selection for several section. The main idea is to reduce quantity of records for selection, but still give user to search through full list.
We tried to use multiLookup feature to give 2 options: "All products" and "Active products" (like we select Account/Contact in the Order)
"UsrProductLookup": {
"dataValueType": Terrasoft.DataValueType.LOOKUP,
"type": Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
"multiLookupColumns": ["UsrProductA", "UsrProductB"],
"caption": "Product",
"onChange": "setProduct"
},
"UsrProductA": {
"dataValueType": Terrasoft.DataValueType.LOOKUP,
"type": Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
"isLookup": true,
"referenceSchemaName": "Product"
},
"UsrProductB": {
"dataValueType": Terrasoft.DataValueType.LOOKUP,
"type": Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
"isLookup": true,
"referenceSchemaName": "Product"
}
But then got an error, that we cannot use the same object for both lookups.
message: Item with key "Product" Already exists
date: Tue Oct 18 2022 02:01:40 GMT+0400
moduleId: CardModuleV2_02b6b083-3cfa-4daf-a93c-632cb2420805_AccountPageV2_LookupPage
moduleName: MultiLookupModule
How is it possible to use multiLookup for this purpose?
Or what alternative is for user-friendly quick filter in Lookup window?
Thank you.
Vladimir