Sort by submit_time not displaying
-
Hi there,
I am using CF7, CFDB, and the shortcodes actions and filters plugin and I’ve gotten my shortcode working. But now trying to filter the results by submit time isn’t working out. I tried the shortcode builder to make sure my submit time was valid, and it was. Then I tested from the shortcode builder page the following shortcode link
[cfdb-value form="Guest List" show="your-name" filter="submit_time>last week"]
which from the shortcode builder page did display results, however testing from an unpublished draft of a wordpress post did not display anything, so I’m wondering if there’s some sort of disconnect with the submit time and displaying on the site? I didn’t set any security options and my short code that I built worked out other than trying to add a filter for sort time.This is my shortcode, titled shortcode2
require_once(ABSPATH . 'wp-content/plugins/contact-form-7-to-database-extension/CFDBFormIterator.php'); $exp = new CFDBFormIterator(); $exp->export($atts['form'], $atts); while ($row = $exp->nextRow()) { if ($row['menu-838'] != 0) { echo $row['your-name']; echo " +{$row['menu-838']} <br />"; } else { echo $row['your-name'] . '<br />'; } }
The following shortcodes did display results
[myshortcode2 form="Guest List" filter="checkbox-376~~/.*Friday/"] [myshortcode2 form="Guest List" filter="checkbox-376~~/.*Saturday/"]
The following shortcodes did not display results
[cfdb-value form="Guest List" show="your-name" filter="submit_time>last week"] [myshortcode2 form="Guest List" filter="Submitted>-last week"] [myshortcode2 form="Guest List" filter="submit_time>-7 days&&checkbox-376~~/.*Saturday/"] [myshortcode2 form="Guest List" filter="submit_time>7 days&checkbox-376~~/.*Saturday/"]
As always your help and insight are greatly appreciated.
Thanks!
- The topic ‘Sort by submit_time not displaying’ is closed to new replies.