Looper custom query with last 7 days

[mickna]

Hi there,

I have a custom post type “document” with some custom fields.
One field is called “datum” and I sort the posts with this date.

What I have right now:

post_type=document&orderby=meta_value&meta_key=datum&order=DESC&post_status=publish&ignore_sticky_posts=1

This works fine.
I now want to display the posts from the last seven days in relation to the date in the “datum” field. I can’t figute out how to do so.

Any suggestion?

Thank you,
Michael

[tristup]

Hi Michael,

Thanks for reaching out.
I would suggest you go through the following thread with a similar topic.

CPT and Query String sorting Problem

Hey, sorry but i need further help, it was my fault. It was my mistake it did not work the first time. The order is working but the compare not. The Query not working: $meta_query[] = array( ‘key’ => ‘datum’, ‘value’ => date(‘j. F Y’), ‘compare’ => ‘>=’, ‘type’ => ‘DATE’ ); $query = array( ‘post_type’ => ‘short_news’, ‘meta_key’ => ‘datum’, ‘orderby’ => ‘meta_value’, ‘order’ => ‘ASC’, ‘meta_query’ => $meta_query ); The Output: post_type=short_news&meta_key=dat…

Please remember that you can’t calculate the date of the past seven days using the Dynamic Content tag used to compare the date in the query.

Hope it helps.
Thanks

[mickna]

@tristup:

Thank you.
I saw this discussion and similar. Unfortunately, they all discuss to show post after a certain date or before a certain date. That’s why they use “compare”
But I need to show posts the last 7 days. I only know "after=‘5 days’ but this works not with a custom field date.

[tristup]

Hi Michael,

In that case, I would suggest you create a custom Dynamic Content tag as shown in the example and the following thread. And return the date after calculating the seven days.

add_filter( 'cs_dynamic_content_seven', function( $result, $field, $args) {
    // {{dc:stuff:seven}}
    $result = 'dynamic value'; //calculate the seven days 
    return $result;
}, 10, 3 );

Using Dynamic Content in the new Rating element

Hi @dhunink, I wanted to share a quick update regarding this issue. The rating fields are just meant to be numeric inputs so they won’t support shortcodes. We opted to support dynamic content in case you wanted to source those numbers from somewhere else. If you need to do something beyond what the DC fields support, you could setup your own dynamic content hook. This is a bit more involved and takes some custom development but here’s an example: // Put this somewhere DC is supported: {{dc:my…

Hope it helps.
Thanks

[mickna]

@tristup

custom Dynamic Content tag

Holy Moly! Never thought about this.
That’s a fantastic feature / filter.

Thank you so much. Things are getting easier

[tristup]

Hi Michael,

Glad that we are able to help you.

Thanks