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.