Create a table item from a collection with reference field

Ask the community
,
1

Hello, i’m trying to fill a table item on a page with data from a collection (filtered by owner) which have a reference field to another collection.

This code works to fill the table but it shows the reference number and not the value of the reference field :

wixData.query(“OutillagePossession”)
.eq(“_owner”, wixUsers.currentUser.id)
.find()
.then( (results) => {
console.log(results);
$w(“#table1”).rows = results.items;
} );


How can I have the value in the table?

2

My question is quite simple (I think) : how can I retrieve field value (not the reference id value) in a DB when this field is a reference to a field in another database?
Maybe someone has a code to do that?
Thank you