...
Whenever a value doesn´t have the time specified, it will be considered as 00:00:00:0000
If the same date-time is intended to be included in a range as a result, the from and to values should contain tenths of a second precision (Eg:"Date>=2020/01/01 15:00:00.000,Date<=2020/12/31 23:59:59.9999")
Enumerations considerations:
Whenever an attribute of a DTO is an enumeration, the search can only be done by complete match, it cannot be searched like a string value using partial matches (contains operator). Eg:
Ipaddress
Type
Status
Room
Type
Location
ViewMode
Operator Meaning:
Operator | Description | Applies To |
|---|---|---|
== | Equals to | All types |
!= | Not equal to | All types |
> | Greater than | All types |
< | Less than | All types |
>= | Greater than or equal to | All types |
<= | Less than or equal to | All types |
@= | Contains | All types |
_= | Starts with | String |
!@= | Does not contain | String |
!_= | Does not start with | String |
@@@ | Is empty | String |
!@@@ | Is not empty | String |
**@ | Is null | All types |
!**@ | Is not null | All types |
@*@@ | Is null or empty | All types |
!@*@@ | Is not null or empty | All types |
@=* | Case-insensitive contains | String |
_=* | Case-insensitive starts with | String |
==* | Case-insensitive equals | String |
!=* | Case-insensitive does not equal | String |
!@=* | Case-insensitive does not contain | String |
!_=* | Case-insensitive does not start with | String |
...