New Topic

Community Topic Problem Report Builder

David Registro

APAC SD Team

Assigned

Nathan Schroeder

NA Business Team

Category Report Builder

Product Version 7.3

How to show Blob data in Custom JS Chart?

Pratap Singh shared this problem ago

Completed

Hi ,

We need to show logo in our custom JS chart , for that we have a binary field in Database but when trying to render Binary data to image it is appending binary data field as follows in both cases (fomatted and raw data) :

data.logo[0].row_data

<.img style="width: 100%;" src=undefined" alt="logo">

data.logo[0].formatted_data

<.img style="width: 100%;" src=<Binary Data>" alt="logo">

How to fix this?

Regards

Pratap

The same problem 0

Replies (1)

Nathan Schroeder ●

Thanks Pratap,

I have replicated this and raised a defect to address this:

#10289

In the meantime, your best bet would probably be to create a free-hand SQL calc field to cast this to a text data type.

Let me know if you have any question on this.

Regards,

Nathan

Reply URL

Pratap Singh ●

Hi Nathan,

Thanks for the revert,

We have tried the solution suggested by you but it doesn't work, as text field not able to fetch full Blob field length.

Regards

Pratap

URL

Nathan Schroeder ●

Hi Pratap,

Another work around here is to store these images in the Yellowfin ROOT directory and then access them by path in the JS chart:

Will this work?

Nathan

URL

Pratap Singh ●

Hi Nathan,

Thanks for the suggestion we are currently using this workaround but in some specific cases we need to pick from Blob field only.

regards

Pratap

URL

Nathan Schroeder ●

Hi Pratap,

Unfortunately I cannot think of anything else that might work here other than writing your own query in JS... Once the devs get a chance to look at this they may have a better work around.

Sorry for the troubles.

Nathan

URL

Pratap Singh ●

Hi Nathan,

Thnks for the update,

hope defect will be resolved soon.

Regards

Pratap

URL

Nathan Schroeder ●

Hi Pratap,I will keep you up to date on any progress.

URL