List Box tool to feed Filter tool

[Sarath27]

Hello All,

I have

dataset 1 which has two fields Name, Vaue

dataset 2 which has id, deal_name

dataset 1 should be connected to List box tool which should be connected to a filter tool to update the selection made in the list box and filter from data set 2. I created an Analytic App which does this,but its not filtering anything.

Can you please help me out on this? Attached the sample workflow

Data set 1

Name      Value

BRIGHT  656

CHINA    658

[DanielNavarro]

From the filter provided, you have the filter as [deal_name] IN ('@@DealName@@'); however, you have the action tool updating specific string as "@@DealName@@'. Either change the quotes in the filter or action tool to be the same and the filter should work.

[Sarath27]

Thanks for responding, I removed the quotes in the action tool, but still zero records been filtered after runn

[DanielNavarro]

You do not need to remove the quotes entirely. The quickest fix to this is the following:
In your action tool, under the specific string to replace, change "@@DealName@@' to "@@DealName@@"
Then in your filter tool, change [deal_name] IN ('@@DealName@@') to [deal_name] IN ("@@DealName@@")
I would then save and re-open as sometimes the filter tool attached to an action tool can bug out. I had to do this with a workflow I am currently working on, and after making the changes I have suggested, I had to save and reopen for the filter to work properly

What you're doing is making sure that the "@@DealName@@" matches both in the action tool and the filter tool. If they do not match, the workflow cannot match the variable to change. 

Please let me know if this works. 

[Sarath27]

I changed in the way you suggested, but still filter tool filters zero records. I know its a simple one, but I have been trying this for very long.

[jrlindem]

Looking at your workflow and reading the conversation, I see that your List Box is referencing values that come from an external source:

• C:\Users\...\Desktop\List Oct 1.xlsx

This file must be accessible from the server or it needs to be packaged with the application.  I'm guessing that it's not referenceable by your application and therefore failing to be regarded (meaning it's just filtering on the DealName tag and finding nothing that matches that).

So you'll need to ensure that External Source file is discoverable or consider hard-coding the list into your workflow or having it accessible via a database table that your gallery has access to see.

Hope that helps, -Jay

[DanielNavarro]

I have created a mock solution with the action tool and filter working properly. The only difference is that the input for the list box is a text input. Your workflow has one that is from an external list and I would refer to jrlindem for guidance on that. One way to test to make sure that the list box is pulling in the relevant information you are wanting to filter based on is by going into the test view within Interface Designer. In test view, you should see the available options to pick so that the filter can work properly. In my mock solution and within the test view, you are able to pick either BRIGHT or CHINA. If you are not able to see the data points you want to filter based off of, then more than likely the List Box tool is the culprit. 

Please let me know if you are able to get it to work.

Disclaimer  - if you use the mock solution, I did not set up the Output data correctly and I was deleting in between each test run to ensure app was filtering correctly.