Hi All, I'm saving a list of ids to a

Type.otherTypeIds

as an array by executing

mutation

. Is there a way to fetch (query) items of

OtherType

in the order specified in the array?

Don't know if I understood you, but I think you could order them by field, such as the automatic `createdAt`field that comes with every newly created record. https://www.graph.cool/docs/reference/graphql-api/query-api-nia9nushae#ordering-by-field

@Dukuo I don't want to sort them (order By)

oh, alright, so maybe this can help? https://stackoverflow.com/questions/28853686/sort-array-by-attribute

@Dukuo Thanks for suggestions but it's not a problem on UI, the problem is tha I recieve items of type

OtherType

already in some order from GraphCool.

would you mind sharing your query? now i'm just curious of what you are trying to achieve

@Dukuo and I want to have mu custom order, which is an order of ids I provided in save / update mutation of type

Type

i'm following

and now I have in GUI dynamic component when i can reorder addresses, let say Customer

Google

have 3 addresses assigned

okay I think I got the idea

it is saved into GraphCool with that order, however when I read it is get adress with ID===2 as the first one

I would store a custom order field in each field

yes, I mentioned that above, however for some reasons I don't want to do it

could you elaborate on why ?

mainly because I whould have to add new intermediate type

but it would solve your problem and it would not be graphcool-query-array dependant

what's interesting in the DATA section on webconsole I can see that IDs are in the order I've created on GUI

Maybe @nilan can help us. How's the deal with querying for a

Type

and the resulting record order?

that's true, but from trivial it immediately gets to medium size and from business point of view it's not as important

the thing is that if you are ordering by ID I would assume the order you are seeing in the console is the order you created the records

the thing is I don't use any

orderBy

by they are sorted by

createdAt

yeah, that's the thing. Your records are currently being ordered by the

createdAt

field, not the ID sorting you are managing

yes, but that order is already there, as the order of elements in an array of

Customer.addresses

field

yeah but that order was when you newly created those 3 records of your example

I can!

then how are you currently doing it! hahah

that's the point if you go to DATA section in GraphCool console you can see it is correct

yeah but how in the world are you ordering them in your current implementation ?

Can I past image into this chat?

sure, you can copy the image to your clipboard and simply paste it in the textbox

don't work

woops, you are right

{ allProfiles { profileName skills(orderBy: null) { id name } } }

that's your current way of doing it ?

simplified

well that

orderBy: null

is so suspicious

{ "data": { "allProfiles": [ { "profileName": "Oracle Developer", "skills": [ { "id": "cj6nne3td1um60191sdqowwp0", "name": "SQL" }, { "id": "cj6nniqcj1upu0191q5dxswju", "name": "PL SQL" } ] },

I would assume that it's still ordering by some field, which I don't think is the ordering you are trying to do.

Probably with more time I will

oh np at all, thanks for your patience

thanks a lot