Hi Community,
I need to apply the same filter for my Account Lookup. How can I interpret below in esq? Thank you.
Like
1 comments
14:25 Jul 19, 2023
Hello Fulgen,
Please use an example below:
leftExpression = Ext.create("Terrasoft.AggregationQueryExpression", { columnPath: '[Case:Account].Id', aggregationType: Terrasoft.AggregationType.COUNT, }); rightExpression = Ext.create("Terrasoft.ParameterExpression", { parameterDataType: Terrasoft.DataValueType.INTEGER, parameterValue: 1 }); filter = Terrasoft.createCompareFilter(Terrasoft.ComparisonType.GREATER, leftExpression, rightExpression); esq = this.Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "Account" }); esq.addColumn("Name"); esq.filters.add("customFilter", filter); esq.getEntityCollection(function(result) { debugger; console.log(result); });
But replace [Case:Account].Id with the column path from the filter and parameterValue in rightExpression from 1 to the needed value (the value that is used for comparison (>0)). And also add needed columns to the ESQ. Tested locally, returns the same result as the filter.
Show all comments