Logical operator - Basic one
At the bottom of table there is the possibility, for each keyword column, to insert a string to search.
It is possible to digit the value to search without any logical operator. In this mode the search is done with the django/python logical operator "contains".
The match is done by searching the string inserted as a substring in each cell of that column. If the inserted value is found, in any position of the cell, the match is true.
Ex: search in column date_obs_datetime and digit the value : 2023-11-06 and press [Return]
The table will be reloaded and will show all records with the date that match the inserted string ( 32 records ) .
The match is performed on string comparison and not on date value.
A more clear example (always in the date_obs_datetime column): insert the value 12:45 and press [Return]
The new table will show all records with date_obs_datetime observed in any year,month, day but all at 12:45 of time.
This applies to all column.
Logical operator : > , >= , < , <= , =
It is possible to use logical operators > , >= ,< , <= , = .
In this case, the match is done by value. The match is done for each column as you are using the SQL statement, for example:
SELECT * FROM NDIT WHERE NDIT=<[inserted value] or
SELECT * FROM NDIT WHERE NDIT >= [inserted value] and so on.
For example, when searching all records that have date 2023-11-06 using the = operator,
Insert :
=2023-11-06 [Return]
the table will be empty because the search is performed with the date value 2023-11-06 00:00:0.0000
With the = operator it is necessary to insert exactly the value to find
In the case of the >= operator by inserting: >= 2023-11-06, the table will return all the records found from dates greater or equal to 2023-11-06 00:00:0.0000
Logical operator : range of values
It is possible to search by value range for each column. In the search by range the operators > or >= and < or <=
give the same result. The operators >[<] are inclusive.
The sintax to use the range search is :
> value1 < value2
For example, for L2 DATE_OBS_DATETIME:
>2022-01-01 < 2023-09-01
Remember that if you specify the date as YYYY-MM-DD without HH:MM:SS , it will be egual at YYYY-MM-DD 00:00:00
For NDIT column :
> 1 < 8
the search result will include the values 1 and 8.
