filtering options AND OR

Resolved arbremojo
(@arbremojo)

5 years, 3 months ago

Hi,

I would like to do this with the filtering options:
I want the orders which have the status (wc-completed OR wc-processing) AND from yesterday.

However, with the filter options, we can’t add brackets just like I did, which makes that I’m doing this and it’s wrong: wc-completed OR wc-processing AND from yesterday.

How can I achieve that?

Best regards,

Clara.

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Author WP All Import
(@wpallimport)

5 years, 3 months ago

Hi @arbremojo,

However, with the filter options, we can’t add brackets just like I did, which makes that I’m doing this and it’s wrong: wc-completed OR wc-processing AND from yesterday.

You can group the filtering rules together by dragging a rule into another rule: https://d.pr/v/ietsDv.

Let me know if that fixes it.

Thread Starter arbremojo
(@arbremojo)

5 years, 3 months ago

I didn’t know we can do that!
Thanks a lot!
Thread Starter arbremojo
(@arbremojo)

5 years, 3 months ago
@wpallimport Actually, I kinda have a problem…

I set the rules just like you show me, and it tells me there’s nothing to export, although there’s one order which matches the rules.

See these screenshots:

https://drive.google.com/file/d/1o213fD62QKEviKh4m4IjbFYqSP2aP4ai/view?usp=sharing

https://drive.google.com/file/d/1HwTXmDYfGaRsDpnEk4dCTHBj19MlxyCp/view?usp=sharing
- This reply was modified 5 years, 3 months ago by arbremojo.
Plugin Author WP All Import
(@wpallimport)

5 years, 3 months ago
Hey @arbremojo,

Sorry about that, PHP can be a bit weird with relative dates sometimes. Try these filtering rules (note that “>” at the beginning means nested 1 time under the previous rule):
```
Order Data › equal to or newer than › -1 day 00:00:01 AND
> Order Date › equal to or older than › -1 day 23:59:59 AND
> Order Status › equals › wc-completed OR
> > Order Status › equals › wc-processing
```
See: https://d.pr/i/nKjJAR.

If it doesn’t work, please replicate the problem on a sandbox site at http://www.wpallimport.com/debug/ and open a support request at http://www.wpallimport.com/support/ with the sandbox site URL, and a brief description of what’s going wrong.
Thread Starter arbremojo
(@arbremojo)

5 years, 2 months ago

Thanks a lot, your help is always great!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘filtering options AND OR’ is closed to new replies.