How to limit the records within the current date in the query report once it expires the pricing rule date?

[erpnext_user99]

I want to make a query report which shows the item records with their related pricing rules but the item record should get disabled when the pricing rule date expires.

Thanks.