NAB Filter Program

[mwmayer]

Sample program EXNABFLT shows "opr" possible values as = <= > >= <> between

Does this mean if you have a filter operation that is "contains" you can't manipulate it with SetValue? If so, would I have to build the entire filter and not use WriteAllFilters() and return the filter string in vvOut_toJSONpair

Thanks

[sean.lanktree]

SetValue will allow you for anything that you pass it. So if you wanted to change a particular field to behave like "contains", the following should work:

lMyFieldValue = GetValue('MY_FIELD':'value');
SetValue('MY_FIELD':'opr':'like');
SetValue('MY_FIELD':'value': '%' + %trim(lMyFieldValue) + '%');

[mwmayer]

Great! Thanks for the "Advanced Technique" ..lol