Image Attribute from External View

Jhstephenson

I have a view that was created from several BO's joined together. One of the attributes is an image.

When the view was imported into the BO the image generated two attributes:

Image_DOCDATA type: Binary Data
Image_DOCTYPE type: Plain Text

The images in this particular case come from user selected Icons, mostly .ico files.

I want to display those images as the first column in a query. But when I select the Image_DOCDATA attribute nothing shows up.
Image_DOCTYPE just shows the name of the icon file that was selected by the user.

How do I get that attribute to be treated as an image?

If I do a query from the original BO, I just drop the image attribute onto the Grid, adjust the size to what I want and it displays.

aware_support

Not sure I understand how you got these attributes in the first place - are you using "external persistence" on a table created by Aware IM itself?

Jhstephenson

I did the following:

Created a view from several tables created by Aware IM. One of the tables has a picture attribute Stored In the database. The actual table definition shows two attributes: 1)Picture_DOCDATA - Datatype Image 2)Picture_DOCTYPE - Datatype varchar(200).
Created a new BO with Database: existing external - Database: Customer, Table or view: viewCustomer
Discovered Attributes. The two picture attributes are: 1)Picture_DOCDATA - Datatype Binary Data, 2)Picture_DOCTYPE - Datatype Plain Text
Assigned Primary Key

I create a query that has both of those attributes on it. The DOCDATA column doesn't show anything, even though I can look at the view in SQL Manager and see that there is data in it.

aware_support

This won't work. Aware IM stores a picture in a special way - you can't discover it.

Jhstephenson

So, how do you show an image then that is contained in a view?

If the answer is to create a shortcut, that defeats the actual purpose of having the view to begin with, which is to speed up the display of records in a table that link to other tables.

aware_support

You cannot show a picture from the data discovered from an Aware IM picture attribute.