question

Adrian Alvarez Sampedro avatar image
0 Likes"
Adrian Alvarez Sampedro asked Adrian Alvarez Sampedro commented

Query Strategy problems

What i need to yse to pull a token with the same label and has been in the list more time. For example in this list i want to pull the token id 140, but i dont know how.

1712230188980.png


FlexSim 24.1.0
query strategy
1712230188980.png (9.2 KiB)
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

Nil Ns avatar image
0 Likes"
Nil Ns answered Adrian Alvarez Sampedro commented

Hey Adrian,

I understand that the token you want to pull contains information about the ‘modelo,’ right?


You can achieve this using an SQL query: Working With Lists (flexsim.com)

First, filter only the items with the correct ‘modelo.’

WHERE modelo = puller.modelo_objetivo

1712244505142.pngIn my case, where ‘puller’ represents the token, ‘puller.modelo_objetivo’ should match ‘token.modelo_objetivo’ .


Next, order the results by age in descending order

WHERE modelo = puller.modelo ORDER BY age DESC

1712244505142.png (4.4 KiB)
· 1
5 |100000

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

Adrian Alvarez Sampedro avatar image Adrian Alvarez Sampedro commented ·

Ty for asnwer, this what i needed it

0 Likes 0 ·