Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » Start Loop through Table Where Field Ends With not working

Start Loop through Table Where Field Ends With not working

Last post 02-09-2016 12:18 PM by Method_Inderdeep. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 02-06-2016 1:25 PM

    Start Loop through Table Where Field Ends With not working

    Reply Contact

    I have an action "Start Loop through Table" with two where conditions.  One of the conditions is an "Ends With" condition.  It is failing. When I enable debug tracing I see the generated SQL is putting an extra space before the ending single quote. So the code becomes

    (ActivityTypeTag LIKE '%Federal ')

    notice that extra space...  I verified I do not have an extra space in my TypeIn field where Federal is specified.

    I believe this is likely a bug in the method code and request it be reviewed. 

    Pamela Keffer

  • 02-09-2016 12:18 PM In reply to

    Re: Start Loop through Table Where Field Ends With not working

    Reply Contact

    Hello kefpa01,

    Thanks for reporting it. i was able to reproduce it on my account. I will bring this up with our development team. In the mean time, you can use Build Selection list in order to use it more affectively. You can even use multiple loop with that.

    -Inder
Page 1 of 1 (2 items)