Hi,

we want to find document based on the retrieval name.

The java API search gives us no way to do this.
Even with the CSS engine, the following query returns no matching hit :
SELECT d.this, DocumentTitle,Name FROM [GEDFI_Documents] d INNER JOIN ContentSearch v ON v.QueriedObject= d.This WHERE d.IsCurrentVersion= TRUE AND CONTAINS(d.*, 'RETRIEVAL NAME')
OPTIONS(TIMELIMIT 180,COUNT_LIMIT 1000)

Is there a way to launch a search on retrieval name on CPE ?

Thanks

------------------------------
Yannick Martin
------------------------------

If you mean based on the RetrievalName property of a content element of a document, no, there is no way to do that.

------------------------------
Mike
------------------------------

I had that desire too and failed. As Mike said it is impossible. The retrieval names are encoded in a document attribute sequentially for the respective content elements. One could write a function to decode to a string (if algorithm is known) and then query for a substring. The search can only be sequential then...

Br,
/Gerold

------------------------------
Gerold Krommer
------------------------------

Hi Yiannick,

I am not a developer but if API can get you the Retrieval name but cannot search using its value, perhaps you may have to create an additional user property for Retrieval name, update its value on document creation using a code module and then search the way you search a normal property.

BR

------------------------------
Christos Chorattides
Datatech
------------------------------