Skip to main content
Solved

Lobby filtration

  • August 20, 2025
  • 9 replies
  • 102 views

Forum|alt.badge.img+10
  • Sidekick (Customer)

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? 

Best answer by vishal J

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

9 replies

vishal J
Sidekick (Partner)
Forum|alt.badge.img+7
  • Sidekick (Partner)
  • August 20, 2025

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


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • August 20, 2025

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


vishal J
Sidekick (Partner)
Forum|alt.badge.img+7
  • Sidekick (Partner)
  • August 20, 2025

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


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • August 20, 2025

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'


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • August 20, 2025

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


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • August 20, 2025

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: [{"code":"EXPRESSION_PROPERTY_NOT_IN_TYPE","message":"The property 'OperStatusCodeDb', used in a query expression, is not defined in type 'IfsApp.OperationStatisticsHandling.OperationStatistic'."}]


vishal J
Sidekick (Partner)
Forum|alt.badge.img+7
  • Sidekick (Partner)
  • Answer
  • August 20, 2025

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


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • August 22, 2025

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


vishal J
Sidekick (Partner)
Forum|alt.badge.img+7
  • Sidekick (Partner)
  • August 22, 2025

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