Question

CREATE MULTIPLE FILTER CONDITION FOR LOOK UP

Fulgen Ninofranco

16:14 Sep 18, 2018

I Have an exisiting filter

var filter =

this.Terrasoft.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL,

"Name", "Motherboards");

Name = Motherboards

Now I want to create multiple filter like:

Name = Motherboards or Name = Graphics Card or Name = Mouse

How can i do this one?

1 comments

Tetiana Markova

09:29 Sep 19, 2018

Hello,

You need to create a filter group and set OR logical operator.

Please, see my example:

var filterGroup = this.Terrasoft.createFilterGroup();

filterGroup.logicalOperation = this.Terrasoft.LogicalOperatorType.OR;

filterGroup.add("MotherboardsFilter", this.Terrasoft.createColumnFilterWithParameter(

                   this.Terrasoft.ComparisonType.EQUAL,

                   "Name", "Motherboards");

filterGroup.add("GraphicsFilter", this.Terrasoft.createColumnFilterWithParameter(

                   this.Terrasoft.ComparisonType.EQUAL,

                   "Name", "Graphics");

filterGroup.add("MouseFilter", this.Terrasoft.createColumnFilterWithParameter(

                   this.Terrasoft.ComparisonType.EQUAL,

                   "Name", "Mouse");

You can find more examples in the documentation - https://academy.bpmonline.com/documents/technic-sdk/7-12/entityschemaqu…

Show all comments