Multi select Lookup field Filter

Hi Team,
I have implemented a multi-select lookup field using the guidelines from this article:
https://customerfx.com/article/invoking-a-multi-select-lookup-dialog-on-a-creatio-freedom-ui-page/
Now, I have a requirement to filter the multi-select lookup based on another lookup field. I tried adding a filter for the entity schema name, but it is not being reflected. Is there a way to filter the multi-select lookup?



Like 1

Like

1 comments
Best reply

You can add the filterConfig to the request. Something like this, first create the filter(s): 

const filter = new sdk.FilterGroup();
await filter.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, "UsrColumn", "Value");
 
// workaround for filters required in Creatio 8.1.0 and older
const newFilter = Object.assign({}, filter);
newFilter.items = filter.items;

Then add them in the request, something like this: 

entitySchemaType: "UsrMyLookupObject",
filtersConfig: {
	filterAttributes: [{
		name: "MyFilter",
		loadOnChange: false
	}],
	attributesConfig: {
		MyFilter: {
			value: newFilter
		}
	}
},

See additional examples here: https://community.creatio.com/questions/filter-crtopenlookuppagerequest

Ryan

You can add the filterConfig to the request. Something like this, first create the filter(s): 

const filter = new sdk.FilterGroup();
await filter.addSchemaColumnFilterWithParameter(sdk.ComparisonType.Equal, "UsrColumn", "Value");
 
// workaround for filters required in Creatio 8.1.0 and older
const newFilter = Object.assign({}, filter);
newFilter.items = filter.items;

Then add them in the request, something like this: 

entitySchemaType: "UsrMyLookupObject",
filtersConfig: {
	filterAttributes: [{
		name: "MyFilter",
		loadOnChange: false
	}],
	attributesConfig: {
		MyFilter: {
			value: newFilter
		}
	}
},

See additional examples here: https://community.creatio.com/questions/filter-crtopenlookuppagerequest

Ryan

Show all comments