We are trying to search for Items, and essentially return transaction information only where available, but return all other item records even if there is no sales history.
So, I set up a saved search and added "Transaction fields..." to filter the criteria as needed (date, type, account, etc). The issue is that I want to return ALL item records and show only transaction data for those that have it - like you would with a SQL Join. Basically, I am looking for a Left Join, displaying NULLS where necessary.
Any help on accomplishing this is appreciated. I perused the forum but surprisingly can't come across a post with a similar need.
Thanks!