I will explain how to specify search items that can be used on the search screen.
In the model definition, you can use it as a search condition by putting a check in the "Search" column prepared for each item.
If you specify numeric type and date/time type items as search conditions, range search is automatically enabled.You can search by specifying a range from "○ ○ to ○○".(You can also cancel this range search.)
Detail is"Definition of model item> Numeric value> Use as search conditionPlease read.
The search condition and the specified items are indexed in the database.This optimizes the database automatically so that search performance is always the best.
However, if many items are specified as search criteria, the performance of update processing will degrade.(This is because you change the index each time you update.) If you prepare it as a search condition item but do not use it much for searching, make sure not to perform the index creation process, so consider the balance with the update process.
The index specification corresponding to the search condition can be confirmed with the following file.
You can check the contents of the file with a text editor.The following DDL is included.
CREATE INDEX "jfcidx_モデルID_項目名" ON "モデルID"
The display order of the search screen is the order of the items checked in Figure 1.
You can change this order.Detail is"Order of search conditionsPlease read.