Support » Plugin: Exports and Reports » Search – can’t get it to work

  • Resolved ltrost

    (@ltrost0910gmail)


    I’m sure that this is simple, but I can’t figure out how to get search or filter to work! I made a small test query:
    select ID, post_date, post_status from wp_posts
    where post_type = ‘shop_order’

    I have added all these to FIELDS section as TEXT fields: ID, post_date, post_status. I have also put these same names in the REAL FIELD section of each Advanced Field Options, with each one saying Hide from Report=NO, Searchable=YES.

    No matter what I put in the search bar, my list of 25 orders stays the same, I would expect if I searched for wc_cancelled that the screen would change to only show those rows with that status. What am I missing here? Thanks for any help. Below is my test data.

    ID Post Date Post Status
    2299 1/3/2020 17:21 wc-cancelled
    3032 7/1/2020 15:16 wc-cancelled
    1751 11/21/2019 13:01wc-completed
    1805 11/22/2019 15:02wc-completed
    1808 11/22/2019 15:19wc-completed
    1956 12/4/2019 18:30 wc-completed
    1959 12/4/2019 18:45 wc-completed
    2301 1/3/2020 18:21 wc-completed
    2312 1/4/2020 11:22 wc-completed
    2342 1/12/2020 14:51 wc-completed
    2345 1/12/2020 14:57 wc-completed
    2364 1/17/2020 14:47 wc-completed
    2367 1/17/2020 14:50 wc-completed
    2628 2/7/2020 16:08 wc-completed
    2631 2/7/2020 16:14 wc-completed
    2634 2/7/2020 16:22 wc-completed
    2639 2/7/2020 18:44 wc-completed
    2990 3/2/2020 17:53 wc-completed
    3019 6/6/2020 12:45 wc-completed
    3037 7/5/2020 12:54 wc-completed
    3041 7/6/2020 10:40 wc-completed
    3051 7/9/2020 12:57 wc-completed
    3052 7/9/2020 13:12 wc-completed
    3061 7/14/2020 11:22 wc-completed
    3070 7/15/2020 17:42 wc-processing

Viewing 4 replies - 1 through 4 (of 4 total)
  • Does selct ‘ID’ work, then add the second filter, then the third,
    Sorry but I have be out of this for a year or so, just getting back into,

    ltrost

    (@ltrost0910gmail)

    Thanks for trying semky, but I think I finally figured it out. I needed to select “Filter using HAVING” to be YES rather than default of NO.

    ltrost

    (@ltrost0910gmail)

    Marking as resolved

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    If you specify a WHERE, I think sometimes giving the parser the placeholder will help — WHERE %%WHERE%% something = 1.

    I’ll have a look at this and see if I can think of any other ways to make this easier, I didn’t expect HAVING to be the solution here and that’s a problem I’d love to make sure others don’t have to run into.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.