Lead Status "In Progress" Code

Hello,

Does anyone know the proper syntax to reference the "In Progress" value in the leads table under leads status? When referenced as "In Progress"; how it appears, it does not function properly within setting the filter defaults nor within other written code.

Perhaps it's "In_Progress"? 

Thanks,

Jacob

Parents Reply Children
  • 0 in reply to Jacob04

    Jacob04:  Where you able to resolve this?  If you are writing triggers for an escalation rule, you will need to use 'In Progress' rather than "In Progress" as you are writing SQL script in that area.  SQL needs to be wrapped in single quotes rather than double quotes for SQL triggers.  I hope this helps!!  :-)

  • 0 in reply to Michele Gaw

    No. Regardless of whether we use single quotes or double quotes it doesn't work properly. I was able to use a different route to get the desired result, but referencing 'in progress' in any way doesn't work for us.

  • 0 in reply to Jacob04

    For SQL (e.g. Execute SQL Statement on Workflows/Escalation Rules, or SQL Triggers) I've never had a problem finding/Reading or writing this data. 

    The only thing to watch out for if you're using 'Execute SQL Statement' on Workflow/Escalations (not sure if it has been addressed) is that the script you write in there MUST be written on a single line (even though within the box it'll word wrap) i.e. do not press enter to go onto the new line. 

    We have found in the past if you include a carriage return within the box then whatever is in there never works. 

  • 0 in reply to Matthew Shaw

    Now this seems like it could be the issue. I will try and put everything on one line. Thanks!