Hi All,
I have a lobby which accepts multiple Buyer ID’s as parameters to filter elements on the main lobby page, e.g. separated by a comma - ex. BUYER ID: USER1,USER2 - but I am struggling to get the click thru url on specific lobby elements to filter this information on the page level and return all results for those specific buyer id’s input as parameters from the main page.
Here is an example of the WHERE statement, which aggregates a count in the columns:
VIEW: Purchase_Req_Line_All
WHERE:
Objstate IN ('Planned')
and Latest_Order_Date < TRUNC(Sysdate +1)
and (INSTR(',' || UPPER('$Buyer$') || ',', ',' || Buyer_Code || ',') > 0 OR NVL(UPPER('$Buyer$'), CHR(2)) = CHR(2)) -- accepts multiple buyer id’s delimited by a comma
and NVL(Vendor_No,'%') like NVL(UPPER('$Supplier$'),'%')
and Contract like NVL(UPPER('$Site$'),'%')
and INVENTORY_PART_API.GET_SECOND_COMMODITY(CONTRACT,PART_NO) like NVL(UPPER('$Commodity Group$'),'%')
COLUMN:
COUNT(*)
I’ve ticked use datasource condition in the nav and the URL looks like this:
page/PurchaseRequisitionLines/List?$filter=Contract eq toupper($SITE$) and VendorNo eq toupper($SUPPLIER$) and BuyerCode eq toupper($BUYER$) and (Objstate eq IfsApp.PurchaseRequisitionLinesHandling.PurchaseReqLineState'Planned') and LatestOrderDate lt #TOMORROW#
Can anyone advise if this url feature can filter pages by multiple parameters? i.e BUYER1,BUYER2,BUYER3 and return the results on the page level? I’d assume this is possible in IFS, however I’m not 100% and it’s become a bit of a blocker!
Thank you in advance