如何从内容引擎数据库获取选项列表项

Question

我有一些选择列表，我想从内容引擎数据库中导出它们的值以插入到另一个数据库中。

任何人都可以就查询提供建议吗？

Answer 1

FileNet 5.2.1.

    String s = "SELECT id, DisplayName from ChoiceList where DisplayName = 'YourChoiceListName'";
    SearchSQL searchSQL = new SearchSQL(s);
    SearchScope searchScope = new SearchScope(objectStore);
    RepositoryRowSet rowSet = searchScope.fetchRows(searchSQL, null, null, new Boolean(true));
    Iterator iter = rowSet.iterator();
    Id docId = null;
    RepositoryRow row = null ;
    while (iter.hasNext()) {
        row = (RepositoryRow) iter.next();
        docId = row.getProperties().get("Id").getIdValue();
        String DisplayName = row.getProperties().getStringValue("DisplayName");
        System.out.println(" Id=" + docId.toString());
        System.out.println(" DisplayName=" + DisplayName);
    }
    com.filenet.api.admin.ChoiceList list = Factory.ChoiceList.fetchInstance(objectStore,docId, null);
    com.filenet.api.collection.ChoiceList choicelist = null;
    choicelist = list.get_ChoiceValues();
    Iterator i = choicelist.iterator();
    while (i.hasNext() ) {
        com.filenet.apiimpl.core.ChoiceImpl choice = (ChoiceImpl) i.next();
        System.out.println(choice.get_DisplayName());
    }