I am trying to create a lobby - Shipment Lines, which contains Source Ref 1and partno. When click on row, I want to pass Source Ref 1and partno as filter to Inventory Transactions History. Is this possible?
this my link but does not work - page/InventoryTransactionsHistory/List?$filter=OrderRef1 eq $[SOURCE_REF1]
If hard coded, it works, not sure why
page/InventoryTransactionsHistory/List?$filter=SourceRef1 eq '*1001'
Checked in 21R2: Inventory Transactions History
It was noted that it is possible to filter using ‘OrderRef1, but ‘SOURCE_REF1’ is not in the filter parameter list and not in the populated list as well; hence, it is not possible to filter using ‘SOURCE_REF1’ as the data column is not in the list.
Do you have data (for SOURCE_REF1’ ) in the populated list?
Hi
I agree with jgrace. The column source_ref1 isn’t available in Inventory Transactions History. Therefore it can’t work. But you can create an IAL as workaround.
Shipment Lines contains Source Ref 1. In InventoryTransactionsHistory, it is called OrderRef1. I want to pass Source Ref 1 to InventoryTransactionsHistory like page/InventoryTransactionsHistory/List?$filter=OrderRef1 eq $qSOURCE_REF1], not sure why it would not work. Or what should the navigation link be?
In the window “Inventory Transactions History”, the field having the label “Order Ref 1” actually has the attribute name “SourceRef1”.
You can easily see this by doing a manual query on the field and check the URL in the web browser . There you will find the real name you shall use in the filter:
So in this case you shall use SourceRef1, not OrderRef1.
Somehow found it helpful!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.