Skip to main content

Solved

2 Topics
D
Sidekick (Customer)
DevBobSidekick (Customer)
asked in Assets (Asset Management)
Lobby: Drill-Down Summary Element to Detail

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?  

8
D
Sidekick (Customer)
4 years ago
D
Sidekick (Customer)
DevBobSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
SQL- SubQuery's FETCH FIRST 1 ROWS ONLY operating on entire results instead of each row

This quick report’s subquery that has FETCH FIRST 1 ROWS ONLY to pull the first PO is only returning one row for the entire report; not for each part#:SA-807 has a qualifying row as well; we should see a Next Supply Qty and Next Supply Date as we ll as SA-811.  selectip.contract,ip.part_no,ip.type_code_db,ip.part_product_code as Product_Code,ip.type_designation,sp.catalog_group as Sales_Group,ipp.safety_stock,ipcp.qty_available as Available_Inventory,ipp.safety_stock - ipcp.qty_available as Over_Short,( SELECTosd.qty_supply as Next_Supply_Qtyfrom ORDER_SUPP_DEM_EXT_TMP_VIEW osd where osd.contract = ip.contract and osd.part_no = ip.part_no and ( osd.order_supply_demand_type = 'Shop Order' and osd.status_Desc in ('Planned', 'Started', 'Released')or osd.order_supply_demand_type = 'Purch Order' and osd.status_Desc in ('Planned', 'Released', 'Received') ) order by osd.date_requiredFETCH FIRST 1 ROWS ONLY ) as Next_Supply_Qty,( SELECTosd.date_required as Next_Supply_Datefrom ORDER_SUPP_

1
D
Sidekick (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings