Method Community

 

Debugger output repeating the same value in conditional statements

Last post 08-19-2016 4:02 PM by Method_Ben. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 08-18-2016 3:11 PM

    Debugger output repeating the same value in conditional statements

    I am having a hard time debugging some issues because of what appears to be a bug in the debugger output.  Every time I have a conditional statement it always repeats the first comparison value as the second value.  For example:

    Start Conditional Statement We are comparing the first value which is Probably buy from us. with the second value Probably buy from us. the criteria sign to evaluate the response was = result is :False Comparison type is :Text

    The result is correct (false) but the second value should read "Gathering Info".  I have reversed the comparison, but whatever I put into value 1 in the form is generated as both first value and second value in the debugger output.  This happens with values from screen, values from row and action results.  These are all I have tested.  

    Any help would be appreciated.

    My entire debug trace is below.  All conditional statements exhibit the issue.

    Debug Tracing
    Why am I getting this popup? You, or another user has turned on debug tracing, which gives you a list of all actions, and their values, that are run when a button is clicked or a screen is loaded. This can be turned on or off under Customize > Display > Enable Debug Tracing.
    Action Information
    Retrieve Value From Table The value of Retrieve First: from field: OpportunityStage of table: viewOpportunityStage was Gathering Info
    Start Conditional Statement We are comparing the first value which is Gathering Info with the second value Gathering Info the criteria sign to evaluate the response was <> result is :True Comparison type is :Text
    Retrieve Value From Table The value of Retrieve First: from field: StageProbabilityPercent of table: viewOpportunityStage was 5
    Start Conditional Statement We are comparing the first value which is 5 with the second value 5 the criteria sign to evaluate the response was <> result is :True Comparison type is :Text
    Retrieve Value From Table The value of Retrieve First: from field: OpportunityStageCategory of table: viewOpportunityStage was Open
    Start Conditional Statement We are comparing the first value which is Open with the second value Open the criteria sign to evaluate the response was C result is :False Comparison type is :Text
    Assign Value To Action Result Action Result resultCurrentDate was added the value 18-Aug-2016 03:02:00 PM
    Start Loop Through Grid Query for Loop:SELECT ROW_NUMBER() OVER (ORDER BY VIEWOPTISTAGEDURATION.[STAGEORDER] ASC) as [ROW_NUMBER], [viewOptiStageDuration].[RecordID], [viewOptiStageDuration].[TenantID], [viewOptiStageDuration].[StageStart], [viewOptiStageDuration].[StageEnd], [viewOptiStageDuration].[StageDuration], [viewOptiStageDuration].[OpportunityID], [viewOptiStageDuration].[OpportunityID_RecordID], [viewOptiStageDuration].[Description], [viewOptiStageDuration].[OpportunityStageID], [viewOptiStageDuration].[OpportunityStageID_RecordID], [viewOptiStageDuration].[OpportunityStage], [viewOptiStageDuration].[StageOrder] FROM viewOptiStageDuration WITH (nolock) INNER JOIN OptiStageDuration ON viewOptiStageDuration.RecordID = OptiStageDuration.RecordID WHERE (OptiStageDuration.OpportunityIDRef = 16) AND (VIEWOPTISTAGEDURATION.TENANTID=@TENANTID OR VIEWOPTISTAGEDURATION.TENANTID IS NULL)
    Number of records returned:3
    Start Conditional Statement We are comparing the first value which is Probably buy software. with the second value Probably buy software. the criteria sign to evaluate the response was = result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is Gathering Info with the second value Gathering Info the criteria sign to evaluate the response was <> result is :True Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is 8/18/2016 8:01:53 PM with the second value 8/18/2016 8:01:53 PM the criteria sign to evaluate the response was = result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is 1 with the second value 1 the criteria sign to evaluate the response was < result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is Probably buy from us. with the second value Probably buy from us. the criteria sign to evaluate the response was = result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is Gathering Info with the second value Gathering Info the criteria sign to evaluate the response was <> result is :True Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is with the second value the criteria sign to evaluate the response was = result is :True Comparison type is :Text
    Update Field In Table Value From Session for instertion was found to be :18-Aug-2016 08:02:19 PM Query to make update:SELECT RecordID, [StageEnd] FROM [OptiStageDuration] WHERE [RecordID] = '41'spdColumnType was DateTime spdColumnSize was 0 strInsertionValues was 18-Aug-2016 08:02:19 PM
    Date Difference Differrence between 8/18/2016 8:02:00 PM and 8/18/2016 3:02:00 PM was 0 , minus days added because of exlusion of day of week was:0 days found to be exldued are:
    Update Field In Table Query to make update:SELECT RecordID, [StageDuration] FROM [OptiStageDuration] WHERE [RecordID] = '41'spdColumnType was Integer spdColumnSize was 0 strInsertionValues was 0
    Start Conditional Statement We are comparing the first value which is 1 with the second value 1 the criteria sign to evaluate the response was < result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is Verbal approval. Awaiting PO. with the second value Verbal approval. Awaiting PO. the criteria sign to evaluate the response was = result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is Gathering Info with the second value Gathering Info the criteria sign to evaluate the response was <> result is :True Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is 8/18/2016 8:02:05 PM with the second value 8/18/2016 8:02:05 PM the criteria sign to evaluate the response was = result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is 1 with the second value 1 the criteria sign to evaluate the response was < result is :False Comparison type is :Text
    Start Conditional Statement We are comparing the first value which is with the second value the criteria sign to evaluate the response was <> result is :True Comparison type is :Text
    Insert Records Into Table Insert Fields: [OpportunityIDRef], [OpportunityStageIDRef], [StageStart],[TenantID],intMarkedForDeletion Insert Records: '16', '11',18-Aug-2016 08:02:00 PM, '1', 0
    Close
    [Resize]

  • 08-19-2016 2:59 PM In reply to

    Re: Debugger output repeating the same value in conditional statements

    Hi Tlundy,

    The Method:Classic Debug mode is a very old feature, and one of the first things we implemented - we havent looked at this is some time. Please understand that the Development Resources we would need to divert away from existing projects to look into fixing this would be considerable - and would likely need to be rebuilt from the ground up. 

    Did you need any assistance debugging some screens? Perhaps we can come up with another workaround together?

    Thanks Tlundy

    -Ben

    Ben Hargreaves
    Senior Support Specialist
    Method:CRM
    b.hargreaves@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 08-19-2016 3:17 PM In reply to

    Re: Debugger output repeating the same value in conditional statements

    Thanks for the response.

    No, I can work around this issue just be switching out the order of the variables and running it twice.  

    I would like to know if there is a better action list editor in the new UI.  I haven't switched yet and I am spending way too much time hitting the up arrow 30+ times to add actions into the middle of a list.  Does the new UI have insert in place or drag and drop or anything that makes this process faster?

    Thanks again,

    Tate

  • 08-19-2016 4:02 PM In reply to

    Re: Debugger output repeating the same value in conditional statements

    Hey Tate,

    Glad you asked!

    The Method:New action Editor was definitely designed with the User Experience in mind - It has both a Drag and Drop interface, and the ability to 'Insert in Place'. We are also actively making improvments to the Action Editor based on Feedback from Users. 

    Side Note for Classic - Did you know you can edit the Action Sequence under 'Order' for an action set? 

    Double Click on the number under the Order column, and you can enter where in the sequence you would like that action to appear - Saves you having to endlessly click the Up/Down arrows!


    If you would like to take a look at Method:New - send me an email to success@method.me and Ill be happy to give you access to Both versions.


    Thanks Tate.


    Regards,

    Ben


    Ben Hargreaves
    Senior Support Specialist
    Method:CRM
    b.hargreaves@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
Page 1 of 1 (4 items)