Hi,
thanks for your post.
Just to be sure, you are refering to filtering with the Row Filter Extension here, right?
Then, filtering for tables that are empty or null is not really possible, as that’s not a valid search term.
Instead, I’d suggest to fill these empty cells with something like “TBA” or “-” and then filter for that.
Would that be a possibility?
Regards,
Tobias
I didn’t explain it my request very well. I have one table that has all the data that I use to populate two different summaries on wordpress.
the table consists of all the schools teams game schedule details (i.e. date, time, opponent etc) and the results of the games (i.e. wins/loss score) i use row filter extension to put the data for each team on their page and i use hide columns filtering to show schedule of their games and then different hide columns to show games results.
so for a team like volleyball that has 24 games each season mid season you would see on the results page all the games they have either won or lost and on the upcoming (schedule) page you only the remaining games that they have yet played. currently both pages are showing all 24 games with data missing.
so if i can filter further the tables to show on “upcoming” only the games that have null in the results column that would give me only the data i want shown.
tks for your help
Hi,
thanks for that explanation!
Now, I might still be misunderstanding this, but using eg. “-” instead of the score should achieve this. With that, a Shortcode like
[table id=123 filter="WIN||LOSS" /]
would give you the correct data for the “Results” page, whereas
[table id=123 filter="-" /]
would give you all games that have not yet been played, i.e. “upcoming”.
Or am I still not getting it? Sorry 🙁 Can you then maybe post a link to the full table that you want to filter on some more?
Regards,
Tobias
Here is golf full table:
http://piedmonthighboosters.org/golf-w-v-all/ with this shortcode
[table id=72 filter=”GOLF-W-V” /]
Golf table with wins only
http://piedmonthighboosters.org/golf-w-v-win/ with this shortcode:
[table id=72 filter=”GOLF-W-V&&WIN” /]
Golf table with wins & losses BUT RESULTED IN ZERO RESULTS INSTEAD OF WINS AND LOSSES
http://piedmonthighboosters.org/golf-w-v-win-loss/ with this shortcode:
[table id=72 filter=”GOLF-W-V&&WIN||LOSS” /]
Hi,
thanks for those examples! Now I know what’s happening.
The problem is that the Row Filter Extension does not yet support different logical connectors as in
[table id=72 filter="GOLF-W-V&&WIN||LOSS" /]
Internally, this is basically translated to “Filter for ‘GOLF-W-V’ AND ‘WIN||LOSS'”. It is not possible to use “AND” and “OR” in the same filter query 🙁 Sorry.
As a workaround, you could therefore experiment with another (hidden) column, that e.g. has values like “played” and “not-played”. Using
[table id=72 filter="GOLF-W-V&&played" /]
would then give you the output that you would like for
[table id=72 filter="GOLF-W-V&&WIN||LOSS" /]
while
[table id=72 filter="GOLF-W-V&¬-played" /]
would give you the games that have not yet been played.
Regards,
Tobias
