Command Reference > Infacmd dis Queries > Comparison Operators
  

Comparison Operators

Use the comparison operators with query parameters to build a query. You can use comparison operators to specify criteria when you query objects.
The following table lists the comparison operators that you can use with each type of query parameter:
Query Parameter Type
Includes Query Parameters
Comparison Operators
Examples
Subject
name
tag
createdBy
lastModifiedBy
~contains~
~not-contains~
~not-ends-with~
~not-starts-with~
~ends-with~
~starts-with~
=
!=
~in~
~not-in~
name ~contains~ Mapping
tag ~in~ (tg_1, tg_2, tg_3)
createdBy = Administrator
lastModifiedBy ~ends-with~ visitor
Subject
object
type
=
!=
~in~
~not-in~
type = Mapping
object != Mapping
objectin(P1/F1/Map1,P2/F1/Map2)
Time
lastModifiedTime
checkInTime
checkOutTime
creationTime
>
<
~within-last~
~between~
~not-between~
lastModifiedTime < 2019-02-26 20:32:54
checkInTime ~between~ (2018-12-26 20:32:54, 2018-05-26 20:32:54)
checkOutTime ~within-last~ 10 (days)
Status
versionStatus
~is-checkedin~
~is-checkedout~
versionStatus ~is-checkedin~
versionStatus ~is-checkedout~
Location
folder
project
application
~contains~
~not-ends-with~
~not-contains~
~not-starts-with~
~ends-with~
~starts-with~
=
!=
~in~
~not-in~
name ~contains~ Mapping where project ~ends-with~ _1
lastModifiedBy ~ends-with~ trator where folder ~not-in~ (Folder_3, Folder_2)
all where project=Project_1, folder=Folder_1
name = Mapping where project=Project_1, folder=/Folder_1/Folder_2/
name = Mapping where project=Project_1, folder=/
name = captain_america where app~in~ (MapGenTest, MapGenEg)
If you have build a query specifying a criterion by using comparison operators, the query returns the object that satisfies the criterion to the client.
For example, you can build a query to fetch objects that have the name mapping 1.
name=mapping1
Note: The time format is YYYY-MM-DD HH24:MI:SS.

Specifying a Folder Path

Use a recursive or non-recursive folder path to build a query. You can specify the folder path to access objects inside a folder.
You can use the following types of folder paths:
Folder paths are recursive by default. To specify a non-recursive folder path, use a forward slash at the end of the folder path.
The following table describes sample queries with both recursive and non-recursive folder paths:
Sample Query
Description
name=map1 folder=/
Non-recursive. The query examines only the objects that are nested directly under the project.
name=map1 folder=/f1/f2/
Non-recursive. The query examines only the objects that are located in the path /f1/f2/.
name=map1 folder=f1
Recursive. The query examines all objects that are located in folder f1 and all subfolders within f1.
name=map1 folder=/f1/f2
Recursive. The query examines all objects that are located in the path /f1/f2 and all subfolders of f2.
Note: If you use a forward slash to specify a non-recursive folder path, you can only use the comparison operators =, !=, ~in~, and ~not-in~.