Hello,
I’ve just found this strange logic of searching in my table. It happens on my own server and on cloud seatable. Is this a bug or is there are any settings to change the logic?
If I put in search form “Serv 70” I want to find the cell with whole word match.
Here is how it works:
My reaction is: The seach is pretty cool. Your video demonstrates that.
SeaTable’s search simply uses an OR condition when multiple search terms are entered. Why is the logic “strange”?
If you want to search exactly, use “Search all tables”:
Finally, when posting in the forum, it is helpful to specify the server and the edition you use. You cannot assume that I and others know that your instance is running the Developer Edition. There are significant functional differences between the two.
Is ther is any way to customize search conditions?
The logic is strange for me because I’m comparing with Google Sheets experience. For example I have Name entry serv 70. If I search for it in Google Sheets I’ll find only one entry and It’s fast. In Seatable I’ll find all entries that contains “serv” and “70”. So i’ll need manually search after that. Imagine how that would be time consuming If there are around 1000 entries.
Also I don’t understand why it shows Serv 3 and Serv 6, and ignores the else. First image.
In search form I see “1 of 8” entries found.
If I search all tables there I see "There are 3 results for “Serv 70"”
I use my own server with docker compose.
SEATABLE_IMAGE=‘seatable/seatable-developer:latest’
5.0.0 in /seatable/conf/current_vesion.txt
If there is any additional information that I can provide, please tell me.
Also, I mentioned in previous post, that I’ve got the same logic when signed up on your https://cloud.seatable.io/
Which server and edition is running there I don’t know. If you could help me find out where I can get that info, I’ll be pleased.
Thank You for answer
Hi Jonas, and welcome on the forum!
I disagree with @rdb, the search doesn’t use an OR condition, but rather an AND, that is why rows Serv 3 and Serv 6 are also found: the ip address contains 70, so both “Serv” AND “70” are found. Unfortunately I didn’t know or find a way to make SeaTable search for “Serv 70” instead of “Serv” and “70”.
It says 1 of 8 entries because apparently every non-empty cells of a row meeting the search conditions is considered as an entry (if you use the up and down arrow you’ll see that the focus changes from one cell to another), whereas the results when you use search all tables are the rows meeting the conditions (so 3: Serv 3, Serv 6 and Serv 70).
You can add /server-info after the address of any server to find the version, for example https://cloud.seatable.io/server-info/
Bests,
Benjamin
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.
