migxdb db-filter date

Hi Bruno,

I am trying to edit a migxdb form where I need to add a date filter.
I edited the schema on the Migx section, went to the DB_Filters tab and added the filter. This is what I have:

Of course I am missing something because the filter box to pick = or >= or <= is not even considered on the filtering:


I checked all available documentation for Migx and I am unable to find something that could solve this simple problem.

Can you please help me with this simple question?
btw, where can I get Migx full documentation set?

Thanks in advance

Take a look at this tutorial as it covers date filtering in it.

https://docs.modx.com/extras/revo/migxdb/migxdb.tutorials/migxdb.manage-events-resources-in-a-cmp-with-help-of-migxdb

Thanks LK but I already checked those examples and didn't help on my case. This is why I am asking for help (did I miss something on that page?)

Hi All,

Any clue please?
@Bruno17, can you give me a hand please?

Thanks

That tutorial should work fine.

Can you post the output JSON of your MIGXDB setup?

Hi LK,

I gave another reading the post you shared and where I also went on my searches before asking for help and then I understood the logic. Working under pressure has some negative effects

So the solution for the "getlist-where" field was:
{"curso_inicio:[[+inicio_filter_dir]]":"[[+inicio_filter]]"}

I ended-up with the filter dir by inspecting the ajax requests and responses on Chrome debug tools and found that this on the responses.
This worked properly for the date filter along with the selecion of = or <= or >= as per the screenshot on my first post.

Thanks for your help