Can I get the position of something in a list...

[Grant_Stead]

Can I get the position of something in a list? for example if I do an orderby and get a list of results, Can I then say so _THIS key is 5th?

[Grant_Stead]

@Aleksi_Alkio probably can roll this off of his tongue…

[Bellave_Jayaram]

It would be possible with a INDEXOF() function but it doesn’t exist.

[Grant_Stead]

@Bellave_Jayaram hrm… i’m thinking maybe some sort of find, len, etc…

[pravse]

We don’t have this functionality. While we have “List” types, there are no operations to sort them. In fact, their order is not guaranteed (they are really more Sets than Lists) so anything involving position would be a hack at best at the moment.

[Aleksi_Alkio]

How about something like… TOP(ORDERBY(SELECT(…),[Datetime],5) - TOP(ORDERBY(SELECT(…),[Datetime],4)?

[Grant_Stead]

I’ll need to play with that concept a bit…

[pravse]

OrderBy only works with a list of keys/refs. So it is going to be challenging (not to mention, wildly inefficient!)