Search all columns – advanced options

QuestionsSearch all columns – advanced options
Maxim Adrian asked 2 weeks 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,

1 Answers
Abu Ghufran Staff answered 2 days 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

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Your Answer

9 + 14 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?