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