R1170: Search Format by Data Type

 

These are search formats listed by Data type. They can be specified in the refined Case/Task search criteria. The Date/Datetime-type Data Items also allow you to specify dynamic formats such as "Today", "The 1st day of the month", and "12 hours later".

String-type (single-line/multiple-lines)

Narrowing down by the presence or absence of data input, by the character strings entered.

• Contains [arbitrary character strings]
• Equals To [arbitrary character strings]
• Empty
• Not Empty

Numeric-type

Narrowing down by comparison with the entered number.

• Equals To [arbitrary number]
• Greater Than Or Equal To [arbitrary number]
• Less Than Or Equal To [arbitrary number]
• Empty
• Not Empty

Select-type (Radio Button/Select Box/Search Select Box/Check Box)

Narrowing down by the Choices that have been selected at the data input.

• [arbitrary choice(s)] is (are) Selected.
• [arbitrary choice(s)] is (are) Not Selected.
• Empty
• Not Empty

Date/DateTime-type

Narrowing down in comparison with the specified date/DateTime.

• On
• On Or Before
• On Or After
• Empty
• Not Empty

(Date/Datetime specification)

• {Absolute}
  • Date in the specific format
  • Select on calendar
  • Time (Datetime)
• [Relative]
  • (Selection)
    • [Today]
    • (Number select)[days ago]
    • (Number select)[days later]
    • (Number select)[months ago]
    • (Number select)[months later]
  • (The first/Last day option)
    • the first day in that month
    • the last day in that month
  • Expression

Examples of Relative specification by selection

Example	Date and time to be the Target
[Today]	Today (search executed day [2020-03-14])
[Today] [the first day in that month}	[2020-03-01])
[10] [days later]	[2020-03-24]
[1] [month ago]	[2020-02-14]
[2] [month ago] [the last day in that month]	[2020-01-31]

Examples of Relative specification by Expression

Example	Date and time to be the Target
#now	Current (search executed time [2020-03-14 23:45])
#today	Today (search executed day [2020-03-14 00:00])
#now.addMinutes(-30)	30 minutes before [2020-03-14 23:15]
#now.addHours(12)	12 hours later [2020-03-15 11:45]
#today.addDays(1)	The next day [2020-0-15]
#now.addMonths(-2)	2 months ago [2020-01-14 23:45]
#today.getFirstTimeInMonth()	The first day of the month [2020-03-01 00:00]
#now.getLastTimeInMonth()	The last day of the month [2020-03-31 23:59]
#now.getFirstTimeInDate().addHours(9)	9 o'clock today [2020-03-14 09:00]

User-type (Select Box/Search Select Box)

Narrowing down by the specified User.

• Equal to [me] or [Selected User]
• Empty
• Not Empty

Organization-type

Narrowing down by the specified Organization.

• Equal to [Main Organization] or [Selected Organization]
• Empty
• Not Empty

File-type

Narrowing down by a character string used in the file name.

• Including [arbitrary character strings]
• Empty
• Not Empty

Discussion-type

Narrowing down by the presence or absence of data input and by the strings entered.

• Including [arbitrary character strings]
• Empty
• Not Empty

Table-type

Cannot be used for filtering conditions.

Guide Panel-type

Display only. Cannot be used for filtering conditions.