You need to sign in to do that
Don't have an account?
Selvakumar Anbazhagan 7
Formula to SOQL Query
Hi Everyone,
I need to convert opportunity formula into SOQL Query. Can anyone help me on this.
My Opportunity formula is,
AND(
AND(
ISBLANK(Last_Stage_Change__c),
NOW() - LastModifiedDate > 30,
Probability < 0.91,
Probability > 0.01
),
AND(
NOW() - Last_Stage_Change__c > 30,
Probability < 0.91,
Probability > 0.01
)
)
My query is that,
select Id,StageName,LastModifiedDate from Opportunity Where "Formula Condition"
Thanks in advance.
I need to convert opportunity formula into SOQL Query. Can anyone help me on this.
My Opportunity formula is,
AND(
AND(
ISBLANK(Last_Stage_Change__c),
NOW() - LastModifiedDate > 30,
Probability < 0.91,
Probability > 0.01
),
AND(
NOW() - Last_Stage_Change__c > 30,
Probability < 0.91,
Probability > 0.01
)
)
My query is that,
select Id,StageName,LastModifiedDate from Opportunity Where "Formula Condition"
Thanks in advance.
I would like to suggest create two formula fields,
In FormulaField1__c use the below formula with return type number, In FormulaField2__c use the below formula with return type number,
Build the SOQL query like below,
If this information helps, mark this as solution.
Thanks.