Filter syntax:
For example, filter a dialog or lookup with a list of values:
=CONTRACT, =CREWID, =CREWWORKGROUP
with a as (
<<paste_your_query_here>>
)
select '='
|| listagg(attributename, ', =') within group(order by attributename)
|| '' as where_clause
from a
=AMCREW, =ASSETNUM, =ASSIGNEDOWNERGROUP, =CALCCALENDAR, =CALCORGID, =CALCSHIFT, =CALENDAR, =CGDIVISION, =CGFIRCODE, =CGHIERARCHYPATH, =CGVFAREQ, =CHANGEBY, =CINUM, =CLASSSTRUCTUREID, =COMMODITY, =COMMODITYGROUP, =CONTRACT, =CREWID, =CREWWORKGROUP
Original Message:
Sent: Wed October 27, 2021 12:39 AM
From: User1971
Subject: SQL client: Generate WHERE clause from resultset
This seems to work:
with a as (<<paste_your_query_here>>)select 'wonum in (''' || listagg(wonum, ''', ''') within group(order by wonum) || ''')' as where_clausefrom aWHERE_CLAUSE --------------------------------------------------------------------------------wonum in ('WO11070', 'WO12018', 'WO1226', 'WO2765', 'WO3289', 'WO4403', 'WO4499', 'WO5804', 'WO6107', 'WO6531', 'WO8160', 'WO8272', 'WO9910') 1 row selected.
Source: Generate WHERE clause from resultset ids?
RFE: Button to generate list of IDs from List View resultset
#Maximo
#AssetandFacilitiesManagement