question

Anggoro P avatar image
0 Likes"
Anggoro P asked Raja Sekaran edited

Query to pull 2 items with the same age from list

Hi, I want to pull 2 items from a list. The general query is that its age should be more than a specified days (let's say 5 days). But how to make sure than those 2 pulled items have the exact same age? because I think if I only write mentioned query, it could be possible to pull 2 items with different ages, e.g 6 days and 7 days.

@Mischa Spelt @steven.hamoen @Raja Sekaran

Choose One
query
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

Raja Sekaran avatar image
0 Likes"
Raja Sekaran answered Raja Sekaran edited

Hi @Anggoro P

Try to change the query like this

queryfield.fsm

Thanks.


capture1.png (10.2 KiB)
queryfield.fsm (19.8 KiB)
· 11
5 |100000

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

Anggoro P avatar image Anggoro P commented ·

@Raja Sekaran

The problem is that the token can pull 2 items with age >= 5. So it is possible to pull 2 items with age = 6, 7, etc as long as the token pulls the same age items

If I use your query, they will only pick the exact product with age = 5

any idea?

0 Likes 0 ·
Raja Sekaran avatar image Raja Sekaran Anggoro P commented ·

@Anggoro P

Here is the sample model 9647-queryfield-1.fsm . i have used two pull from list activity for different queries. i hope this what you had intented to do

0 Likes 0 ·
Anggoro P avatar image Anggoro P Raja Sekaran commented ·

@Raja Sekaran

Thanks for your help. From your query, what I understand is:

1. Try to pull 2 items with age = 5, if not possible to pull directly two items, move to next pull activity

2. Try to pull 1 item with age more than 5

Actually what I intended to do is to pull 2 items which have the same age, in range of age >= 5. So it could be possible to have: age(1) = 7, age(2) = 7 ; age(1) = 16, age(2) = 16

They should be more or equal to 5 days old and have the same exact age

0 Likes 0 ·
Show more comments