is there a bug with Or (||)

[leyburn19]

We are migrating from one tenant to a new tenant.  To say it is fun and filled with joy are not the words I pick.  That said I have come across an illogical issue with a gallery Filter in the new tenant

In the new tenant the filter below will only return records based on the Status Quote Approved.  In the old tenant it returns all the required records.  It is like the "Or" function no longer works.  I have tried many tests and all end in the same result only records on the one status will appear.  If I remove the Brackets that contain the OR statement I suddenly get all records for the entire list which is logical

Filter('Survey and Quote Retails Stores Quote Header',

Title=vStorename And

(Status="Open" || Status="Quote approved" || Status="Rejected" || Status="Pending Customer Approval") )

I have replaced the data source in the filter ect but nothing changes.  I have changed the text filters to try StartsWith but no change

Are there any thoughts or ideas as to why?

[StalinPonnusamy]

Hi @leyburn19

Just think only of 2 places.

• Can you insert the label and verify the Verify vStorename (since we use AND)
• Verify the data source whether you have data on those statuses

[leyburn19 · Accepted solution]

Thanks for the feedback.  The issue sat with me.  Another lesson  in life. I should never try to rationalize things while I have 29 stores access the data at the same time.  the syncing of data for this was affected by this.