Search should search the whole field and not just the begining.
So if I have says "MX14ABC" I want to be able to put "ABC" in the search box and it finds it.
At the moment we have to split stuff up into seperate fields so it can be searched.
the work around is to use an index function ie index('hello', 'll') would return 3, so you can search like:
(select TABLENAME)[index('FIELD NAME', 'SEARCH TERM')>0]
This behavior for search for a particular table is odd, given that the global find box searches the whole text of every field.
I mean just using the find option on the left, not using any code.
I agree... that said.. from trial and error, I have discovered that the Find is "word boundary" (aka spaces) based.. so it will not find partial matches. Chris's work around works.... you can also use a "contains('Field Name', 'Search Term') .. as it returns true / false.
Unless I'm misunderstanding you, I'm not seeing the limitations to the global Find that you all are seeing. Find does not seem to be word boundary based?
Hmm.. that is interesting.. If I attempt to use the left nav Find..
Then Find uc..
both the table and the column are in the global search..
But if I use CTL+F .. or the "Find" on the top nav of the iPad app..
I am on version 2.5.6 Mac App
Ninox provides two search functions - global and local search.
The global search can be accessed via the magnifying glass in the left side bar. Here you'll search the whole datadase. Global search will only find something if its the beginning of the field content.
To search a table only press "cmd + f" or use right click to select "find".
In the above.. I used the global Find for "uc" .. and expected to return Product rows 1, 2, and 3... as the "Product Name" has "uc" in it.. but it returns nothing.
In @firstname.lastname@example.org example above.. He used global Find for string "usc" and the partial string was found within table columns. So, my question is.. why does his global find work.. and mine does not?
I should add that I’m using Ninox on an ipad pro with iCloud sync. I confirmed that the same global find works on the iPhone version.