Cant filter by submit_time

  • Hello,

    I am using shortcode_html to display the form details. One of my tables is to show “Done” entries, but I don’t want it to show anything older than 3 months. In the shortcode, I have ‘filter=”submit_time>-3 months&&_ctc_status=Done”‘ if I use ‘filter=”_ctc_status=Done”‘ it will show the done entries. If I use ‘filter=”submit_time>-3 month”‘ it only returns the header of my table.

    I have validated in the shortcode creator “Valid: ‘-3 months’ = 1574360967 = 11-21-2019 18:29:27”. So in my PHPMyAdmin, I entered the query. “SELECT * FROM contactic_submits WHERE submit_time > 1574360967 AND field_value = ‘Done'” and it returns the entries that are done and have a submit_time > 1574360967.

    However, it won’t do the same from the shortcode. Just gives an empty table. Here is beginning of my HTML shortcode

    [cfdb-html form=”Contact Form” filter=”submit_time>-3 months&&_ctc_status=Done”]

    Again, if I put filter=”_ctc_status=Done” it returns Done entries, however, if I put filter=”submit_time>-3 months&&_ctc_status=Done” it displays nothing but an empty table. Although, I am positive there are entries with a submit_time greater than 3 months ago that are marked done.

    I have even tried [cfdb-html form=”Contact Form” filter=”submit_time>1574360967&&_ctc_status=Done”] and it still will not return the entries

    • This topic was modified 4 years, 9 months ago by paulasd58.
    • This topic was modified 4 years, 9 months ago by paulasd58.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter paulasd58

    (@paulasd58)

    Extra info, I am using the cfdb plugin version by Contactic. My WordPress version is 5.3.2, PHPMyAdmin version is 4.8.3.

    I have tried every variation of the submit_time filter that is provided in the documentation, I cannot get any filters by submit_time. I even took a submit_time directly out of the database and put it in the filter as submit_time= and it wont return that ticket either.

    Thread Starter paulasd58

    (@paulasd58)

    I have now completely removed the contactic plugin and downloaded mdsimpon’s code from github and added it to my wordpress. Everything still works close to the same, however, I am still not able to filter by the submit_time. Still just returns an empty table through HTML shortcode.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Cant filter by submit_time’ is closed to new replies.