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%
Failing Query
Failing Query
Mark
Running V5.7 (Build 1714) Linux Server. MySQL
Running V5.7 (Build 1714) Linux Server. MySQL