Multiple filtering conditions on same column using corvid code

Ask the community
,
1

I want to apply two filters to same column in my collection.

 const filterStatusOne = wixData.filter().eq("status", "Good");
 const filterScriptTwo = wixData.filter().eq("status", "Bad");

    wixData.aggregate("itemList")
        .filter(filterStatusOne)
        .filter(filterScriptTwo)

The above code throws the following error

WDE0012: Invalid .filter usage. Filter is already set.
WD_VALIDATION_ERROR

I tried the following as well but no avail

const filterStatus = wixData.filter().eq("status", "Good").eq("status", "Bad");
    wixData.aggregate("itemList")        
        .filter(filterStatusOne)

Can somebody help me on this?

Thanks.

2

Anyone have a suggestion here? I’m have the same issue.