AnsweredAssumed Answered

What field store default signature

Question asked by Autchara Chaiprom on Mar 20, 2017
Latest reply on Mar 27, 2017 by Autchara Chaiprom

Hi,

 

In database, there is table names user_signatures

I have API to get default signature from email setting but I cannot find what field in Sugar store default signature.

 

This is my email setting, in Signatures: I selected admin signature to default.

 

My query to get default signature it not 100% correct because no condition for default signature.

SELECT signature_html FROM users_signatures
WHERE user_id = '{$id}' and deleted = 0

 

Sugar Pro 7.7.1.0

Thanks,

M

Outcomes