Hello, 

I want to retrieve note_text from Shipment view, but it always will fetch empty string in IFS Report Designer, could you please give me advice how can I repair it? I would add there filtering by shipment id, but this view is not allowed in additional views, IN additional views are only allowed views which are connected with Customer Order tab, so only CUSTOMER_ORDER

This is my SQL query in CustomerOrder entity:

SELECT s.note_text FROM Shipment s
JOIN CUSTOMER_ORDER c 
ON c.COMPANY= s.COMPANY
WHERE c.order_no = :order_no

arguments: order_no

Thanks