Maxim Adrian asked 4 years ago
Hi, can you help me with a solution, I will be grateful .. (I am a beginner, used ninox cloud before)
1. It is possible to search from ”search all columns” to get results from multiple columns matching the words I type?
Typing: John1 Street2
Result: ColumnA: (row1) John1 / ColumnB:(row1) Street2
From data:
ColumnA: (row1) John1 / ColumnB:(row1) Street2
ColumnA: (row2) John1 / ColumnB:(row2) Street3
ColumnA: (row3) John1 / ColumnB:(row3) Street4
And also, is there any posibility to create a search page (global search) and getting result from multiple tables :
Typing: John1 Street2
Result:
TABLE 1
ColumnA: (row1) John1 / ColumnB:(row1) Street2
TABLE 2
ColumnA: (row1) John1 / ColumnB:(row1) Street2
From data:
TABLE 1:
ColumnA: (row1) John1 / ColumnB:(row1) Street2
ColumnA: (row2) John1 / ColumnB:(row2) Street3
ColumnA: (row3) John1 / ColumnB:(row3) Street4
TABLE 2:
ColumnA: (row1) John1 / ColumnB:(row1) Street2
ColumnA: (row2) John1 / ColumnB:(row2) Street3
ColumnA: (row3) John1 / ColumnB:(row3) Street4
and the last question, how can I filter only a specified month from a table, from search filter :
Typing: 04.2020 ( only month/year , without day)
my date: 13.04.2020
Thank you,
Abu Ghufran Staff answered 4 years ago
Hello,
1) Yes, It works exactly as you mentioned. “John1 Street2” will search both words independently in all columns.
2) Multiple table search is not supported now. You can use SQL query UNION to combine records of both table and feed to data grid.
3) If you search dates in global search, you must use database stored format (yyyy-mm-dd). e.g. to search 04.2020, you need to type 2020-04
