[johnsongilpp Contributions: 0Level 1☆]

Hi,

has anyone ran into the use case where they need to use a parameter between a like or another search statement? I have tried multiple variations but can't get nay working.I have tried the below.

like '%' || {fieldvalue} || '%'

like '%' + @{fieldvalue} + '%'

like '% + @{fieldvalue} + %'

case when NS_CONCAT({binnumber}) like '%CUT2%' then 1 else 0 end

Thanks
This is a cached copy. Click here to see the original post.

[T.Watz Contributions: 0Level 1☆]

case when {salesteammember} like '%' || {custbody_testfield} ||'%' then 1 else 0 end works for me.

I might be wrong about this, but I think the real issue comes when you mix it with the NS_CONCAT() which is a formula that you need to set to MAX to use.

---

johnsongilpp replied on 05/05/2017, 06:06 AM: Thanks, the final solution is below. I needed to wrap the dynamic field in a MAX formula.

case when NS_CONCAT({binnumber}) like ‘%’ || MAX({custitem_prodtype.custrecord_receiving_bin}) ||’%’ then 1 else 0 end

[johnsongilpp Contributions: 0Level 1☆]

It's a summary formula on MAX. When it runs it just throws an unexpected error.

[Author]

Posts