Is it possible to give us a sample query to model our custom queries against?

Unfortunately custom reports have very limited SQL coverage at the moment so there is no documentation yet for this. What are you trying to achieve? Or just to play around?

Custom Reports - Sample query - #3 by lubos - Uncategorized

Topic		Replies	Views	Activity
Learn custom reports Uncategorized	1	78	August 30, 2024
Custom Report Value by inventory location Uncategorized	1	206	May 6, 2023
Custom Reports Uncategorized	1	333	July 17, 2022
Customize reports Uncategorized	1	624	March 19, 2016
Need Custom report Uncategorized	2	592	September 28, 2017