Junction Entity data
Question

Hi

I want to Show Expertise Name in list and entity Employee.

I have taken a junction entity in which ExpertiseId is Expertise identifier (Static Entity).

I want to show Expertise Name . please Suggest for the same.

Thanks

SlimDirectoryApp.oml

Hi,

Please check out this thread someone posted the almost same question.

https://www.outsystems.com/forums/discussion/78344/need-logic-reactive-outsystem/

You can write SQL query to get the Employee data along with the expertise. (I have mentioned SQL query as well)

The solution that I have provided in this thread will display the data in tabular format.

check this demo.

Hello Manorama Malviya,

I don't know why you take some unnecessary table there but to show expertise name you need that two entities there which i mention

After adding that drag the label field in your screen to get expertise name 

 

I have attached the OML also

Hope this will helps you

Thanks and Regards,
Akshay Deshpande

SlimDirectoryApp.oml

I want to add multiple record from static Entity.

In this Post I already answer the particular things to show the multiple record in list In two ways
https://www.outsystems.com/forums/discussion/77267/how-to-save-the-selected-dropdown-tags-in-accordion-to-database/

Please refer that, may be this will help you. 

Thanks and Regards,

Akshay Deshpande

Hi Manorama,

I have created a sample to display data from junction table. I have used block in this sample.

https://personal-itafqtdv.outsystemscloud.com/JunctionSample/Home

Please see the attached OML.

Thanks

Vinod


JunctionSample.oml

Thank You but I want to add multiple Record from static Entity.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.