Solved

Lobby: Drill-Down Summary Element to Detail

  • 24 June 2020
  • 8 replies
  • 392 views
D
Rank
Userlevel 4
Badge +10
  • DevBob
  • Sidekick (Customer)
  • 119 replies

We have a Lobby Element that summarizes orders by status for 4 date periods.

Now we want drill-down capabilities so when they click on any of the Status rows they see the detail behind it- Order#, Status, Date, Quantity, Price.

 

I couldn’t find any documentation on this- does some exist?

I didn’t see an Element that has this; Link looks like it just drills down into a screen, not a report.

Would it/could it drill down into the Customer Order screen with parms to restrict results?

 

icon

Best answer by DevBob 25 June 2020, 21:25

View original

8 replies

A
Rank
Userlevel 4
Badge +7

Yes, you will need to use the navigation part of the element. Looking at your data, think you might need a bit of clever implementation in the where logic to correctly navigate to the applicable customer orders.

 

~hope is a good thing, maybe the best of things, and no good thing ever dies...
D
Rank
Userlevel 4
Badge +10

thx, I will try that...

D
Rank
Userlevel 4
Badge +10

Would my url be something like:

ifsapf:frmCustomerOrder_Cust?ORDER_NO=1859186

 

D
Rank
Userlevel 4
Badge +10

Trying to figure out the AddressBar url to load customer order lines for customer_no = 122273:

ifsapf:tbwOverviewCustOrdLine?CUSTOMER_NO=122273&COMPANY=1

 

then, if this is our Lobby Element, all we have to pass as a parm for the drill-down is OrderStatus:

 

 

D
Rank
Userlevel 4
Badge +10

Filled out info on the Nav section, lobbys is now “Clickable” for drill-down, however when I click it does open the CustomerOrderLines screen (:grin: ) but I get this error:

So the question is:

how to map the parms?

how to code the AddressBar url?

 

 

 

 

D
Rank
Userlevel 4
Badge +10

ok, I got the CustomerOrder State parm working and it loads blocked orders when I click on Blocked in the lobby. :smiley:

last thing to do is add other parms- date range…

 

 

 

D
Rank
Userlevel 4
Badge +10

fyi, I was able to get it  working.

I basically didn’t use an IAL and coded everything in the DataSource Designer.

Then when I click on a Status row, it opens CusomerOrders for just those detail orders from the underlying SQL.

thx to everyone for your replies and encouragement!

D
Rank
Userlevel 4
Badge +10

thx. I found that to be true and have designed new lobbies that way.

Then I did a pie chart which turned out looking really sharp.

Reply


Terms & ConditionsCookie settings