Can a UX Component be based on an SQL Statement?

[cpgood]

I would like to place a Control Type of Type Image on a UX component. The image is from a URL that is built from two fields in my table and also a variable. The variable holds the storage location on a cloud server. The two fields in my table hold the file name of the image and the file extension:

Variable = http://099c539febdc0e564774-bde05fef...2.rackcdn.com/
File Name = 551f701e-f9c7-11e4-9540-bc764e100d45
File Extension = jpg

When you put them all together http://099c539febdc0e564774-bde05fef...764e100d45.jpg

How do I bind my Image Control Type to a calculated field? My thought was that I could base the UX component on an SQL statement and in that statement have a calculated field that formed the image URL from the three components. But the only options I can see for data binding involve selecting tables and forming simple joins.

Furthermore, unlike Controls of different types the Image type does not have a calculated value option.

Please help if you have some knowledge to share.
Thank you,
CPGood

[Davidk]

Re: Can a UX Component be based on an SQL Statement?

I thought I recognized that image. You probably should have continued this thread... http://www.alphasoftware.com/alphafo...t=bc764e100d45

Have to say, as well, that the title of this post doesn't really represent the question. Generally, what you want to do is, in your SQL Statement, concat the image detail fields together as one named field. Your fully qualified image URL will now be seen as 1 field in your UX. You don't say where your data table is... MySQL? same as the last post? If so, do a web search for MySQL concatenate 2 fields and you'll find out how to do this.

Do you have another new post asking essentially the same question, but for a grid?

[cpgood]

Re: Can a UX Component be based on an SQL Statement?

Hi David,

Thank you for your reply. Yes it ia a MySQL database and I understand how to write an SQL statement that concatenates the values together and I'm doing that for grid.

1. But, I do not see how to base a UX component on an SQL statement.
2. I do not understand what a "named" field is.

Sorry for dragging this out. I'm am now able to return to working on this problem.

Thank you for your help,
CPGood

[Davidk]

Re: Can a UX Component be based on an SQL Statement?

You can create a data-bound UX component based on a table (or tables) or a view. Create a view for your SQL Statement.

Create a new UX, add a field... a textbox... and in the New Control dialog that pops up, select the link "Populate list from a table" and walk through the process. In recent versions of Alpha, control buttons and server-side actions will be created for you. Check the server-side onDialogInitialize event for the server-side action which populates your UX with data. You can add a server-side filter here. If it wasn't created for you, you can add it using the Action Scription button that is displayed when you get into the Server-side events.

[Davidk]

Re: Can a UX Component be based on an SQL Statement?

I think I understand what you'd like to do now. You have 3 fields coming into your UX which make up the full URL of your image.

Add a non-data bound image control to your UX... let's say it's IMAGE_1. In the client-side onRenderComplete event you can do this...

var imageURL = {dialog.Object}.getValue('text1');
var imageName = {dialog.Object}.getValue('text2');
var imageType = {dialog.Object}.getValue('text3');
var imageSrc = imageURL + imageName + imageType;
var image = {dialog.Object}.getPointer('IMAGE_1');
image.src = imageSrc;

This will assign the full image URL to your image control src.