Problem generating a list of index values with the API

Hello.

I have to add some index values to a list.
in SQL i would serch like this:
SELECT DISTINCT <indexfield> IN dwdata.dbo.<archive> where <serch condition>

How can i do this with the API?
A search with a DocumentsQueryResult is too slow because it  returns to many documents with the same index value, which I want to add to my list only once.
I can't limit the search with DialogExpressionConditions far enough.

The DocuWare API does not provide direct database access. In an On-Premise system you would have to write your own connection and query using standard programming tools.


Phil Robson
Senior Director Client Services, Americas

Thanks for your answer, but thats not what i wanted to say.

The query is just an example of how I would try to get my data over SQL.

How can i get the Same result with the API?

I need a fast way to create a list of Indexdata.

To process the single documents of a DocumentsQueryResult is way to slow for my needs.

Hi Martin,
this post is old, but could you figure it out? If not I would be interested in understand what is slow, and why you think, that you cannot limit it far enough. Do you just need the data from a single column? Or just the data like it is shown in a select list?

A customer always has several documents in his DocuWare, which are linked with a file number.
I need to use the API to create a list of all file numbers to which documents with a certain status are assigned.
This can quickly lead to a large amount of data to be evaluated, because a query via the API does not allow something like DISTINKT (as in SQL).
If you have to process a document list with 300 documents, it will be quite slow.
In the meantime I switched to SQL out of necessity.

Hi Martin,
I do not know how you want to access this, but basically it sounds like you want to have a filtered select list. With the help of the platform (REST) it would work like this:
Make a REST call for the select list to get the whole select list

https://[server]/DocuWare/Platform/FileCabinets/[File Cabinet GUID]/Query/SelectListExpression?dialogId=[Dialog GUID]&fieldName=CONTACT

To filter the select list you have to add some body (to the REST call) with the query condition e.g.

{"ValuePrefix":"","Limit":100,"Typed":true,"ExcludeExternal":true,"DialogExpression":{"Operation":"And","Condition":[{"DBName":"DOCUMENTTYPE","Value":["\"Photo\""]}]}}

I hope this makes it clearer.