We have a Counter lobby element that when we drill-down it is loading all CustomerOrders- not just the ones for the SQL behind this element.
The SQL uses an IAL - RW_ORDERS_SHIPPED_TODAY2, which is built on another IAL (RW_ORDERS_SHIPPED_TODAY).
I’ve done other lobbies where the drill-down works, so I don’t see what’s different with this one, unless somehow IALs aren’t recognized?
select count(*)
from ifsinfo.RW_ORDERS_SHIPPED_TODAY2
where contract = 'W'You can use data source view as “&AO.CUSTOMER_ORDER” and in data source condition as below,
order_no in (select order_no from ifsinfo.RW_ORDERS_SHIPPED_TODAY2 where contract = 'W')
Then drill down filter should work.
thx. I tried that and get repeating result rows:
Yes. In data source don’t create the count column. Select any columns (ex: order no) in the column section. So it lists all the order no’s in data source preview.
In lobby element you can choose the element type counter and choose that column/columns.
thx; that worked!
That’s nice to know as if offers more flexibility/power!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.