Automatically Fetch and Display Course Title Based on Course ID in a Data View
0
Hi everyone, I'm currently working on a project in Mendix Studio Pro 10.14, integrated with an Oracle database. I can successfully retrieve data from the database and add new records to my table. While adding an event, I’ve added a combo box for selecting the Course ID. However, I want the Course Title to be fetched automatically based on the selected Course ID and displayed in the data view while adding the event. Here’s what I’ve tried: I created a microflow to fetch the Course Title based on the selected Course ID. The microflow returns the data in a list format, but I need it to be displayed as a single object in the data view. note: all entity are non persistable. My Question:How can I convert the list returned by the microflow into an object and display the Course Title dynamically in the data view? Any guidance or best practices would be greatly appreciated! Thanks in advance!
asked
Rakesh kumar Gouda
1 answers
0
If you make certain that the list always contains one object just use the head action to convert the list to the first object of that list. But also note that in a combobox you can show multiple fields if both are in the same object. Use caption type expression. See screenshot:
And you will get this result:
Regards,
Ronald
answered
Ronald Catersels