My values are not passed into filter data table

Help Studio
, ,
1

My values are not passed into filter data table

image

Please anyone

thanks
shaik

2

What makes you think the values aren’t passed in? They are. If you aren’t getting the results you want, then you have your filter set incorrectly. Are you taking into account case (ie upper case vs lower case)? Have you put a breakpoint on the Filter activity and Debugged to check the value of those variables?

3

I have printed variables … got output

But those varaibles pass into filter datatable not taken it

can you give solution

4

The variables are being passed in. Are you saying that the result is not what you’re expecting? It’s not finding the records you want? Then you have the filter set up wrong. Show us your source data, and post a screenshot of the variable values during Debug.

5

I got only headers but not get any values

image
image1794×891 31.8 KB

6

What’s in the original data? Your filter must not be correct, the values don’t match.

7

@shaik.muktharvalli1,

You are using And filter to all the columns which is like your output would be the data which are strictly matching with all filters you applied here.

As you are expecting some output data it means this filter activity not configured correctly.

If any of the filter criteria you want optional or Or condition, just click on that And button and it will be changed to Or.

Try configuring this properly and you will have your data.

Thanks,
Ashok :slight_smile:

8

It’s not quite that simple. What would be the result of…

Field1 = “Value1A”
Or Field1 = “Value1B”
And Field2 = “Value2”

Since the activity does not provide us with parentheses, and the documentation doesn’t tell us how the above is handled…is it:

(Field1 = “Value1A” Or Field1 = “Value1B”) And Field2 = “Value2”

Or is it:

(Field1 = “Value1A”) Or (Field1 = Value1B" And Field2 = “Value2”)

??

In cases where you need complex and/or combinations you should use IEnumerable.Select

9

But I have to check all columns values

is there any solution

thanks
shaik

10

@shaik.muktharvalli1,

Ok you mean the condition should be And. In that case the logic you applied should work but just for a safer side try moving that replace logic out before filter activity.

So much n filter value you should have the value no operation.

Thanks,
Ashok :slightly_smiling_face: