View Issue Details

IDProjectCategoryView StatusLast Update
0002555Feature RequestsFeature Requestpublic2022-08-23 16:46
ReporterMatthias Damm Assigned ToJim Luth  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Summary0002555: Enhancement of FilterOperators
Description

IEC edition 2 review had the following useful feature requests:

(1) Missing NotEquals operator. The lack of the operator means that one has to define an additional element. => More complex, Less performant. Most programming languages supports the NotEquals operator anyway

(2) Missing BitwiseEquals operator to be able to filter on bitflags in a simple and efficient way.
Would be nice with an example on usage of BitwiseOR.
BitwiseAnd does not evaluate to true or false, which all other operations do except for the Cast operator. Hence a complex filter expression involving more than one filter element is required to filter on a bit in a single attribute. Also the fact that the operator does not evaluate to a Boolean also may have performance impact (requires an assignment instead of just a comparison).

(3) Why restrict And to only take 2 operands?
Generalizing the And operator to take any number of operands would allow for more fluent filter specifications.

(4) Why restrict Or to only take 2 operands?

Additional Information

This is a future feature request since changing the operators would be an interoperability issue.

IEC feedback:

Accepted in general
It is possible to get this functionality with existing operators but it would be a simplification for clients to have this new operator.
Since adding this operator is an interoperability issue it makes only sense to add this operator in the future together with operators that cannot be covered with existing ones.

TagsNo tags attached.
Commit Version
Fix Due Date

Activities

Matthias Damm

2013-10-10 23:03

developer   ~0005055

Based on Like case sensitivity discussion at Dallas F2F:
Create new operators for Upper and Lower on Strings

Jim Luth

2015-10-09 07:46

administrator   ~0006327

Wait for other breaking changes to implement these convenience operators.

Jim Luth

2022-08-23 16:43

administrator   ~0017377

Agreed most of these capabilities can be built from the existing primitives and these requested enhancements will not be undertaken as there is almost no implementations of Query.

Jim Luth

2022-08-23 16:44

administrator   ~0017378

Bitwise AND and OR have already been added to Part 4.

Jim Luth

2022-08-23 16:46

administrator   ~0017379

Bitwise operators added to Part 4 long ago.

Issue History

Date Modified Username Field Change
2013-07-30 17:02 Matthias Damm New Issue
2013-08-13 17:01 Jim Luth Status new => acknowledged
2013-10-10 23:03 Matthias Damm Note Added: 0005055
2015-10-09 07:46 Jim Luth Note Added: 0006327
2022-08-23 16:43 Jim Luth Note Added: 0017377
2022-08-23 16:44 Jim Luth Note Added: 0017378
2022-08-23 16:46 Jim Luth Category (No Category) => Feature Request
2022-08-23 16:46 Jim Luth Assigned To => Jim Luth
2022-08-23 16:46 Jim Luth Status acknowledged => closed
2022-08-23 16:46 Jim Luth Resolution open => fixed
2022-08-23 16:46 Jim Luth Note Added: 0017379