.whereIdIn() ?

[bpuig]

Hello, I'm migrating from vuex-orm and I'm stuck because whereIdIn seems to be missing .

As an alternative I've tried whereIn, but has issues.

// This does not work "Unresolved function or method whereIn() "
return teamUsersRepo
    .whereIn('id', userIds)
    .with('role')
    .get()

// This works, but does not respect order of the array in userIds
return teamUsersRepo
    .with('role')
    .whereIn('id', userIds)
    .get()

In vuex-orm whereIdIn worked, and also it kept the order given in the array on the results.

Will this function exist in the package?

[CodeDredd]

Try using

return teamUsersRepo
    .query()
    .whereIn('id', userIds)
    .with('role')
    .get()

[bpuig]

Yesssssssss! 🥳

[bpuig]

I thought It worked, but now I see it does keep the order provided, 1st object are the id used in whereIn, 2nd object is the result of the pinia-orm query, the first order is the one provided by my API server:

Changed the order of the ids , but pinia stays the same.

Any idea where I should look?

I did not notice order was not working because I had an orderBy set, but then I saw that order is case-sensitive and that without orderBy it does not use the given ids order.

Edit: I see now that the order kept is the first call done to the API, then it stays frozen. Is there some kind of cache set by default? It's a bit weird that only respects the order first time and then when changing the ids object content it stays the same.

[CodeDredd]

Well there is a cache. But it is not on by default. I don't know yet if i understand the problem correctly. Can you maybe please make a reproduction 🙏 ?