Tag work items

[Chakravarthy GRK]

Hi All

I want to use Tag work items functionality. I have a queue with a column Sales type (A/B/C) in my excel. I want to process only sales type 'A' items

My Query is can we add only Sales type A items to the add queue and process instead adding all the sales type and then using a tag filter to process A

 

[gil.silva]

Hello Chakravarthy,

Yes, tag items is a way to achieve what you need. But if you don't even need the item from the type B and C, you should not even add them to the queue.

You should Get Worksheet as Collection, then filter your collection, using the action Filter Collection in Collection Manipulation.
Then you add the ouput collection to your queue Without the need to filter the queue items.

 

[Chakravarthy GRK]

So I have collection1 with 2 Columns "Sales person" , "Sales type".
collection2 as output

My query is what to value should be updated in filter . would that be column name in ([Sales type]) or value of sales type ["A"]
either the way I am not getting the output in collection 2

 

[gil.silva]

Hello Chakravarthy,

Your filter in the action Filter Collection should be the following:
Expression: "[Sales type] = 'A' "

Let me know if it works for you.

 

[Chakravarthy GRK]

Hello Chakravarthy,

Your filter in the action Filter Collection should be the following:
Expression: "[Sales type] = 'A' "

Let me know if it works for you.

Amazingly it did. thank you very much

 

[arghya_bh]

Use action filter to achieve this.