Find artcles awaiting moderation on database

[Scanu]

Where can i see articles awaiting moderation on the database? In the table cms_articles i don't find anything about moderation

[kh99]

Do you mean unpublished articles? I think what you want is the setpublish field in the cms_node table (where the contenttypeid field matches the 'vBCms_Article' content type id).

[Scanu]

So if setpublish is 0 the article isn't moderated else is moderated and so published am i right?

[kh99]

Well, to be honest, maybe you're talking about something different than "unpublished", because I don't see it being called "moderated" anywhere. Were do you go to see articles awaiting moderation?

[Scanu]

Really i've never see anything awaiting moderation (just in the database)
but some users request to add articles to moderate to my mod quick moderation. So i think that is there. I've added many things like group and visitor message, picture comment and blog to moderate, all things that i found on the database but can't see anything about articles to moderate

[kh99]

OK, well, all I know is that setpublish = 0 means that it is "not published". Maybe someone else will know if there's another "awaiting moderation" setting for articles.