Query to pull 2 items with the same age from list

Question

question

Anggoro P asked Nov 20, '17 Raja Sekaran edited Nov 27, '17

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

Software Version:

Choose One

query

Answer 1 · 2017-11-23T06:25:34Z

Raja Sekaran answered Nov 23, '17 Raja Sekaran edited Nov 27, '17

Hi @Anggoro P

Try to change the query like this

queryfield.fsm

Thanks.

capture1.png (10.2 KiB)

queryfield.fsm (19.8 KiB)

· 11

Anggoro P commented · Nov 23, 2017 at 07:10 AM

@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 ·

Raja Sekaran Anggoro P commented · Nov 23, 2017 at 07:22 AM

@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 ·

9647-queryfield-1.fsm (20.3 KiB)

Anggoro P Raja Sekaran commented · Nov 23, 2017 at 08:04 AM

@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 ·

Show more comments

question