Lead Status "In Progress" Code


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"? 



  • Hi Jacob

    <span id="_Datalead_status" class="VIEWBOX">
    <select class="EDIT" size="0" name="lead_status" id="lead_status">
    <option value="In Progress" selected="">In Progress</option>
    <option value="Opportunity">Opportunity</option>
    <option value="Closed">Closed</option>
    <option value="">--None--</option>
    <input type="hidden" name="_HIDDENlead_status" id="_HIDDENlead_status" value="In Progress" entrytype="21">

    The value is "In Progress" in the default system.  What code is giving you issues?

  • Hi,

    Anything that references the code as "In Progress". For instance, DefaultValue = "In Progress";

    Where can I view the file that you just pasted? I'd like to look and see if my value is the same.

  • No not in on change, but good thought.

    The instances I am thinking about are escalation rule SQL.

  • 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!!  :-)

  • 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.

  • 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. 

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

Reply Children
No Data