Check if document is Published via SQL DB

Bea Y asked on July 1, 2015 09:04

Hi! :)

I'd like to ask how we'll be able to check if a document or blog post is published via SQL DB. I'm using Kentico 5.5 r2.

Thanks.

Recent Answers

Martin Danko answered on July 1, 2015 11:49

Hello Bea,

Do you know that Kentico 5.x is not supported anymore?

Please read this article from our CEO for more details: Announcing End of Support of pre-5.0 Versions

Best regards, Martin

1 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on July 1, 2015 15:21

It would be best to use the API because there are too many scenarios that could cause the wrong information to be retrieved. For instance, if you are using workflow, is the document in workflow? Or if you're using versioning, you want to make sure you get the latest version, of course that is published. There are about 4 or 5 tables to look in (for newer versions anyways).

1 votesVote for this answer Mark as a Correct answer