Dynamic URL filter
-
Hi 😉
I need help. I’ve read the documentation, but I can’t figure it out. I have account pages where I would like to display a log from the database. The link looks like this:
https://example.com/user-details?user=chelminskiI would like the search to look like this:
Filter records where the “name” column is exactly the value “chelminski”So I tried doing something like this, although I’m not entirely sure what I’m doing – it doesn’t work.
I can’t change the link, so I don’t want to add additional content to it (e.g. “?wpda_search_column_title” and similar). This is problematic for me.
What can I do to make the table filter information based on URL arguments?
-
Hi @chelminski,
Please try the following in your WHERE Clause:
name like if( httpGet['user'] is null, name, concat( '%', httpGet['user'], '%' ) )For exact values, please try:
name = httpGet['user']Just a note, “name” is often a reserved column name, so you might see instances where you’ll see a 404 page instead. We suggest using more unique column names.
We hope that helps! Let us know if you have other questions. 😊
For example, I used the WordPress user table. I would like the table to show only one record of the user “chelminski”. I included the information in the link. Unfortunately, an error occurs.
What else can I do to make this work? I care a lot 🙁
The topic ‘Dynamic URL filter’ is closed to new replies.
