Log in to AnswerLog in to Follow
2022-04-01 00-39-28
Phi Tran Q
17Views
6Comments
Solved
Identifier data type for  External Database
Question
Reactive
External Database
Application Type
Reactive

Hi all,

I used a MySQL database as external database for my app. 

It has two table, Province and Village.  Province has id as identifier, and additional information such as Name, Location... 

Because one Province can have many villages, so I want to have an one-to-many relationship between them by Province.Id and Village.ProvinceId.

I know that I can't do that with external database in my diagram. So I created a aggreate and made a join beetwen two sources for the add/edit villages screen manually.

Because I want to users choose Province.Name (not Province.id by typing in one input box) to assign Province.Id to Village.ProvinceId, and I made the dropbox. So the list is Provinces.List, the Option Text is Province.Name, the Option Value is Province.Id, etc...

But I don't know how to overcome the problem. That is Outstytems required the variable (here is Village.ProvinceId) is a Province Identifier. 

But I can't change the data type  of Village.ProvinceId into Province Identifier like with "internal" entities. 

So what I should do in this situation? 

Thanks for your help.


0
0
11 Apr
2020-01-24 05-26-13
Vikas Sharma
Solution

Simply while you are saving value ProvinceId  in village table. Just use IntegerToIdentifier() method.

Lets say ProvinceId is 5. Right now this 5 is integer. But before making entry into the Village table. pass value like IntegerToIdentifier(5) instead of only 5.


See solution in context
1
0
11 Apr

Yes. My problem is presenting options text extracted from a list (including some fields) which make sense to users in a form. Thanks.

0
0
11 Apr
2022-04-01 00-39-28
Phi Tran Q
Solution

I found. In Intergration Studio I can change the data type to any Entity Identifier. Thanks to Outsystems Team. 

See solution in context
0
0
11 Apr

If change of datatype is not possible in MySQL for you then, can use integer or LongInteger and use methods IntegerToIdentifier() according to your need.

1
0
11 Apr

Thank you. But I am confused a litte bit with "change of databse is not possible in MySql" (?).

 And how can use the method you mentioned.

Thanks again.

0
0
11 Apr
2020-01-24 05-26-13
Vikas Sharma
Solution

Simply while you are saving value ProvinceId  in village table. Just use IntegerToIdentifier() method.

Lets say ProvinceId is 5. Right now this 5 is integer. But before making entry into the Village table. pass value like IntegerToIdentifier(5) instead of only 5.


1
0
11 Apr

Yes. My problem is presenting options text extracted from a list (including some fields) which make sense to users in a form. Thanks.

0
0
11 Apr
2022-04-01 00-39-28
Phi Tran Q
Solution

I found. In Intergration Studio I can change the data type to any Entity Identifier. Thanks to Outsystems Team. 

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