Consult BYD OVS to return multiple column values

[former_member585975]

Dear teachers, good. Ask a question about the CRM service to determine object references. I created a custom object test04 that needs to reference the contents of the two fields in the service validation object. Then, I created the service confirmation OVS, the query content has ID and name. And associate OVS with test04 You can play the pop-up window normally, select, and return the ID of the query result in OVS. How can I return the ID and Name in OVS at the same time?

ServiceConfirmation OVS

Actual use result

I want the ID to be displayed in SCID and Descriptio to be displayed in TextCollection. May I ask the teacher, what do I have to do to achieve the effect I want?

[rohanarthur]

hi Kevin,

the configuration on the OVS looks correct.
There are some other steps needed in the 'source' side, not sure if this is done in your case.

For your example, the 'source' is the QA for 'Test04', and the underlying field for Service Confirmation ID.
Open the properties for this field in UI designer, and check whether you have maintained both 'Text' and 'Value' properties under section 'Data Information'

If this is not done, please follow these steps:

- You will need an association from your custom BO to Service Confirmation. Let's call it 'ToServiceConfirmation'.

- Next, open the data model of your Test04 QA, and add a data field that is bound to Test04-->ToServiceConfirmation-->Name

- For better clarity, you can rename your data field to ServiceConfirmationName

- Next, go back to the field properties of your field for service confirmation ID

- Bind the 'Text' property to this newly added field in your data model, ServiceConfirmationName

Hope this helps.

Also note: From your BODL, it looks like you are interested in the TextCollection.
The Service Confirmation's 'Name' field is mapped to 'Subject' on the UI, and you might be interested in that one instead.
If you want the TextCollection, then you would have to use a complex logic to determine the relevant instance under ServiceConfirmation-->TextCollection-->Text-->TextContent.

Regards,
Rohan

[former_member585975]

Hello. Rohan. Thank you very much for your answer. I have implemented my description by writing logic code in the object Event-AfterModify, but I am very grateful for your solution. Very interested in the method you provide, it is simpler than the code. I will contact you after I have time to practice. Good luck. Thank you.