lkonl1ne

It’s over two weeks now, anyone?

Cheers, you are awesome and I am blind.

Thank you @sc0ttkclark and @pdclark for your prompt responses.

I will go the php way then. It just seemed so obvious that you could do that with magic tags given that you can pretty much do really advanced templating using a combination of tags and shortcode nesting, which I have done in the past.

Anyway, I am off becoming a “friend” of pods, since I having been using it for quite some time and you guys deserve it. All the best.

Loukas.

Thanks, @keraweb for your immediate reply.

I will look into PHP templates once I sort out a couple of highest priority issues first.

My complete shortcode for anyone who comes across this topic searching for how to implement date-based filtering in a where clause together with another condition is:

[pods name="my_name" where="my_field_1.ID='{@ID}' AND CAST(my_field_2.meta_value as DATE) BETWEEN CURDATE() and '2200/01/01'" limit="something" orderby="something" template="my_template"]

I can break down each part individually if you would like but I guess that anyone who searches for advanced filtering already knows how to interpret this shortcode.

Cheers,
Loukas.