I have a MembersListTable that is getting content from MembersListDetails collection. The first_name and last_name fields are reference fields getting content from the privateMembersData collection. I am trying to sort the MembersListTable by the first_name column.
Ideally I would like to know who to click the First Name column header and have it click by first_name.
Thank you in advance for your help.
Sylvia
This is what I have tried so far nothing works.
import wixData from 'wix-data';
wixData.query("MembersListDetails")
.ascending("first_name", "last_name")
.find()
.then( (results) => {
if(results.items.length > 0) {
let items = results.items;
let firstItem = items[0];
let totalCount = results.totalCount;
let pageSize = results.pageSize;
let currentPage = results.currentPage;
let totalPages = results.totalPages;
let hasNext = results.hasNext();
let hasPrev = results.hasPrev();
let length = results.length;
let query = results.query;
} else {
// handle case where no matching items found
}
} )
.catch( (error) => {
let errorMsg = error.message;
let code = error.code;
} );
import wixData from 'wix-data';
$w.onReady(function () {
//TODO: write your page related code here...
});// ...
wixData.query("MembersListDetails")
.descending("first_name", "last_name")
.limit(10)
.find()
.then( (results) => {
if(results.items.length > 0) {
let items = results.items;
let firstItem = items[0];
let totalCount = results.totalCount;
let pageSize = results.pageSize;
let currentPage = results.currentPage;
let totalPages = results.totalPages;
let hasNext = results.hasNext();
let hasPrev = results.hasPrev();
let length = results.length;
let query = results.query;
} else {
// handle case where no matching items found
}
} )
.catch( (error) => {
let errorMsg = error.message;
let code = error.code;
} );
import wixData from 'wix-data'
export function MembersListDetails_beforeUpdate(item, context) {
// Get id regardless of whether you're adding the item through site or Content Manager
const firstName = item.firstName._id || item.firstName
// Get data from referenced collection
return wixData.get('privateMembersData', firstName)
.then(ref => {
// Add value that you'll use to filter your collection
item.first_name = ref.first_name
return item
})
}