Update Operators with Action Tool

[fgrahner001]

Hello, 

I created this simple filter using an OR operation and I would like to be able to update the operation from OR to AND as needed when running the workflow on the server.

Currently, my Action tool is running as an Update Value, Replace specific string. But when I update the operator to AND while running the interface tools, no records come out. Is there anything I am doing wrong?

[jrgo · Accepted solution]

@fgrahner001 

You may want to make sure that the string "OR" also isn't found in the values your CONTAINS() function are configured with. The Replace operation looks for and replaces ALL instances of "OR" found.

If there are, you can try changing the operators to || for OR and && for AND.

[BenMoss]

It looks okay to me, obviously you need to check that there are records that meet your criteria.

One other detail that people often forget is to make sure you have actually highlighted the custom filter expression as the piece that you wish to edit.

Ben

[apathetichell]

Is your action tool connected to a Drop Down or a Textbox??? I just ran a Drop Down with values AND OR with my action configured to replace the OR and it worked fine.... Can you a) add a space before your OR and b) confirm that you have a browse or something set up to display after the true anchor in your interface designer? You can do what you are looking for in your app.