Skip to main content
Solved

Can this quick report be made into a Lobby? 24R2

  • April 17, 2026
  • 5 replies
  • 112 views
S
Hero (Customer)
Forum|alt.badge.img+11

Hi All, 

 

I have this quick report that works, the users have asked if it could be in a lobby - it is using three tables to get the information, how can I do this in a lobby data source or is this not possible?

SELECT
    i.part_no,
    i.location_no,
    i.lot_batch_no,
    i.qty_onhand,
    i.receipt_date,
    p.max_quantity_capacity,
    h.handling_unit_id,
    h.handling_unit_type_id
FROM inventory_part_in_stock_uiv i,
     part_handling_unit p,
     handling_unit_extended h
WHERE i.contract = 'CAS'
  AND i.part_no = p.part_no
  AND h.handling_unit_type_id = p.handling_unit_type_id
  AND h.handling_unit_id = i.handling_unit_id
  AND i.qty_onhand <> 0
  AND i.qty_onhand <> p.max_quantity_capacity
  AND i.receipt_date >= sysdate -3
 

Thanks as always for your help, Sarah

Best answer by Tharshan SM

Hi ​@sholmes,

To deal with multiple joins you can simply create an IAL object and register it as an information source, so it will be available as a view in the Data Source Designer. Please find the steps below.

 

 

Then you have to create a Quick Information Source from the IAL object. You can find the view name there as well.

 

 

 

Then it will be available in the Data Source Designer.

 

 

Regards

5 replies

A
Do Gooder (Customer)
Forum|alt.badge.img+2
  • avinpwc
  • Do Gooder (Customer)
  • April 17, 2026

you can create this into Query design and try to use query as lobby datasource

Tharshan SM
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Tharshan SM
  • Do Gooder (Customer)
  • Answer
  • April 17, 2026

Hi ​@sholmes,

To deal with multiple joins you can simply create an IAL object and register it as an information source, so it will be available as a view in the Data Source Designer. Please find the steps below.

 

 

Then you have to create a Quick Information Source from the IAL object. You can find the view name there as well.

 

 

 

Then it will be available in the Data Source Designer.

 

 

Regards

    S
    Hero (Customer)
    Forum|alt.badge.img+11
    • sholmes
    • Author
    • Hero (Customer)
    • April 17, 2026

    ​@Tharshan SM  - hi, I’ve just tried this and get an error when trying to deploy the new IAL - any ideas?

     

    S
    Hero (Customer)
    Forum|alt.badge.img+11
    • sholmes
    • Author
    • Hero (Customer)
    • April 17, 2026

    ​@avinpwc - I can’t see a way to add the filter that i.qty_onhand <> p.max_quantity_capacity - am I missing something?

     

    Tharshan SM
    Do Gooder (Customer)
    Forum|alt.badge.img+4
    • Tharshan SM
    • Do Gooder (Customer)
    • April 17, 2026

    Hi ​@sholmes.

    As this is a completely different schema you have to prefix it with the application owner &AO.. Make sure you include the application owner prefix. Like below.

    SELECT
        i.part_no,
        i.location_no,
        i.lot_batch_no,
        i.qty_onhand,
        i.receipt_date,
        p.max_quantity_capacity,
        h.handling_unit_id,
        h.handling_unit_type_id
    FROM &AO..inventory_part_in_stock_uiv i,
         &AO..part_handling_unit p,
         &AO..handling_unit_extended h
    WHERE i.contract = 'CAS'
      AND i.part_no = p.part_no
      AND h.handling_unit_type_id = p.handling_unit_type_id
      AND h.handling_unit_id = i.handling_unit_id
      AND i.qty_onhand <> 0
      AND i.qty_onhand <> p.max_quantity_capacity
      AND i.receipt_date >= sysdate - 3

     

      Terms & ConditionsCookie settingsAccessibility statement