Apex Code Development You need to sign in to do that
Don't have an account?
PARISE RAVIKIRAN How to write AND Status__c IN :SUC_Constants.ACTION_ITEM_STATUS_SETIn this line who to write Status__c is equal to closed in apex line
sp.actionItems = [
SELECT Customer_Objective__r.Objective_Name__c, Priority__c, Due_Date__c, Subject__c, Assigned_To__r.Name, Status__c
FROM Action_Item__c
WHERE
Success_Plan__c = :successPlanId
AND Status__c IN :SUC_Constants.ACTION_ITEM_STATUS_SET
AND Internal_External__c = :SUC_Constants.ACTION_ITEM_INT_EXT_EXT
ORDER BY Customer_Objective__r.Objective_Name__c
];
How to write That Status__c not equal Closed.
SELECT Customer_Objective__r.Objective_Name__c, Priority__c, Due_Date__c, Subject__c, Assigned_To__r.Name, Status__c
FROM Action_Item__c
WHERE
Success_Plan__c = :successPlanId
AND Status__c IN :SUC_Constants.ACTION_ITEM_STATUS_SET
AND Internal_External__c = :SUC_Constants.ACTION_ITEM_INT_EXT_EXT
ORDER BY Customer_Objective__r.Objective_Name__c
];
How to write That Status__c not equal Closed.
All Answers
You can add AND Status__c != 'Closed' in your SOQL request like that
sp.actionItems = [ SELECT Customer_Objective__r.Objective_Name__c, Priority__c, Due_Date__c, Subject__c, Assigned_To__r.Name, Status__c FROM Action_Item__c WHERE Success_Plan__c = :successPlanId AND Status__c IN :SUC_Constants.ACTION_ITEM_STATUS_SET AND Status__c != 'Closed' AND Internal_External__c = :SUC_Constants.ACTION_ITEM_INT_EXT_EXT ORDER BY Customer_Objective__r.Objective_Name__c ];Please mark this comment as best answer or like it if it's help you.