Did anyone have the same necessity before? This dropdown list is supposed to query only the transaction items that meets a particular criteria

On your MRR record go to the item field Change the type to List/Record Then select Item as the record Then use the filtering sourcing tab to filer the item list by whatever criteria you want