Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to include non-approved documents?

  Asked By: Margarita    Date: Jan 12    Category: Sharepoint    Views: 1012

Can anyone help me to get through this problem?

I need to view non-approved documents on a webpart.
I've managed to view only for approved/published
documents using ASP (through ADODB connection) and
queries, but the non-approved
documents are not included. How can I specify
non-approved documents to be included also?

Or, is there another way to do this not by using ASP
and queries?

I'm using Sharepoint Portal Server 2001 on Windows
2000 Server.

I realy..realy.. need your guidance and inputs.



3 Answers Found

Answer #1    Answered By: Mohini Tiwari     Answered On: Jan 12

U can import the attached web part into ur sharepoint  site or below is
the script for the embedded content and the XSL content. U will get a
combo box which has the docs checked out to u, awaiting ur approval and
pending approval. Hope this solves ur problem.

Answer #2    Answered By: Natasha Bennett     Answered On: Jan 12

Thank you for your reply.

I've tried your code but I always got this error on my webpart:
"Script Execution Error: Syntax error " What is the problem? and What should I

i've tried to check the syntax, but I haven't find the problem yet, I will try
it again..
As I informed you that I've managed  viewing only the published document...

This is my query:

select ""DAV:creationdate"", ""DAV:href"", ""DAV:displayname"",
""DAV:getlastmodified"" from scope('deep traversal of ""/%my_workspace%/""')
where ""DAV:contentclass"" <> 'urn:content-classes:smartfolder' ORDER BY
""DAV:getlastmodified"" ASC

Can I just specify the scope to include  the non-approved/unpublished documents  ?

Answer #3    Answered By: Angel Matthews     Answered On: Jan 12

I've done viewing the
webpart on my dashboard (previously, I didn't run the
script first). Thanks..

But actually that's not my question, sorry if there
was any ambiguity in my question.

What I meant was, how can I view  all the unpublished
versions? Because my client want to make a weekly
report, which contains all published documents  and
also their corresponding unpublished versions.

I've tried to use PKMCDO (using VersionHistory method)
on ASP, but when I create the object:

Set oDoc = CreateObject("PKMCDO.KnowledgeDocument")
set oVer = CreateObject("PKMCDO.KnowledgeVersion")
set oRS = CreateObject("ADODB.Recordset")
set oStream = CreateObject("ADODB.Stream")

I always get this error on my browser:

Error Type:
Microsoft VBScript runtime (0x800A01AD)
ActiveX component can't create object:

I've tried to register the dll ("regsvr32
pkmcdo.dll"), but it still doesn't work..

Does anyone know on how to use PKMCDO on ASP?
Is there any other way to do this (without PKMCDO and

Didn't find what you were looking for? Find more on How to include non-approved documents? Or get search suggestion and latest updates.