Hi, I may not have understood your question properly, but in Navigation you can filter the target view by specifying relevant target column (NB: make sure you name them exactly as they are in the target view) and/or through the URL that can also contain filters.

You can have something a bit more sophisticated URL thanks to “external search” function:

ifsapf:frmAvailabilityPlanning?EXTERNAL_SEARCH=CONTRACT%3D{&CONTRACT}%26PART_NO%3D{&PART_NO}%26PROJECT_ID%3D%23

If needed, you can easily find other discussions describing this function.

Thanks for this. Is there any option to SORT the data ?

It can be done through this option:

This thread is talking about it:

Thanks a ton. I was missing a simple configuration. 

You can also sort with specific/multiple columns by providing the &$orderby system query option in the URI/URL, after the #COMPANY_ID# parameter. It allows clients to request resources in either ascending order using asc or descending order using desc. The request below orders Trips on property EndsAt in descending order.

GET serviceRoot/Trips?$orderby=EndsAt desc

Basic Tutorial · OData - the Best Way to REST