Failing Query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Mark HHP
Posts: 387
Joined: Mon May 06, 2013 6:59 am
Location: Cape Town, South Africa

Failing Query

Post by Mark HHP »

I'm running a query but it keeps failing to display the results. When I enter into the rule section, it greys out the simple form section.

So I enter:

FIND ForecastLineItem WHERE ForecastLineItem.Consultant.ID = LoggedInConsultant.ID (this part works)

but if I try add:

AND ForecastLineItem.Probability='70% +' OR ForecastLineItem.Probability='80%' OR ForecastLineItem.Probability='99%'

That's when it goes haywire. The Probability attributes are plain text, not numbers. Basically, I have two queries displaying, one for ForecastLineItems over 70% and one for ForecastLineItems under 70%
Mark
Running V5.7 (Build 1714) Linux Server. MySQL
Post Reply