Hi all,
I created a form using DOM. Instead of entering all available option in DOM editor, I use people and organization and resource studio in MediaOp. For example, i created 3 organization in people and organization (organization A, B and C for example). Then in DOM editor, I select DomInstanceFieldDescriptor, and then select (slc)people_organization, and + organization in DOM.
After I save the form, and query, it shows the organization field ID instead of the name (organization A for example). May I know how to resolve?
Hi SK,
When you use a 'DomInstanceFieldDescriptor', the ID of the linked DOM instance (organization in your case) is stored on the new DOM instance. GQI will simply retrieve this value and output it to the visualization (like a table). If you would prefer to see the organization name, you can use the 'Join' GQI operator to join the organization DOM instance to your own DOM instances, and select the name of the organization DOM instance (in that select, you can remove the field containing the ID then).
Keep in mind that currently, GQI would retrieve all DOM instances that are joined (all organization DOM instances). If you only have a few (tens or maybe a few hundred), this should be fine. Let me know if your situation is different, so I can suggest an alternative approach that would be more performant.
Thanks Thomas, JOIN works and now my table is showing name instead of the ID.