How to show documents in listview based on value of a particular field?

For example, I have a doctype called Consignment Booking and it has two fields “Pick-up Location” and “Drop-off Location” and it is a link field with Warehouse doctype. And every user is assigned a particular warehouse. So, the document should show, if either of fields has warehouse which is assigned to him. How to achieve this?