How to get additional column value in distinct queries?

[Lux Smith]

I am using a distinct query (using the distinct keyword in the url) to retrieve distinct userIDs, but I also need full user name along with userID (collection has a column for full name). The response only return the userIDs. Can I retrieve additional columns in the response? Here is my database url

{database_url}/collections/studentsCollection/distinct/studentID

Also is there another way to specify distinct keyword in the "where" clause instead of the database url?

[Maryna Brodina]

Hello! No, you can retrieve distinct values from one collection column only. You can try to use server code for this purpose. In server code retrieve all values from collection and filter them the way you need.