Skip to main content
Question

Lobby URL navigation with multiple BUYER_CODE parameters?


awelsh
Do Gooder (Customer)
Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 4 replies

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

0 replies

Be the first to reply!

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