Skip to main content
Solved

Lobby: Drill-Down Summary Element to Detail


Forum|alt.badge.img+10
  • 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?

 

Best answer by DevBob

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!

View original
Did this topic help you find an answer to your question?

8 replies

Forum|alt.badge.img+7
  • Hero
  • 69 replies
  • June 25, 2020

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.

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 119 replies
  • June 25, 2020

thx, I will try that...


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 119 replies
  • June 25, 2020

Would my url be something like:

ifsapf:frmCustomerOrder_Cust?ORDER_NO=1859186

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 119 replies
  • June 25, 2020

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:

 

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 119 replies
  • June 25, 2020

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?

 

 

 

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 119 replies
  • June 25, 2020

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…

 

 

 


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 119 replies
  • Answer
  • June 25, 2020

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!


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • 119 replies
  • July 13, 2020

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


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