question

Craig DIckson avatar image
1 Like"
Craig DIckson asked Jason Lightfoot commented

Pull a specific token from a list?

I have a list in my Process Flow, and I want to release a specific token from it. I have a label on the puller token that has that token to pull's id. How do I set up the query in the "pull..." activity? Is it just-

Label: labelTokenToPull ? (I tried this but it's not clear if it's working as I expected.)

Or do I need to use a

"WHERE <something> = puller.labelTokenToPull"

If the latter, how do I reference it i.e. what relpaces <something>?

Thanks,

Craig

Choose One
process flowlabelsquerypull from listwhere
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Matt Long avatar image
2 Likes"
Matt Long answered Jason Lightfoot commented

The WHERE statement is what you need, just as you've written it. If the token on the list has a label called myID, then you would replace <something> with myID.

WHERE myID = puller.labelTokenToPull

The query will look at the List for any fields with the name myID. If none are found then it will look for a myID label on the pushed value (in this case tokens).

· 6
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Craig DIckson avatar image Craig DIckson commented ·

OK, I see how that would work. So, IIUC the trick is to label the token on the list with its own ID so I can reference that label in the Pull... activity; I can't just reference the token directly from the puller token.

Thanks,

Craig

0 Likes 0 ·
Matt Long avatar image Matt Long Craig DIckson commented ·

If you had a label on the the puller that points to the token you want to pull, then you can say:

WHERE value = puller.tokenToPull
0 Likes 0 ·
Craig DIckson avatar image Craig DIckson Matt Long commented ·

Matt,

That did it. Thanks

0 Likes 0 ·
Show more comments
Regan Blackett avatar image Regan Blackett ♦ Craig DIckson commented ·

If I'm reading you right, if you are just looking for a token with a given ID number (the ID number that the software assigns automatically, not some custom number created by you) you could do a WHERE query like this:

WHERE gettokenid(value) = puller.IDYouAreLookingFor

It's the same as what Matt is describing, but just skips either setting up a Label on the tokens that get pushed to the list, or a custom Field on the list itself

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.