Filter collection

[maduri0909]

Hi guys,
How to use filter collection with AND and OR??
For example..

"[Name]=' "&[Collection1.name]" ' " AND [age]=' "&[Collection1.age]" ' "
Above one is not working..
Please help me out with solution..

Thanks,
Anusha.

 

[sivagelli]

"[Name]=' "&[Collection1.name]" ' " AND [age]=' "&[Collection1.age]" ' "

While applying filter, you have to use the field names and not Collection name dot field name.
If Name and Age are the fields of collection, you can use "Name ="&[DataItem1]&"AND Age="&[DataItem2]&". If you have the values to compare Name and Age in data items DataItem1 and DataItem2 respectively.

Hope this helps!

 

[maduri0909]

While applying filter, you have to use the field names and not Collection name dot field name.
If Name and Age are the fields of collection, you can use "Name ="&[DataItem1]&"AND Age="&[DataItem2]&". If you have the values to compare Name and Age in data items DataItem1 and DataItem2 respectively.

Hope this helps!

Hi

Thankyou for responding..
Its not working..

 

[sivagelli]

If the DataItem1 is text type add single quotes, I missed that point. Like below-
"Name ='"&[DataItem1]&"' AND Age="&[DataItem2]&"

 

[maduri0909]

If the DataItem1 is text type add single quotes, I missed that point. Like below-
"Name ='"&[DataItem1]&"' AND Age="&[DataItem2]&"

Thank you so much for responding..
I need to Check this..

 

[salmani]

Trim(Upper(["Text"]))=Trim(Upper("Text")) OR Trim(Upper(["Text"]))=Trim(Upper("Text"))
try with this