ad hoc reports examples
query examples with generated SQL links below each example
basic query
generated basic query
multi join query
generated multi join query
basic sub-query
generated basic sub-query
mixed sub-query with joins
generated mixed sub-query with joins
pivot and group query
generated pivot and group query
multi-schema query
generated multi-schema query
effective date query
generated effective date query