Log in to AnswerLog in to Follow
ujwwala tembbekar
26Views
7Comments
Solved
display entity column names on screen in dropdown
Question
Aggregate
Beginner
1-Click Publish
Architecture
Import/Export Data

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.


0
0
on 25th Mar
Sachin Waghmare
Champion
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

See solution in context
empaddSachin25.oml

0
0
on 25th Mar

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

See solution in context
0
0
on 25th Mar
Rahul Sahu
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


1
0
on 25th Mar

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

0
0
on 25th Mar
Sachin Waghmare
Champion
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

0
0
on 25th Mar

Thank you all,for the suggestion.

0
0
on 26th Mar

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.

0
0
on 26th Mar

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

Value 1 = NullIdentifier()

Option 1 = "Please select Entity"


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