Solved

Newbie question

Hello all!

I want to display an external SQL Server table column as a list in my combobox. What is the certain type of data I should define on my replicated entity, in which data type of my own Entity I should relate it to? And how in the form constructor I must use the data ? As a combo box using that as my display attribute? Thanks in advance!

I ahve attached what I have done so far.

Comments (5)

photo
1

Dear Andre,

Regarding your question, it is possible when you replicate an entity and then add a combo to the form.

Regards

photo
1

Hello Juan, kindly check my attachments I have created the entity like this:

In data model I click on Entity Replicated Entry, through the wizard I select the table of my DB I want and it creates a green table with my DB table name:

Way I tried and not successful:

Creating a relationship on relationship button.

When I created the combobox and set the data source as my replicated entity column, when I ran the form the combobox list was simply empty!

Assigning a variable X of type of my replicated entity also didnt work

photo
1

Dear Andre,

You need to make sure that the values have already been imported to Bizagi. Please check the following article to know how to do it: http://help.bizagi.com/bpmsuite/en/index.html?studio_verifyreplication.htm

After this, restart your IIS to update the work portal.

replicate07_replicatenow

howtointegratebizagiwithanexternaldatasource_image008

We look forward to hearing from you

photo
1

Juan,

Thanks again for your support and all your help I still have no success, now I will attach "all" steps Ive done in accordance with your recommendation, please kindly take a look and tell me what I am doing wrong?ba61f3b2c5487849eb525a1e4df43c41e1291b96c71cb9293c50c6cfc4b7572f7589270e6d5468fe0a3fbb12fdd41ea4152efbb598c4de4725ea2f45f5c262af

photo
1

Dear Andre,

Thank you for your feedback. Analysing your screenshots, we recommend to upgrade your current version to solve this problem. Please download our latest 10.7 version from: https://bizagi.sharefile.com/d-sb34feb98a1b45838 and install it according the following article at: http://help.bizagi.com/bpmsuite/en/index.html?upgrade_bizagi.htm

Regards