How to search Multiple Items using Item Name

The following Formulas can be used for this search. The user should use the formula numeric as it is compatible only with it. It should be used in the criteria to get the result.

• CASE WHEN {internalid} IN (1111, 2222, 3333) THEN 1 ELSE 0 END
• CASE WHEN {internalid} = any(1111, 2222, 3333) THEN 1 ELSE 0 END
• CASE {internalid}

    WHEN 2978 THEN 1
    WHEN 3105 THEN 1
    WHEN 3086 THEN 1
    WHEN 3099 THEN 1
    WHEN 3113 THEN 1
    WHEN 3114 THEN 1
    WHEN 3102 THEN 1
    WHEN 3103 THEN 1
    WHEN 3109 THEN 1
    WHEN 3116 THEN 1
    WHEN 3118 THEN 1
    WHEN 3120 THEN 1
    WHEN 3123 THEN 1
    WHEN 3124 THEN 1
    WHEN 3126 THEN 1
    WHEN 3127 THEN 1
    WHEN 3128 THEN 1
    WHEN 3129 THEN 1
    WHEN 3130 THEN 1
    WHEN 3131 THEN 1
    WHEN 3132 THEN 1
    WHEN 3133 THEN 1
    WHEN 3135 THEN 1
    WHEN 3136 THEN 1
    WHEN 3137 THEN 1
    WHEN 3138 THEN 1
    WHEN 3139 THEN 1
    ELSE 0
END

• INSTR(‘$123$124$127$129$134$’,’$’||{internalid}||’$’) is greater than 0
  If you use INSTR and search for the record ID within a list of the IDs you want, you can get more IDs within the character limit. All you need is a list of the ID values, split by a delimiter into both sides so that you don’t pick up partial IDs (so that looking for 9 doesn’t get a hit on 99 for example). Eg. INSTR(‘$123$124$127$129$134$’,’$’||{internalid}||’$’) is greater than 0