Hello IFS Community,
On the routing line I have the following text => JL
When I search the data on the view or table I can see a number.
How could I retrieve the actual string ‘JL’ value and not the number? -IFS9
Thanks,
JL
Solved
Text notes on the routing lines
+14Best answer by Charith Epitawatta
Hi
There is another method in ROUTING_OPERATION_API called Get_Note_Text, in IFSAPP10, but this method does not seem to exist in IFSAPP9. So I think you would have to retrieve the note text directly from SHOP_ORDER_OPERATION_JOIN view or ROUTING_OPERATION_TAB.
If you need to use a method, then you can try writing a utility package with a function similar to Get_Note_Id.
Hope this helps!
JL
This topic has been closed for replies.
+31Hi
There is another method in ROUTING_OPERATION_API called Get_Note_Text, in IFSAPP10, but this method does not seem to exist in IFSAPP9. So I think you would have to retrieve the note text directly from SHOP_ORDER_OPERATION_JOIN view or ROUTING_OPERATION_TAB.
If you need to use a method, then you can try writing a utility package with a function similar to Get_Note_Id.
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.