versioning and approval for folder active?

[Former Member]

does anyone know a sql-statement to find out if versioning and/or approval for a folder is activated.

i checked the tables in database, but did not find a matching entry.

thanks!

matthias

[Former Member]

hello julian!

if you could provide me more details about a scripting solution, that would help me a lot!

thanks

matthias

[Former Member]

hello!

i agree that it would be better to use km-api in general. in this case i would like to get the information only once after migration of content and i do not have any development environment installed. is there a possibility via sql or do i have to do it via java?

thanks!

matthias

[Former Member]

You could also do it through WebDAV, which wouldn't require any development environment except a script language with HTTP library (such as JScript on Windows). Let me know if you need more details.

Best regards, Julian

[Former Member]

Hi.

<i>Note that table layouts aren't part of the API and are subject to change without notice.</i>

To check whether the KM's "folder versioning" is activated, try the following code:

ICollection coll; // collection to check

IVersionController vc = (IVersionController)coll.as(IVersionController.class);

if (vc != null) {
  System.out.println("enhanced versioning: " + vc.isEnabled());
}

(see also http://media.sdn.sap.com/html/submitted_docs/60_sp2_javadocs/km/com/sapportals/wcm/repository/IVersi....

Hope this helps,

Julian

[detlev_beutner]

Hi Matthias,

a general advise: Do not access the WCM DB directly. It is a black box, subject to change anytime without notice by SAP through patches, and almost everything is accessible via Java KM API.

This also holds for the information you are asking for:

FolderSettings folderSettings = new FolderSettings(coll);
boolean versioned = folderSettings.isEnhanced().booleanValue();
boolean appr = folderSettings.isStatemanagementEnabled().booleanValue();

Hope it helps

Detlev

Message was edited by: Detlev Beutner

Julian has been faster. Also, FolderSettings istn't public, as far as I know, but if you care, have a look at it's implementation.