I have searched high and low and can’t find a good method of looping through a document retrieving the string names and values.
For example, I have the following XML that is converted into a document:
ASSET NOT ON FILE
INVALID ASSET TYPE
CANNOT BE RELEASED
ORDER NOT ACCEPTED
The result of converting this to a document is a document named STATUS_MSG and 3 fields named SMO008, SMO009, SMO020 and a string list named ALERT.
There are over 20 fields and instead of coding for each specific field I would rather repeat through the document getting each string name and value. For example, on the first iteration I would retrieve the string name SMO008 and the value ASSET NOT ON FILE.
Does anybody have a solution or suggestion?
What you’re trying to do with the data may help a bit here, but you can write a small Java service that loops over the entries in the Document. For example:
public static void MyService(IData pipline)
IDataCursor cursor = pipeline.getCursor();
String key = cursor.getKey();
Object value = cursor.getValue();
// do whatever you need
This handles a flat structure of key/values. To handle nested data all you need to do is check the type of value. If it’s an IData you can recursively call the same service.
Try this service in WmPublic:
(IS 4.6) pub.record:recordToRecordList
(IS 6.x) pub.document:documentToDocumentList
It takes three inputs:
- Your document
- A name for the keys, eg. key
- A name for the values, eg. value
It returns a record/document list, each document having two fields:
- With the name you specified in point 2 above, the original name of the field from your document.
- With the name you specified in point 3 above, the value of the field.