advanced report raw query

Discuss your general Proclaim related queries here.
Post Reply
danny
Posts: 32
Joined: Sun Mar 11, 2012 11:28 pm
Has thanked: 3 times

advanced report raw query

Post by danny » Mon Jul 01, 2019 8:30 am

alright
anyone know how to see the actual underlyingn query that the advanced report creator is using/creating?
i can set the criteria ok but want to see the actual query it is spitting out as i think its doing something funky
thx

DannyMGem
Posts: 5
Joined: Thu Mar 16, 2017 10:43 pm
Has thanked: 2 times
Been thanked: 4 times

Re: advanced report raw query

Post by DannyMGem » Tue Jul 09, 2019 5:46 pm

Hi Danny,

If you include an extra condition so the report contradicts itself on the criteria, a prompt will then be displayed at runtime saying 'bad query' and also display the underlying Openedge query underneath.

--
Dan

danny
Posts: 32
Joined: Sun Mar 11, 2012 11:28 pm
Has thanked: 3 times

Re: advanced report raw query

Post by danny » Sat Jul 20, 2019 9:06 pm

nice one ill give it a go ta

Post Reply