Collection Filter Problem

[matuopm]

I have a problem with the collection filter function in the collection manipulation object.

What it should do:

The page gets a text input named Inputkey in the start stage.

The collection has a table with 2 columns Inputkey(Text) and IBMkey(Text)

In my example the collection should be filtered according to the Inputkey(Text).

It should create a collection named Collection Out where only one row remains

Inputkey(Text) // IBMkey(Text)
F5 // [pf5]

The calculation stage should get the value from the Collection Out.IBMkey

And the Code Stage uses the Collection Out.IBMkey as an input.

I get an error because of my Syntax in the filter(Text) of the filter collection action but I can't find a solution that is working.

Can anyone help ?

 

[shikhar.mishra]

Hi @matuopm

Please alter the condition of the Filter you cannot put the collectionname.columnname syntax should be columnname only . I have taken your example and created it
View attachment 1571238232892.png

 

[matuopm]

Thank you for your reply. I will test that later.
Can you explain the Syntax a little ?
I don't understand the "like" and the "%" in it.

Thanks in advance !

 

[shikhar.mishra]

Hi @matuopm,

Its simple syntax when we use the like with SQL Query . Please see https://www.w3schools.com/sql/sql_like.asp

 

[Jiri.Hurda]

Obviously not your case, but I got stuck with other problem which took me a while to solve.

Column name which you want to filter must NOT have any spaces or any special characters. So you need play with column headers first.

 

[gil.silva]

Obviously not your case, but I got stuck with other problem which took me a while to solve.

Column name which you want to filter must NOT have any spaces or any special characters. So you need play with column headers first.

It's not completely true, you can have a column header with spaces, but then your column name in the filter expression must be between suqare brackets, e.g. "[column name] like 'John' "