read from table column with SDK

There is a code sample in the knowledgebase that shows how to write to a table column using a c# web service here (code sample) but I just need to iterate through the rows of a table and read the values from the Amount column.  Does anyone have some sample code to do that?

Jon,

First off, do you have access to the underlying database? It is always easier to query the index data directly if that is the case.

If you don;t have access to the database, then you need to get back document information one of two ways: 1) Pull down all documents in a file cabinet, or 2) Execute a query via the SDK to get a list of documents back. When you get a "Document" object back it isn't the actual document, but the record representing the indexes for the document (which is what you need).

This describes how you get all documents from a document tray or file cabinet:

https://developer.docuware.com/dotNet_CodeExamples/f9a6a984-57a9-42e9-8d26-1dd35611cf47.html

and this explains how to execute a query:

https://developer.docuware.com/dotNet_CodeExamples/b8b6ddf4-fee5-4b5c-84cc-046895c8aa5a.html

Note that the data you get back from this is not as easy to parse as, say, a relational database table. But you can parse the returned documents using loops and things like LINQ to pluck out the information you need.

Like I said, accessing the data directly is much more straightforward, so if that is an option, forego the SDK and hit the table directly. Just don;t do any modifications via that methodology.

Thanks,
Joe Kaufman

Hi Joe,

I've accessed DW documents using the SDK before so I'm ok with that part of it, but as for the rest I think you've got the best idea: forego the SDK hit the tables directly with a SQL query.  Thanks and have a great weekend!

Hi Jon,

you can find the table field with the sdk and loop through all columns and rows within it to get the value you need.
See my example in C#:

string TableFieldName = "myTableField";
Document document = conn.GetFromDocumentForDocumentAsync(docID, fileCabinet.Id).Result;
List<DocumentIndexField> fields = document.Fields;
DocumentIndexFieldTable table = fields.First(f => f.FieldLabel == TableFieldName).Item as DocumentIndexFieldTable;
int rowCount = table.Row.Count();
for (int i = 0; i < rowCount; i++)
            {
                // iterates through all table field columns
                for (int j = 0; j < table.Row[i].ColumnValue.Count(); j++)
                {
                    string currentFieldName = table.Row[i].ColumnValue[j].FieldName;
                    string itemAsString = ToStringNullSafe(table.Row[i].ColumnValue[j].Item);
                    // do more stuff with the data
                }
            }

Hope this helps.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

well-commented sample code! thanks, Simon :)