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.
Not really clear for me what you are trying to achieve. If you want to link DOM definitions together you can indeed link them by adding a field in your DOM definition that points to another DOM instance.
I would expect that when you create or edit an instance through a form in LCA, that you get a drop down to select the instance. That dropdown should show the name instead of the ID if a name definition is defined on the DOM definition. If you link it to the standard organizations definitions of MediaOps there should already be a Name definition that points to the name of the organization. Keep in mind that things might change in future version of MediaOps on data layer. We are working towards defining good helper classes that can be used in code that will be backwards compatible.
Note: In MediaOps solution we are moving more and more towards interactive automation scripts (scripting the UI) instead of forms as there are some limitations to forms (linked to data layer structure).
Some limitations for which we move to IAS:
- No validation (it is immediately stored in DB).
- When you linked objects in DOM all instances will be shown in the dropdown (regardless of their state).
- On create all sections are shown (even the ones you want to hide for the user)
Hi Michael, Yes, I linked DOM instance to another DOM instance using either DOMInstanceFieldDescriptor or DOMInstanceValueFieldDescriptor. In the form, I can see the name. But when I use the GQI to queue it, it just show the ID, not the name. I used JOIN as suggested by Thomas and it works now. Thanks.
Thanks Thomas, JOIN works and now my table is showing name instead of the ID.