wixData.query when one of the fields define as multiple items

hi,

I have the following data collection:

when I query this collection I cannot get the multi item field as list of values.

This is the query:

wixData.query(“Member”)
.find()
.then( (results) => {
console.log(results.items);
}
)

and this is the log:

0:
“{"_id":"3f0b0d81-c838-4b31-b394-3a0630d2ac26","_owner":"9c180f66-a051-4bf3-b430-88ec88373a0a","facilities":"a353fa3a-4525-4ae7-a9bb-3befb805c120","_createdDate":"2019-10-31T10:14:38.805Z","_updatedDate":"2019-10-31T14:13:37.871Z","title":"shiri.yoni@gmail.com","gender":"ee094c7f-41bb-4d9b-afd2-78c5d25e555a"}”
1:
“{"_id":"6779d7ab-1e42-46ba-b55a-d572b1368698","_owner":"9c180f66-a051-4bf3-b430-88ec88373a0a","facilities":"f2b8a5ff-6006-4d28-a401-ec738ca0717f","_createdDate":"2019-10-31T10:14:29.388Z","_updatedDate":"2019-10-31T14:13:40.598Z","title":"yonieilon@gmail.com","gender":"152e677d-5532-402c-81a1-c44185e26fdf"}”
2:
“{"_id":"2e1b1273-0570-4f7c-9e90-6a0f4f9b9919","_owner":"9c180f66-a051-4bf3-b430-88ec88373a0a","facilities":"a353fa3a-4525-4ae7-a9bb-3befb805c120","_createdDate":"2019-10-31T10:14:17.523Z","_updatedDate":"2019-10-31T14:13:44.698Z","title":"info@goldfactor.co.il","gender":"152e677d-5532-402c-81a1-c44185e26fdf"}”
3:
“{"_id":"70a7a9cd-0c7c-4741-bb7f-ee560e89b113","_owner":"9c180f66-a051-4bf3-b430-88ec88373a0a","facilities":"f2b8a5ff-6006-4d28-a401-ec738ca0717f","_createdDate":"2019-10-31T10:13:54.159Z","_updatedDate":"2019-10-31T14:13:50.205Z","title":"shirisahray@gmail.com","gender":"ee094c7f-41bb-4d9b-afd2-78c5d25e555a"}”
4:
“{"_id":"9f313a00-57f7-41b0-8f5f-8279867ee3a4","_owner":"9c180f66-a051-4bf3-b430-88ec88373a0a","facilities":"a353fa3a-4525-4ae7-a9bb-3befb805c120","_createdDate":"2019-10-31T10:13:40.176Z","_updatedDate":"2019-10-31T14:13:53.088Z","title":"shiri.eilon@goldfactor.co.il","gender":"ee094c7f-41bb-4d9b-afd2-78c5d25e555a"}”

Thanks in advance

You’re right. To get these values, you’lll need to add to your query (before the find() function):

 .include("facilities") 

Thanks! it works now

@shirieilon You’re welcome :slight_smile: