I am just starting to explore Aurena in IFS Cloud 21R1, but can anyone who has been using Aurnea for a while explain how to create a similar query within Aurena? It is the type of query that we use all the time in IEE (V9) to provide search results without the need for a quick report when the additional columns from another view are not required on the search display.
This particular search finds the customer payments posted in the last 7 days for a given company.
INV_STATE = 'PaidPosted' AND COMPANY = '&COMPANY' AND INVOICE_ID in
(SELECT coih.INVOICE_ID
from INST1APP.CUST_ORDER_INVOICE_HIST coih
INNER JOIN INST1APP.CUSTOMER_ORDER_INV_HEAD_UIV coi
ON coi.INVOICE_ID = coih.INVOICE_ID
AND coi.COMPANY = coih.COMPANY
INNER JOIN INST1APP.CUSTOMER_ORDER co
ON coi.creators_reference = co.order_no
where coih.DATE_ENTERED > TRUNC(SYSDATE)-7
and coih.MESSAGE_TEXT = 'PaidPosted'
and co.country_code IN ('CN'))
My inclination is that this isn’t yet possible in Aurena, but it is a critical element to our solution, so would like to confirm.
