342
Views
7
Comments
Solved
display entity column names on screen in dropdown

Hi Team,

Can anyone please suggest how to display entities columns and data type on screen for users to see .

I need to make form where user will make mapping from excel columns(Headers) and select columns from database on screen with their data type constarints

Please share some sample oml if any.


2018-12-10 12-16-21
Goncalo Duarte Almeida
Solution

Hi @ujwwala tembbekar 

You can get that data from these entities


Entity stores the entities names and the Entity_Attr stores the Attributes by entity.

Regards

Gonçalo Almeida

2020-09-21 11-35-56
Sachin Waghmare
Solution

Hi Ujwwala,

Please find attached the OML for your request. Kindly review it and let me know, if you need any other help.

Thanks & Kind Regards,

Sachin

empaddSachin25.oml
2026-02-26 06-29-24
Rahul
 
MVP

Hi,

You can provide you template for user to download and provided data in it.

1 Make your excel template and keep it in resources .

2.  Another way is - You can use system dependency entity 

Espace Entity ans Entity_attr

You can find all entity and their attributes here


Hope this will help you 

Regards

Rahul


2018-12-10 12-16-21
Goncalo Duarte Almeida
Solution

Hi @ujwwala tembbekar 

You can get that data from these entities


Entity stores the entities names and the Entity_Attr stores the Attributes by entity.

Regards

Gonçalo Almeida

2020-09-21 11-35-56
Sachin Waghmare
Solution

Hi Ujwwala,

Please find attached the OML for your request. Kindly review it and let me know, if you need any other help.

Thanks & Kind Regards,

Sachin

empaddSachin25.oml
UserImage.jpg
ujwala

Thank you all,for the suggestion.

UserImage.jpg
ujwala

Hi Team,

Wanted to know how to display the default text for user to select in dropdown "Please select option" once the dropdown populated with aggregates values.


Above is not working.

2021-06-16 06-20-58
Cezar Francisco

Hi @ujwwala tembbekar , use the "Special List" Option and Value instead. 

Value 1 = NullIdentifier()

Option 1 = "Please select Entity"


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