Solved

Lobby Element Drill-Down Loading all CustOrd

  • 22 September 2020
  • 4 replies
  • 244 views
D
Rank
Userlevel 4
Badge +10
  • DevBob
  • Sidekick (Customer)
  • 119 replies

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'
icon

Best answer by djay 23 September 2020, 12:03

View original

4 replies

D
Rank
Userlevel 3
Badge +7

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.

Thilina Jayasinghe
D
Rank
Userlevel 4
Badge +10

thx. I tried that and get repeating result rows:

 

 

D
Rank
Userlevel 3
Badge +7

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.

 

 

Thilina Jayasinghe
D
Rank
Userlevel 4
Badge +10

thx; that worked!

That’s nice to know as if offers more flexibility/power!

Reply


Terms & ConditionsCookie settings