Skip to main content
Question

Advanced Subquery Search in IFS Cloud

  • October 31, 2021
  • 2 replies
  • 472 views

Forum|alt.badge.img+28

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.

This topic has been closed for comments

JerryB
Hero (Employee)
Forum|alt.badge.img+13
  • Hero (Employee)
  • November 17, 2021

This shouldn’t be in the Asset Management Section of Community. 


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • December 29, 2021

Hello, 

 

we are facing the same issue. How can these subquery searches be replaced in IFS CLOUD? We definitely need a solution for that!

 

Thanks,

Nicolas


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings