-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
Another table filter question
- Thread starter michaelm
- Start date
- Similar Threads Similar Threads
I've played around with it and it seems to work when I enter the name of the column in the textbox, of course it returns all rows in the column. I need to filter for only certain entries within the column that meet the search criteria. Any ideas on what I am doing wrong?
:sign0060:
Works great. Thank you!
Now how do I put some wildcards in it so that it will find anything with only a partial description. For example: If i wanted to find all rows with the word "apple" but that word could be at the beginning, middle or end of the text.
Please advise.
Works great. Thank you!
Now how do I put some wildcards in it so that it will find anything with only a partial description. For example: If i wanted to find all rows with the word "apple" but that word could be at the beginning, middle or end of the text.
Please advise.
Replace the " = " signe (equals) with the work " Like ".
Then write in the textbox something like "app*"
Note - remove the brackets from all the above.
The idea is that you must enclose the value itselft in brackets as I demonstrated. The = sign indicates equation (identity). The Like operator indicates the quite wide range of similarities including wildcards.
The filter string is written like a WHERE clause in a SQL statement (eg. ColumnName = Value AND ColumnName2 = Value2).
To make it easier for users, you may want to create a filter builder. You might have a ComboBox loaded with column names, another loaded with operators (=, >, <, <>, etc) and a TextBox for the value. The user selects a column, and operator, and types a value. They click an Add button and you build a filter string.
Let me know how it works...
Then write in the textbox something like "app*"
Note - remove the brackets from all the above.
The idea is that you must enclose the value itselft in brackets as I demonstrated. The = sign indicates equation (identity). The Like operator indicates the quite wide range of similarities including wildcards.
The filter string is written like a WHERE clause in a SQL statement (eg. ColumnName = Value AND ColumnName2 = Value2).
To make it easier for users, you may want to create a filter builder. You might have a ComboBox loaded with column names, another loaded with operators (=, >, <, <>, etc) and a TextBox for the value. The user selects a column, and operator, and types a value. They click an Add button and you build a filter string.
Let me know how it works...