I would suggest instead of adding the condition to the database view, which is difficult to do, create a report on the database view and add condition there using the report condition builder to see the results. That way you can add the report to a dashboard and share it to your users.
Please mark this response as correct or helpful if it assisted you with your question.
