Junction Entity data


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.




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


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


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

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.


Please see the attached 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.