I am trying to: filter on posts with a date field later than TODAY
Link to a page where the issue can be seen: hidden link
I expected to see: the parent training post show up in the dropdownlist because it has unique training child posts with a date later than today.
Instead, I got: parent en child posts are not showing up in the list
Remark: All the "unieke trainingen" created on the 23th of february where imported with WP All Import, back then i encountered also dateformat issues during the import, i solved that with phpcode placed in the plugin "Codefragments"
All the "unieke trainingen" childposts created manually after the 23th of february 2019 won't show up in the filterpage mentioned above with a date in the datefield set to later than today...
An example of a parent training that shows up in the filter but not in the results for unique training;
Select the training below from the dropdownlist under "Opleiding" from the above filterpage
Keuren elektrische arbeidsmiddelen volgens NEN 3140
The unique training below does not show up, see attached screenshot hidden link
The parent trainingen posts should ALL show up in the dropdown EXCEPT if they have no unique child training post attached to it OR the unique child training post has a datefield "datum training" that is equal or < than TODAY, to prevent clients from participating in a course that is already finished OR the training is fully booked, "vol-veld" = "VOL"
To make the result better visible, if you haven't done so yet, filter also on "Locatie" and select "Heerenveen" it will output 1 result with a unique training with a date 17-10-19 as shown in the screenshot from reply #1240506.
The unique child training: hidden link SHOULD pop-up ALSO but it does not.
The issue here why it wasn't showing up was because the vol-veld field was empty. So if the field is empty this means that the field isn't added to the post meta table for this post. In theory the field wouldn't exist in the database.
What I would recommend that you do is to set a default value for this field so that once it is saved the field is created in the database.
As you can see blow the post now shows up. hidden link
The only thing i did was added a value in the field that is not the same as "Vol" that your filter is checking for.
Okay, i understand now, i didn't noticed it because the majority of the records where imported so all the custom fields of the records where put in the database even if they had no data in them, that is why the filter was working with those specific records.
I have placed a default value in the vol-veld so the filter will work now.
Thanks for looking in to it!