Change filter from an APP

Hi,

I have a FILTER Tool with This Expresion -> [tipo] NOT IN ("[X]")

"[X]" is a connection comming from a list box. I want this to filter just the selected items in the List Box... But this is not working.

Some one have an Idea how to do this?

Thanks

Apps

Accepted answers

Aguisande

Ohh, now I get it (mostly I believe I did).

This is how your FILTER TOOL should be:

Filter Tool

This is how your LISTBOX should be:

Listbox

Hope I got it right and this helps. If not, add your workflow to the post so I can take a look at it.

Aguisande

Not completely sure about exactly what's going on (maybe the options in the .csv), but here is a workaround:

Your workflow should look like this:

Workflow

So, you have to:

- Add a Formula Tool before your Filter Tool with this config:

Formula Tool

Change the Filter like this:

Filter

Now, edit your Listbox to get back those double quotes:

Listbox

And finally, edit the Action Tool like this:

Action Tool

Run the module, now it should select the multiple options.

All comments

Aguisande

Hi MC ,

You should try the Dynamic Input tool.

The basic workflow take data from "somewhere" (in your case "[X]") and modifies the query WHERE clause with the fields.

dynamicSQL

Define your template as the repository where you have the data to be selected, and then choos SQL: Update WHERE Clause:

dynamic input

Hope this heps.

macabrera

ok... The problem is I am building an APP, and I have to filter the file with the information that the user Select in the APP.

Like this

1. Select from a List Box

2. The Expression in the FILTER tool must be modified

3. I should work only with the data of the Users selected items in the List Box

Work Image.jpg

Aguisande

Ohh, now I get it (mostly I believe I did).

This is how your FILTER TOOL should be:

Filter Tool

This is how your LISTBOX should be:

Listbox

Hope I got it right and this helps. If not, add your workflow to the post so I can take a look at it.

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157