java 获取带有属性的 Filenet 文档

Fetch a Filenet document with Properties

提问by Archangle

I'm trying to do a test program deal with Filenet Documents. I know how to get a document Instance with Object Idor pathlike ,

我正在尝试处理 Filenet 文档的测试程序。我知道如何使用Object Id或path喜欢获取文档实例，

doc  =  Factory.Document.fetchInstance(os,ID,null);
doc  =  Factory.Document.fetchInstance(os,path,null);

but I like to add more finding options so I can fetch, Document with name or a custom property . I am trying out this search as a approach to that:

但我喜欢添加更多查找选项，以便我可以获取、带有名称的文档或自定义属性。我正在尝试将此搜索作为解决此问题的方法：

String mySQLString = "SELECT * FROM DEMO WHERE DocumentTitle LIKE '"+prp+"'";
    SearchSQL sqlObject = new SearchSQL();
    sqlObject.setQueryString(mySQLString);

   // System.out.println(mySQLString);
    SearchScope searchScope = new SearchScope(os);
    RepositoryRowSet rowSet = searchScope.fetchRows(sqlObject, null, null, new Boolean(true));
    Iterator ppg = rowSet.iterator();

    if (ppg.hasNext()) {

            RepositoryRow rr = (RepositoryRow) ppg.next();
            System.err.println(rr.getProperties());
            Properties properties = rr.getProperties();

            String ID = properties.getStringValue("ID");
            System.out.println(ID);

    doc  =  Factory.Document.fetchInstance(os,ID,null);

But ID is not a Document property , it's a System property. How can I get the document? How can I get the pathor idwith a Search and fetch this document ? Is there a fast way ?

但 ID 不是 Document 属性，它是 System 属性。我怎样才能得到文件？如何通过搜索获取path或id并获取此文档？有快速的方法吗？

回答by Archangle

After few little changes I have made it work. Following is the code

经过一些小改动后，我让它工作了。以下是代码

    String mySQLString = "SELECT ID FROM Document WHERE DocumentTitle LIKE '"+prp+"'";
    SearchSQL sqlObject = new SearchSQL();
    sqlObject.setQueryString(mySQLString);

    SearchScope searchScope = new SearchScope(os);
    RepositoryRowSet rowSet = searchScope.fetchRows(sqlObject, null, null, new Boolean(true));
    Iterator ppg = rowSet.iterator();

    if (ppg.hasNext()) {

            RepositoryRow rr = (RepositoryRow) ppg.next();
            System.err.println(rr.getProperties());
            Properties properties = rr.getProperties();

            String ID = properties.getIdValue("ID").toString();
            System.out.println(ID);                

            doc  =  Factory.Document.fetchInstance(os,ID,null);

    }

now with few changes this can be use to get any document with property.

现在只需稍加改动，就可以使用它来获取任何具有属性的文档。

回答by Ajay Kumar

You can iterate through all the documents. Take a look at this:

您可以遍历所有文档。看看这个：

public void iterateThruAllDocs(ObjectStore os, String foldername) {
    Folder folder = Factory.Folder.fetchInstance(os, foldername, null);
    Document doc = Factory.Document.getInstance(os, null, foldername);

    DocumentSet docset = folder.get_ContainedDocuments();
    Iterator<DocumentSet> docitr = docset.iterator();

    while (docitr.hasNext()) {

        doc = (Document) docitr.next();
        String mydocid = doc.get_Id().toString();
        Document mydoc = Factory.Document.fetchInstance(os, mydocid, null);
        AccessPermissionList apl = mydoc.get_Permissions();
        Iterator ite = apl.iterator();
        while (ite.hasNext()) {
            Properties documentProperties = doc.getProperties();
            String DateCreated = documentProperties.getDateTimeValue("DateCreated").toString();
            String DateLastModified = documentProperties.getDateTimeValue("DateLastModified").toString();
            Permission permission = (Permission) ite.next();
            String docTitle = doc.getProperties().getStringValue("DocumentTitle");
            System.out.println("Document Title for document with DocumentID \"" + mydoc.get_Id() + "\" is \"" + docTitle + "\"");
            //String someprop = documentProperties.getStringValue("someprop");
            System.out.println("Document was Created on  :: " + DateCreated);
            System.out.println("Document was Last Modified on :: " + DateLastModified);
            System.out.println("Grantee Name :: " + permission.get_GranteeName());
            //if (permission.get_GranteeName().equals(groupname/username)) {
            //permission.set_GranteeName("groupname/username");
            //  System.out.println("Security REMOVED for document....");
            //mydoc.save(RefreshMode.REFRESH);
            // Go Nuts on Documents Here......
            break;
        }
    }
}