1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Stellent UCM: Get unique metafield values of existing documents

Discussion in 'Oracle Development General' started by Anton, Jun 26, 2012.

  1. Anton

    Anton Guest

    Hello everyone,

    I need to get unique metafield values of existing documents in Stellent database. In SQL it can be described like:

    SELECT DISTINCT dDocFormat FROM documents

    I tried GET_DOC_CONFIG_INFO service, but it's DocFormat result set contains all possible formats instead of actually used. Also I was trying to google something around optList Idoc function and loadMetaOptionsList but no still no luck.

    I need to solve the task from Java via RIDC but I'm happy to know at least how can it solved from any API.

    Your help and hints are highly appreciated,
    Thank you, Anton.