I have created a local variable with a function that produces a value indicating a price list that I want to use.
I want to only show records in pc_mstr where the pc_list = local-var00.
I added the following function:
function valid-pc return character(input curr-pc as character,input last-pc as character):
if curr-pc <> last-pc then return Error.
And then to the pc_list field I added the following Expression:
This does not work. I don't know what I am not doing correctly.
I though maybe a "on find of pc_mstr do:" , but I have not tried it yet.
I know that I can do this from the filter, post process.
I want to hand this off to a user that may not be as knowledgeable about the use of filters.
I will, if I must, but I wanted to see if there are other options.