AND/OR feature for Criteria in Database Rows (Visual Interface)

[Tim Harland]

It would be helpful (especially for staff less familiar with Worksheets) to be able to control criteria for Database Rows in Worksheets with And/Or functions through the visual interface. At the moment it defaults to 'or' (when one would expect it to be 'and') and the only way to adjust it is to edit the criteria formula to change the vertical bar to and ampersand. As soon as you want to add a new criteria you need to reedit the formula.

In the same interface it would be good to be able to change the order of criteria or at least delete criteria that are not at the bottom of the list.

[Hugues]

57 minutes ago, Tim Harland said:

It would be helpful (especially for staff less familiar with Worksheets) to be able to control criteria for Database Rows in Worksheets with And/Or functions through the visual interface. At the moment it defaults to 'or' (when one would expect it to be 'and') and the only way to adjust it is to edit the criteria formula to change the vertical bar to and ampersand. As soon as you want to add a new criteria you need to reedit the formula.

In the same interface it would be good to be able to change the order of criteria or at least delete criteria that are not at the bottom of the list.

Hello Tim,
Are you using VW2022? The criteria interface was updated for VW2022 and addressed these issues. 

[Tom W.]

In my experience it defaults to & and you have to manually change it to | after the fact if you want 'OR'...

 

I read somewhere that the logic behind the criteria dialog is that items of the same type will be automatically OR'd + items of different types will be AND'd but I am not getting that: it is always &/AND with no option of selecting |/OR in the dialog