You need to sign in to do that
Don't have an account?
Amitkumar15
SOQL Query Issue
Hi,
I have a SOAL to write which will pick all article which will expire in coming 14 days. i have a field Expires_c on article type.
[SELECT Id,createdById, ArticleNumber, KnowledgeArticleId, Expires_c FROM TEST__kav WHERE and PublishStatus = 'online' AND Language = 'en_US'].
What condition i have to add in where clause to achive this.
Any help.
Have you tried appending this?
AND Expires__c = NEXT_N_DAYS:14
Date Expired_Date = system.today().addDays(14) ;
[SELECT Id,createdById, ArticleNumber, KnowledgeArticleId, Expires_c FROM TEST__kav WHERE and PublishStatus = 'online' AND Language = 'en_US' AND Expired__C <: Expired_Date ].
Here is Expired__C is field on object. ( please check if I did spelling mistake)