Tuesday, December 16, 2025

q- parameter use to pass the parameter condition at next heirarchical level / Filtering at OIC Mapper level

 


OrganizationCode =28192 and StructureName='Primary' and ItemNumber='F6-TD-' and Component.EndDateTime =''




Note :In oracle Notes found that the q parameters filtering will not works at components level

So need to use filtering logic at the OIC level .

I have used a IF condition at OIC mapping level 


((string-length (nsmpr10:EndDateTime ) = 0) or (nsmpr10:EndDateTime > fn:current-dateTime()))


There is one more way we can filter the records at mapper that is using  [ ] .

Below is example where we can filter the supplier depending on status by passing status field in [] square brackets.



No comments:

Post a Comment

query to get Shipment number based on Order number

 SELECT DISTINCT     wnd.delivery_name,     wnd.actual_ship_date,     wdd.sales_order_number FROM     wsh_new_deliveries       wnd,     wsh_...

Popular Posts