Lobby datasource using two views 24R2

Hello all,

Hoping that the technical among you can help me get this SQL query into a lobby for me.

The below works in a quick report but that relies on the user to run it, ideally I need this to be on the users lobby page when they log in so that they can see what might need to be actioned.

select

INVENTORY_PART_IN_STOCK_UIV.part_no,

INVENTORY_PART_IN_STOCK_UIV.contract,

INVENTORY_PART_IN_STOCK_UIV.qty_onhand,

INVENTORY_PART_IN_STOCK_UIV.qty_reserved,  

INVENTORY_PART_IN_STOCK_UIV.expiration_date,

INVENTORY_PART_IN_STOCK_UIV.expiration_date - INVENTORY_PART.min_durab_days_co_deliv as Last_Despatch_Date,

INVENTORY_PART_IN_STOCK_UIV.lot_batch_no,

INVENTORY_PART_IN_STOCK_UIV.location_no

from INVENTORY_PART_IN_STOCK_UIV, INVENTORY_PART

where

INVENTORY_PART_IN_STOCK_UIV.part_no = inventory_part.part_no and

INVENTORY_PART_IN_STOCK_UIV.contract = 'RAL' and

INVENTORY_PART_IN_STOCK_UIV.qty_onhand >0 and

INVENTORY_PART_IN_STOCK_UIV.expiration_date is not null and

(INVENTORY_PART_IN_STOCK_UIV.expiration_date - INVENTORY_PART.min_durab_days_co_deliv) <= (TRUNC(SYSDATE) + 28);

I’ve tried using the above where clause in the datasource designer using the view as INVENTORY_PART_IN_STOCK_UIV but it doesn’t like it, any help much appreciated here.

Sarah