This topic contains 2 replies, has 0 voices, and was last updated by johnsongilpp 7 years, 6 months ago.

  • Author
    Posts
  • #4899 Score: 0

    johnsongilpp
    • Contributions: 0
    • Level 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.

  • #4900 Score: 0

    T.Watz
    • Contributions: 0
    • Level 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

  • #4901 Score: 0

    johnsongilpp
    • Contributions: 0
    • Level 1

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

You must be logged in to reply to this topic.