Hi @lopespetro,

We use Picture data column to store both pictures and signatures   

View Signature - I can see same problem in our Internal env. Let me check this and get back to you.

Thanks.

Hi @lopespetro,

We use Picture data column to store both pictures and signatures   

 

View Signature - I can see same problem in our Internal env. Let me check this and get back to you.

Thanks.

Hi @Bandula , tks for the confirmation. I though about that too.

But It’s not showing in plsql. How can see it?

neither in crystal reports

The picture is possible to see in browser.

For your 2nd question in original post, We have a bug on Show Signature command. We are checking that. But signature visible in a column in list view  

Signature is not adding to media library. Hence it is not visible in attachment panel - Media tab

Hi @Bandula, tks for the info.

Do you know about seeing the picture and signature in plsql and crystal reports?

I can’t see them.

Do you know how?

This is how I see as inserting in crystal

Tks a lot

I'm not sure on this. May be you can post the question separately to get help from crystal expert.

OK @Bandula , go to open another topic.

It’s strange because it’s possible to see the signature in JT_TASK_SIGNATURE view.

The field type is BLOB.

In picture data is CLOB.

I’m gonna leave this topic open till Rnd check the signature view option

Tks a lot

Hi Everyone,

The app is recording the signature without the text “data:image/png/base64,”, when insert this text in te beginning, the command Show Signature is ok.

Hi Everyone,

 

The app is recording the signature without the text “data:image/png/base64,”, when insert this text in te beginning, the command Show Signature is ok.

 

 

 

Hi @rafgbr , I could see that this has been fixed in Aurena browser page.

Could you tell me something about the type of the field Picure_data?

Is not there another table or view saving in Clob, to be able to print in Crystal reports?

As the same in JT_TASK_SIGNATURE

There is just Clob in survey answer.

Hi Everyone,

 

The app is recording the signature without the text “data:image/png/base64,”, when insert this text in te beginning, the command Show Signature is ok.

 

 

 

@Bandula 

Hi Everyone,

 

The app is recording the signature without the text “data:image/png/base64,”, when insert this text in te beginning, the command Show Signature is ok.

 

 

 

@Bandula

Hi all, with @rafgbr help, We solved the problem chaging the code above and also creating a function to convert Clob to Blob and getting it in a IAL view.

UTILITY_SYS.Convert_Base64_Clob_To_Blob(REPLACE(picture_data,

                                                              'data:image/png;base64,',

                                                              '')) Signature_Blob,

After that, just use the IAL view in Crystal and everything is fine.

Tks a lot for Attention of Everyone!