Skip to main content

Hello, I created a lobby which filter only this order_no, which is currently running, running order_no has OperStatusCodeDb=86. How can I setup in OperationStatistic filter only which has OperStatusCodeDb=86? 

Hi ​@Ed22 

 

Could you kindly provide a little more information on the creation and the issue, that will help us to understand the issue.

 

Regards,

Vishal J


I created a lobby list which display only those order_no which is running - they have status = 86, but when i click on this list, in IFS displays all order_no - running, cancelled, etc…..What should I add to the navigation link? I add there whole link where I applyed this filter, but it retrieves all order_no


Hi ​@Ed22,

Thank you for the information,

If it is a list element and if you want to navigate to a particular order (Whichever you are clicking), you need to add order no filter in it, cause as per you we already filtered the status, to navigate to the exact order number we need to add the filter for order no, you can see below example as well.

page/PurchaseOrder/Form?$filter=OrderNo eq $ ORDER_NO]

Additionally: I have attached a navigation document that you can refer.

If you share me the screenshot of the element/DataSource and the link which you added, also the page you want to navigate, I can help you more in this.

 

Best Regards,

Vishal J


this is my navigation URL: page/OperationStatistics/List;path=0.610944250.101479601.2097670541.750945240;app-state=4b35adc8-80ca-40c1-a54d-54dff74138f6 and I want set up parameter OPER_STATUS_CODE_DB = '85'


Maybe something like this? page/OperationStatistics/List?contexts=Company:$Company$&$filter=OPER_STATUS_CODE_DB eq $OPER_STATUS_CODE_DB$? I dont know


this is my navigation link: “page/OperationStatistics/List?$filter= OperStatusCodeDb $ OPER_STATUS_CODE_DB]” this is error: OperationStatistics/List (Server error)
Malformed Request.
Error details: i{"code":"EXPRESSION_PROPERTY_NOT_IN_TYPE","message":"The property 'OperStatusCodeDb', used in a query expression, is not defined in type 'IfsApp.OperationStatisticsHandling.OperationStatistic'."}]


Hi ​@Ed22,

Instead OPER_STATUS_CODE_DB, we can use OPER_STATUS_CODE in the data source.

Below navigation link example will work for that.

page/OperationStatistics/List?$filter=OperStatusCode eq IfsApp.OperationStatisticsHandling.OperStatusCode'Released'

 

Best Regards,

Vishal J


and what abut when I want to filter based on two and more conditions, for example in another module? In module ShopFloorReports? page/ShopFloorReports/List?$filter= OrderNo eq $$ORDER_NO] AND WORK_CENTER_NO IN ('TEST', 'T-OEM'), the second part of navigation is not working


Hi ​@Ed22 

 

You can try the below one in that scenario!

page/ShopFloorReports/List;usedefaultfilter=true;app-state=4fad6bb9-5d9a-4d11-bc54-9057bba7cee0;$filter=(OrderNo eq '62' and (startswith(WorkCenterNo,'WC1') or startswith(WorkCenterNo,'K-1')))

 

Best Regards,

Vishal J 

 

 


Reply