Clarification on displayvalue() method

Hi Prakash,

Please provide more detail. What version of OneIM are you using? Which column contains the dynamic foreign key?

The answer also depends on whether you are building your own custom form, or if your question relates to a OOB form.

Regards
Hanno

Hi Hanno,

Thank your for your reply. I am using OneIM Version 8.0. The dynamic foreign key column in PersonWantsOrg is 'ObjectKeyReference'. It seems to be a customized foreign key column. 

When I use the websql like from PersonWantsOrg select current displayvalue(ObjectKeyReference), I get the actual value "Key><T>ADSAccount</T><P>xxxxx-xxxx-xxx-xxxx-xxxxxxxxxxxxx</P></Key>in the Portal instead of display value

There is no database column of that name in the PersonWantsOrg table. Is this a WebDesigner property? If so, set the "property data source type" to "dynamic foreign key".

No, this is not webdesigner property, it is there as dynamic foreign key in PersonWantsOrg table

So I am assuming that you defined this column using the Schema Extension tool, correct? Is the column marked as a dynamic foreign key column when viewing its definition in Designer?

When loading the objects, on the "database access options" node in WebDesigner, make sure the option "load object displays even when loading them is expensive" is checked.

Yes it seems to extended property in PersonWantsOrg table, but I don't see it is exclusively loaded in respective Module/Component to view the options that you mentioned, but it is used in a Module as database object in a different name PWOtoDecide and as virtual collection in its respective components

Hi Hanno,

Could you please update me on this issue?

The only suggestion I have is to re-load the single PersonWantsOrg object using the loading option I mentioned.

You can also contact support if you need further assistance.

Thank you Hanno. Will look for the possibility of loading single object at the right place in the Module. If required, will get in touch with you or support team

Hi Hanno, Can you please guide me where I can find the displayvalue() script in designer. For example the definition of displayvalue for each table like Person, ADSGroup, ADSAccount and so on ...?