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.


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

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

mvp_badge
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


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

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

Thank you all,for the suggestion.

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.

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.