| |
| |
There are some specific characteristics about filtering date-type columns and numeric columns, characteristics that will be described in what follows. Before checking them out, get familiar with the date formats allowed by MX Kollection 3 and set through the InterAKT Control Panel.
The skin used this time will be the arktic one, and the buttons and navigation bar are not duplicated. Let's consider the NeXTensio list below. The rows are ordered ascending by name:
In the text field filter corresponding to the Hire date list column, you can type different sub-strings in order to select certain rows from the list. Any input you may enter, it is handled as having your date format. All the existing possibilities for date filtering will be described below, after the following note.
Note: Besides using the slash (/) as a date separator, you can also use a dash (-) or a dot (.).
If you want to retrieve all the employees that were hired in year YYYY (between January, 1 and December, 31), you can type YYYY in the date filter, click the Filter button on the right, and those employees will be listed:
If you want to retrieve all the employees that were hired in month MM of year YYYY (between the first and the last day of that month), you can type either YYYY/MM or MM/YYYY in the date filter (no matter your date format), and those employees will be listed:
If you want to retrieve all the employees that were hired in a certain year (between January, 1 and December, 31), you can also type YY in the date filter, and those employees will be listed.
· If you enter a value lower than 70, the filter will retrieve the rows that have the hire date between January 1, 20YY and December 31, 20YY:
· If you enter a value greater than 70, the filter will retrieve the rows that have the hire date between January 1, 19YY and December 31, 19YY.
If you want to retrieve the employees hired on a certain day, type that date (in your specific screen date format) in the filter text field. All the employees hired on that day, between 00:00:00 and 23:59:59 will be listed.
In the current example, the date format is MM/DD/YYYY. Let's use the dash (-)as a date separator:
Note: for the same result, you could have typed YY (05-14-98) instead of YYYY (05-14-1998), but make sure that your input is aligned to the date format.
When the date is explicitly typed (day, month, year), like in the previous step, you can filter deeper by the time (hour:minute:second). Do this by typing space after the date and then go as detailed as you want by mentioning the hour, minute, second. If you haven't stored the time in the database, then this part of the filter will be ignored and only the date part will be in action.
· If after the space you type nothing else, then the time interval considered is: 00:00:00 to 23:59:59.
· If you type MM/DD/YYYY HH, this input will be actually seen as the interval between MM/DD/YYYY HH:00:00 and MM/DD/YYYY HH:59:59.
· Similarly, if you type MM/DD/YYYY HH:II, the filtered time interval will be: MM/DD/YYYY HH:II:00 - MM/DD/YYYY HH:II:59.
The following operators: <, >, <=, >=, =, <>, != (identical with <>) can be used when filtering by a date-type field. The operators actions are obvious (according to their mathematical meaning).
Here is the list of sub-strings you can type after one of these operators in the filter. For exemplification, we'll use the ">" operator:
· >YYYY or >YY (no matter your date format)
· >YYYY/MM or >MM/YYYY (no matter your date format)
· depending on your date format, only one of these two will work for you: >YY/MM or >MM/YY
· >MM/DD/YYYY (a certain date written in your date format). You can retrieve the wanted rows even when typing YY.
Since the Salary list column is a numeric one, in the text field filter corresponding to it, you can also use these operators: <, >, <=, >=, =, <>, != (identical with <>):
Note: The entered expressions that don't match the rules above will be ignored and no error will be thrown.
Related Topics