Survey signature location in view

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.

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  

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

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 @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 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!