Skip to content

/QueryBuilder/ExecuteQuery ignores filters if ignoreCase is not setΒ #57

@igdmdimitrov

Description

@igdmdimitrov

If there is filtering operand in the queryBuilder expression tree and ignoreCase is not explicitly set, the /QueryBuilder/ExecuteQuery endpoint ignores the operand.

Request with this expression tree returns 29 records:

const tree = new FilteringExpressionsTree(0, undefined, 'Suppliers', ['supplierId']);
tree.filteringOperands.push({
	fieldName: 'supplierId',
	conditionName: IgxNumberFilteringOperand.instance().condition('equals').name,
	searchVal: 5,
});

If we add ignoreCase then there is only a single record:

const tree = new FilteringExpressionsTree(0, undefined, 'Suppliers', ['supplierId']);
tree.filteringOperands.push({
	fieldName: 'supplierId',
	conditionName: IgxNumberFilteringOperand.instance().condition('equals').name,
	searchVal: 5,
	ignoreCase: true
});

Metadata

Metadata

Assignees

Labels

πŸ› bugAny issue that describes a bugβœ… status: resolvedApplies to issues that have pending PRs resolving them, or PRs that have already merged.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions