Versions Compared

Old Version 3

changes.mady.by.user Christopher Stärkel

Saved on

compared with

New Version Current

changes.mady.by.user Nestor Eciolaza

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

!=

Does not

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

starts with

String

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

Filtering examples

Filter

Meaning

"Name==*pc-pool|myname"

Retrieve DTOs

having

containing Name that equals to "pc-pool" or "myname" strings comparing case-insensitive.

"Name@=*pc|po|ol"

Retrieve DTOs having Name containing "pc" or "po" or "ol" strings comparing case-insensitive.

"FloorId==153,Name!@=00,Number_=0008"

Retrieve DTOs

wich

which have FloorId equal to 153 and Name not containing "00" and Number starts with "0008".

"Name>=0005,Number<7,Description@=S|e,Description!_=*e,Id!=258"

Retrieve DTOs

wich

which have their Name greater than or equal to "0005" string

comparisson

comparison and Number less than 7 and Description contains "S" or contains "e" and Description does not start with "e" comparing case-insensitive and Id is not equal to 258.

"Modified>2013-01-01,Modified<=2013.12.31 14:13:34,Name!@=*.,Id==287|613|614"

Retrieve DTOs

wich

which have the Modified property between 2013-01-01 00:00:00.0000 and 2013-12-31 14:13:34.0000, and their Name doesn´t contain a dot ("." character) comparing case-insensitive, and Id can be equal to 287 or 613 or 614.

"Description!=00,FloorId<160,Comment! =*kELLER,Name =*20,Name@ =*8|9,ModifiedBy = =*Johny Smith"

Retrieve DTOs wich have Description property not starting with "00" and FloorId is lesser than 160 and Comment is not equal to kELLER comparing case-insensitive, and Name starts with 20 comparing case-insensitive, and Name contains "8" or "9" comparing case-insensitive and ModifiedBy is equal to "Johny Smith" comparing case-insensitive.

ParentComponentId**@

Example of filtering by related entities (foreign keys). Retrieve DTOs (in this case components) which don´t have a Parent Component relationship. Using IsNull filter on a foreign key can be used to find non existent relationships.

ComponentDefinitionName@=Cisco

Example of filtering by related entities (foreign keys). Retrieve DTOs (in this case components) which Component Definition Name contains Cisco.