What am I missing SELECT tranid FROM transaction where type='SalesOrd' order by tranid group by tranid I'm getting Search error occurred: Failed to parse SQL [SELECT tranid FROM transaction where type='SalesOrd' order by tranid group by tranid]: syntax error, state:904(10102) near: group(5,1) no_root_node(-1000) near: no root node(0,0)

I believe GROUP BY should be before ORDER BY. But that's giving me a strange error (Invalid or unsupported search). You could try

SELECT DISTINCT tranid FROM transaction where type='SalesOrd' order by  tranid