Support > Repository > Search control > Perform range search
ja | en

When using numeric/date type items as search conditions, range search function is automatically enabled by default.

Figure 1 is an example of a screen in which range search of numeric type items is enabled.

Fig. 1 Search condition screen

Disabling the range search looks like Figure 2.In this case it will be a search to see if it matches the specified value.

Figure 2 Search screen with range search disabled

If you uncheck the "Common> Search range search" check box in the model item detailed definition, pinpoint search will be performed instead of range search.

Figure 3 Disable range search

"Initial month" or "end of month" can be specified as the initial value of the search range.

Figure 4 Specify initial value from the beginning of month to the end of month

Setting method

Specify the start portion as "When initial value> search screen is displayed" and the end portion as "initial value> search screen display (upper limit item of range search)".We will use the special notation now.

now:firstday
now:lastday
Figure 5 Setting initial values

By specifying the year (or year) in the date type item, you can automatically complement the month (and month/day).

Example of execution

The automatic completion function of the month and day can be used when using the date type item of the search condition as the list box. The pattern complemented by "year" or "year" changes.

Fig. 6 Date item of search condition (list box format)

I will explain the case of "year".At the start part, if you specify the year, "January 1st" will be automatically supplemented.

Fig. 7 Start date/month/day setting (Month/day is automatically supplemented)

Also in the end portion, "December 31st" will be automatically supplemented.

Figure 8 Setting the end date (month and day are automatically completed)

In the case of "year", the start is "April 1" and the end is "March 31".The start month of the fiscal year is not fixed April, it can be set freely.

In case of Fig. 9 year

Setting method

In the case of the year

"Search control> date/time", "date auxiliary input" is "use of list box".In the above example, I used "year, month, day", but it can also be "year/month".(Although you can not enter the day part, it will automatically be handled at the beginning of the month and at the end of the month.)

Setting in the case of Figure 10 Year

For the fiscal year

If you specify the start item "month" (supplement), "year" will be treated as "year".In the example, we set it to "4" so we will switch the year to April.

Setting in case of Fig. 11 year

"Start date" "End month" "End date" is automatically set.You can not specify them.

You can also perform range search by specifying only the start item.

For example, if you specify "201411", it will search on "November 1 - 2014 November 30".

Figure 12 Range search with only the start item specified

Setting method

Set the use of list box (year/month/year/month/day) "for the date auxiliary input.(It does not function when "Use calendar" setting.)

In addition, cancels the setting of "set two condition input fields when date/date and time type".(It is enabled by default.)

Figure 13 Range search with only the start item specified

The search range is as follows according to the pattern of the list box.

Date auxiliary input pattern Input value Search range
Year Designated only for the year January to December of the specified year
Years Year/month designation From 1st day of the specified month to the end of the month
date Date specification Specified date

- For "date and time" type, you can search for matching data by specifying up to the time.

On the search screen, you can enter the date using the text field.There are four patterns.

Designate only the year

The year input field is prepared with a maximum input character count of 4.

Designate only year 14

For the setting, select "Use List Box (Year)" in "Search Control> Date/Time> Date Auxiliary Input Function" and specify "text" as the input part.

Setting to designate only Figure 15 year

Designate only the year

An input field of year is also prepared with a maximum input character number 4.

Designate only Figure 16 year

For the setting, select "Use List Box (Year)" in "Search Control> Date/Time> Date Auxiliary Input Function" and specify "text" as the input part.
In addition, specify the start month of the fiscal year in "start item" month "(supplement).

Setting to designate only Figure 17 year

Designate years (same field)

An input field of year/month is prepared with a maximum input character number 6. You can enter "yyyyMM", "yyyy/MM", "yyyy-MM" for input format.It is converted to "yyyy - MM" after input.

Figure 18 Year/month designation (same field)

Select "Use List Box (Year/Month)" in "Search Control> Date/Time> Date Auxiliary Input Function" and specify "input" as the input part.

Figure 19 Setting of Year/Month Specification (Same Field)

Specify the year and month (another field)

The year input field is prepared with a maximum input character count of 4.The input field of the month is prepared with the maximum number of input characters 2. When entering a year, the month automatically completes "1" in the start part and "12" in the end part.

Figure 20 Year/Month Specification (Another Field)

Select "Use List Box (Year/Month)" in "Search Control> Date/Time> Date Auxiliary Input Function" and specify "text_ym" as the input part.

Figure 21 Setting year/month specification (different field)

Input support/input check

  • If you enter "Heisei xx year", "Heisei xx", "flat x", it will automatically be converted to the calendar year."Meiji", "Taisho", "Showa" can be used.
  • If you enter something that is not a numerical value of 4 digits in the year part, an error dialog will be displayed.
  • Range search does not work with time type.(Even if setting is done, only one input field is prepared on the search screen.)
  • This setting can not be applied to repeating items.
  • With this settingImplicit conditionCan not be specified at the same time.
  • When "Set two condition input fields for date/date and time type" is set, range search must also be valid.