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

Method_Inderdeep — Tue, 09 Feb 2016 18:18:55 GMT

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

Start Loop through Table Where Field Ends With not working

kefpa01 — Sat, 06 Feb 2016 19:25:52 GMT

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.

Method:Classic General Q&A

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

Start Loop through Table Where Field Ends With not working