Hi,
You can create a custom view and in their you can apply the where condition in the query.
If you know SuiteCRM coding, you can understand what I am saying
Please check these articles
And about no pagination, it is not a recommended approach to skip the pagination from any view as it will come up with many performance issues in future when your data size will increase.