case_number (Case module) field is not working on Process Email Template

Hi there !

I'm facing a strange issue. The field case_number is not processed in my email template when I'm sending a notification through a workflow. Customer is complaining about this issue but the version of Sugar hasn't changed since June 2018 (still in Sugar ENT 7.9.3.0, migration to V10 will begin in the next few days).

Is it a known issue, did you ever faced this problem ?

Could it be linked to this problem : 

https://portal.sugarondemand.com/#supp_Bugs/5570a182-41da-29f9-2c31-5331230237ec

My workflows are triggering on new records only ... like in the bug :/

Any clue to fix that ?

Best regards,

Enes

Parents
  • I havnt had to deal with this in years but here is how I remember this issue

    The problem is that the case number is not set until the record is added to the database.  The database itself sets the case number as an auto-increment. 

    So when the new record gets sent to your workflow the case number has not been set yet.

    The "fix" for this is to use a time based workflow because a minute later the case_number will be set. 

Reply
  • I havnt had to deal with this in years but here is how I remember this issue

    The problem is that the case number is not set until the record is added to the database.  The database itself sets the case number as an auto-increment. 

    So when the new record gets sent to your workflow the case number has not been set yet.

    The "fix" for this is to use a time based workflow because a minute later the case_number will be set. 

Children
No Data