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

Does DBAmp support the replication of all Knowledge objects?

We are implementing Salesforce Knowledge and want to back the artciles up locally. Getting the following error when doing this with DBAmp.

Implementation restriction: When querying or searching the CRArticle__kav 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.
1 person has
this question
+1
Reply
  • The error message is from the salesforce server. The salesforce.com api does not allow DBAmp to do a "select all columns, all rows" for this object.

    You can do select's against the object but you must use a where clause in the format the message suggests.

    For example, to get a copy of all the records you would do multiple Select's varying the PublishStatus for each Select.

    Let me know if you need more details.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • I've modified a query to get the extract with the following: PublishStatus = 'Online' and Language = 'en_US' ,

    Can this be incorporated into the sf_replicate proc or would that be a custom thing I would need to develop?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated

  • I can't really add it to sf_replicate because there is no assurance that the where clause will pull all rows for all customers. Some customers work in multiple languages.

    The other problem is that there is no way to incrementally refresh the local copy since queries using the LastModifiedDate are not supported.

    So I recommend that you construct a Select statement that meets your business needs and add that as a separate step to your workflow. In the current version of SF_ReplicateAll we skip the _kav tables for this reason.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated