Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Implementation Restriction

I can successfully export data through SFDC's Data Loader tool using the following query, but can't through DBAmp:

Select Id, KnowledgeArticleId, OwnerId, IsDeleted, ValidationStatus, PublishStatus, VersionNumber, IsVisibleInApp, IsVisibleInPkb, IsVisibleInCsp,
IsVisibleInPrm, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, IsMasterLanguage, Language, Title, UrlName,
CurrencyIsoCode, ArchivedDate, ArchivedById, Summary, ArticleNumber, FirstPublishedDate, LastPublishedDate, SourceId, IsOutOfDate, MasterVersionId,
TranslationCompletedDate, TranslationExportedDate, TranslationImportedDate
FROM salesforce_sandboxkb...KnowledgeArticleVersion
WHERE PublishStatus = 'Online' AND Language = 'en_US'

The error is:
OLE DB provider "DBAmp.DBAmp" for linked server "salesforce_sandboxkb" returned message "Implementation restriction: When querying or searching the KnowledgeArticleVersion object, you must filter using the following syntax: Id = [single ID], Id IN [list of ID's] or PublishStatus = [status]. In addition PublishStatus is only permitted in a top-level AND condition.".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."ArchivedById" "Col1005","Tbl1002"."ArchivedDate" "Col1006","Tbl1002"."ArticleNumber" "Col1007","Tbl1002"."CreatedById" "Col1008","Tbl1002"."CreatedDate" "Col1009","Tbl1002"."CurrencyIsoCode" "Col1010","Tbl1002"."FirstPublishedDate" "Col1011","Tbl1002"."Id" "Col1012","Tbl1002"."IsDeleted" "Col1013","Tbl1002"."IsMasterLanguage" "Col1014","Tbl1002"."IsOutOfDate" "Col1015","Tbl1002"."IsVisibleInApp" "Col1016","Tbl1002"."IsVisibleInCsp" "Col1017","Tbl1002"."IsVisibleInPkb" "Col1018","Tbl1002"."IsVisibleInPrm" "Col1019","Tbl1002"."KnowledgeArticleId" "Col1020","Tbl1002"."Language" "Col1021","Tbl1002"."LastModifiedById" "Col1022","Tbl1002"."LastModifiedDate" "Col1023","Tbl1002"."LastPublishedDate" "Col1024","Tbl1002"."MasterVersionId" "Col1025","Tbl1002"."OwnerId" "Col1026","Tbl1002"."PublishStatus" "Col1027","Tbl1002"."SourceId" "Col1028","Tbl1002"."Summary" "Col1029","Tbl1002"."SystemModstamp" "Col1030","Tbl1002"."Title" "Col1031","Tbl1002"."TranslationCompletedDate" "Col1032","Tbl1002"."TranslationExportedDate" "Col1033","Tbl1002"."TranslationImportedDate" "Col1034","Tbl1002"."UrlName" "Col1035","Tbl1002"."ValidationStatus" "Col1036","Tbl1002"."VersionNumber" "Col1003" FROM "KnowledgeArticleVersion" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "salesforce_sandboxkb".

While I understand the Implementation Restriction error, I am fulfilling the requirements outlined by the error message and should be able to return data, should I not?
1 person has
this question
+1
Reply