how can I retrieve the position of a certain row/object within a collection of other rows/objects?

right now im just using persons.indexOf(person) to find this but thats not very smart because itll load all of the person objects of persons set

If possible i'd like to get this index value using hql, hopefully thats alot faster than loading all the objects

just to make this clearer, i had converted the Set to a List, Set doesnt have am indexOf method

Session.filter();

could you give me another hint as to how I can do this?

i've already looked into the session.filter but not sure what the query would even look like

I just have that Person object loaded and want to know the position of the Person within a List of Person objects, I can already do this using using List.indexOf but that would require me to load all of those Persons and I dont want to do that because i'd be too slow

my goal is to show at the UI something like "viewing Person 345 of 432543"

and having a url like "showUser.action?personId=5672"

Person p = (Person)session.filter(persons, "select this where index(this) = ?", ...bind parameter...

this doesnt work, for one, what I want as a result is an int telling me the position ie, indexOf the Person within the persons collection, not an actual Person object

Not possible.