– I’d like to be able change the separator in the export CSV file from , to ;
sure this is doable
– I’d like to be able to select the output columns in the export CSV file.
Will do that
– It would be really nice if there was een option to write a more advanced query,something like changes last month (e.g. using date functions) – so I won’t have to change the dates
this plugin is built for filtering with advanced queries, please tell me what would you like to achieve, I will help with that.
It’s not really very advanced but I’d like to have some date functions I could use in filtering.
With each user I have a couple of custom fields that contain dates. With these dates I want to be able to select things like: “Who has been added the last month, the last 30 days, last year.
but also things like age (given a birthday)”. So a current date function, day of the week, month, year,
the usual things you can do in an SQL statement. Maybe it’s already possible, and I just didn’t recognize it.
so are you able to solve the last problem with the help of this plugin?
If yes, then I will ship the first 2 features..
If not, you can give me your expected output, screenshots!, sql queries, results of sql queries. It will help me to understand your need in a better way!!
If you mean the date stuff, I don’t know how to do this with your plugin yet.
I have a custom fields per user titled Last_update I want to create a query that’s called Updated_lastmonth, which pick which uses the current date, gets the month number and filters all users who were updated during that month. The same for the last 30 days, for example
Something like
SELECT *
FROM Members as l
WHERE (MONTH(CURRENT_DATE())=1 AND YEAR(l.lastupdate) = YEAR(CURRENT_DATE())-1 AND MONTH(l.lastupdate) =12) OR (YEAR(l.lastupdate) = YEAR(CURRENT_DATE()) AND MONTH(l.lastupdate) = MONTH(CURRENT_DATE())-1)
ORDER BY l.lastupdate ASC
Let me check, I will create a setup like you have
Will create some users with a custom field and test if it works I will let you know here. Give me a few hours….
thanks.
O really? That’s great. Really didn’t mean to rush you.
Thanks a lot for the support
Hold hold hold! are you doing this in a custom table? Because this plugin perform queries on wp_users and wp_usermeta.
I am asking this because in the above query you mentioned Members table.
sorry for the confusion – no just wp-user and wp-usermeta. The query was just an example, to give an idea. I’m only using custom fields in wp-usermeta
can you give me the metafield format, what kind of value you save in the field,
like dd:yy:mm h:is ?
Php’s strtotime ?
28/06/2026 7:02 am.
d/m/Y g:i a
but I can change this if required. It’s just the format I started with.
Maybe YYYY MM DD is better
meta_value: Y-m-d format eg: 2026-05-01
In the pop-up:
meta_key: last_updated
operator: BETWEEN
type: DATE
value: 2026-05-01,2026-05-31
This is working, like the entire month of May. Is this all you wanted?
https://tinyurl.com/23d7daaj
That’s great Hardik, but I was looking for creating a filter that would use the current date and then calculate the values. So I don’t have to fill in the values any more
you mean in the meta_value you will pass something like,
last 2 days, last week, last 2 weeks, last year, last two months. so on…
you will get result from today and [your desired last time].
if this is your target then I will take more days. This kind of tricky need to add matching patterns, testing and alll..
Thanks!
