Requirement is to display different images for different records in the record l

From what I can tell the document ID is always an integer, easy enough right? The tricky part is moving between environments. I've observed that the id is anything but static and not a good reference.

The solution will of course depend on your situation. The way I've done this is to use a constant of type "Document" to store the reference to the actual document in the system. This reference will stay up to date through updates, migration, or whatever. Then I use some other field in the record (status, loan type, user, or anything really) to determine which image is selected for the listing.

This approach works well if the image is pre-determined in the system, if it's unique to each record and can't be pre-determined this probably won't work.

Doc ID's are not the same across environments. This means that the Doc ID for image A.jpg may be 15 on DEV, but once imported to Test the environment will assign it ID 21.

I suggest you store the UUID instead, this way even if the document gets deleted and replaced you won't need to update the DB. For this you will need the Content Details by UUID plug-in forum.appian.com/.../summary


1. You can store the UUID of the document using the following expression to retrieve it and then store by your preferred mean in a column of type text (e.g.varchar) in your table

=keyval(getcontentobjectdetailsbyid(document(ri!myDoc,"id")),{"UUID"},":",",")

2. You can later "transform" it in a document by retrieving the UUID from the DB and converting it to a document object:

=todocument(keyval(getcontentdetailsbyuuid(pv!retrievedUUIDFromTable),{"Id"},":",","))

Thanks Tim and Eduardo!

Thanks James!

Well the document UUID is a new one on me. I'll definitely be grabbing that plugin, very cool Eduardo.

In 7.7 I don't see the UUID detail by document id. Missing something? Eg getcontentobjectdetailsbyid(30073) returns:

Content Object[ Name=avatarCAOF9KPO.jpg Parent= Test Folder Type: Document

That output doesn't look complete. Can you simply run

=getcontentobjectdetailsbyid(30073)

no other functions and see if you get the UUID? If so then I'll need to see why keyval is not working. Also make sure you download the latest version.

Ok it works, I had an old version. Question: is it possible to add a folder to an application and also automatically add everything under that folder? It looks like one has to manually add the subfolders and docs to the application? That's not feasible if there are lots of them; a solution for that would be great.

Never mind please. There's the "Add Contents" for that.