Fra
Rookie

Use Multiple Values from a Check Box List to Filter on a List

Hello, I am currently trying to build a solution that if a user picks 1 or more values from a Check Box List, the selected values should be used to filter on a second list.

 

E.g. List 1 (Article) , List 2 (Teams for Inquriy)

 

List1

ID:Article

1:A1

2:A2

3:A3

4:A4

 

List2

ID:ArtID:Inq:User

1:1:1:U1

2:1:1:U2

3:3:1:U1

4:4:1:U2

 

So if you filter on Article 1 and 3, list 2 should be filtered and show the first 3 lines.

 

In addition it could be possible that the field ArtID in list 2 is empty. These lines should allways be visible on list 2.

Later the result should be used to start a workflow for each entry.

 

So far I did run into an error.

 

Regards

 

FW

0 Kudos
Reply
4 Replies
IsaacB
Novice

Re: Use Multiple Values from a Check Box List to Filter on a List

Hi,

 

Could you clarify on what you are having difficulty with?
You stated you ran into an error, is this what you need help with? If so, please outline or copy the error - so that myself or anyone else can suggest an idea. 

0 Kudos
Reply
Fra
Rookie

Re: Use Multiple Values from a Check Box List to Filter on a List

I get below error if I try to choose more than one article

 

"Failed to convert parameter value from a String to a Int32."

 

I did try it too with Multi-Select Control, with the same outcome.

0 Kudos
Reply
Mike_K2
Apprentice

Re: Use Multiple Values from a Check Box List to Filter on a List

fweber,

 

Perhaps try using an inline function to explicitly cast the value to an appropriate data type before passing it on?
http://help.k2.com/displaycontent.aspx?id=4958

To Integer would be the one I'd aim for.

 

Regards,

 

Mike

0 Kudos
Reply
Fra
Rookie

Re: Use Multiple Values from a Check Box List to Filter on a List

Hello,

 

thanks for the answers and thoughts so far. In the meantime I had some discussions with our internal customers to understand better what they would like to achieve and we found a solution.

 

I will now use a standard SMO method to create/copy information to new/additional table they need during the process.

 

Regards

 

FW

0 Kudos
Reply