Hi,
Have made a data query with 2 conditions email and Date. I have made this is ascending and descending like this. Is this right?? Will it work. Some places its working. Am I goinf right. Please help me
wixData.query(‘LM_Attendance’). eq(‘at_date’, date).eq(‘at_email’, $w(“#email”).value) .descending(“at_out”)
.find()
.then(result => {
$w(“#input2”).show();
let item = result.items[0];
let Id = result.items[0]._id;
let createddate = result.items[0]._createdDate;
let updatedDate = result.items[0]._updatedDate;
let owner = result.items[0]._owner;
let title = result.items[0].title;
let at_email = result.items[0].at_email;
let at_date = result.items[0].at_date;
let at_in = result.items[0].at_in;
let at_out = result.items[0].at_out;
let at_actual = result.items[0].at_actual;
let at_regfullday = result.items[0].at_regfullday;
let at_regtime = result.items[0].at_regtime;
let at_type = result.items[0].at_type;
let at_latitude = result.items[0].at_latitude;
let at_longitude = result.items[0].at_longitude;
let at_reason = result.items[0].at_reason;
let at_agenda = result.items[0].at_agenda;
let at_outcome = result.items[0].at_outcome;
let at_remarks = result.items[0].at_remarks;
let at_clientname = result.items[0].at_clientname;
let at_mobile = result.items[0].at_mobile;
let at_reg_done = result.items[0].at_reg_done;
let toUpdate = {
“_id”:Id,
“_createdDate”:createddate,
“_updatedDate”:updatedDate,
“_owner”:owner,
“title”:title,
“at_email”: $w(“#email”).value,
“at_date”: at_date,
“at_in”: at_in,
“at_out”: at_out,
“at_regfullday”: at_regfullday,
“empId”: $w(“#empid”).text,
“at_regtime”: new Date(dummydate),
“at_type”: at_type,
“at_latitude”:at_latitude,
“at_longitude”:at_longitude,
“at_reason”:at_reason,
“at_agenda”:at_agenda,
“at_outcome”:at_outcome,
“at_remarks”:at_remarks,
“at_clientname”:at_clientname,
“at_mobile”:at_mobile,
“at_reg_done”:at_reg_done_attendance
};
wixData.update(“LM_Attendance”, toUpdate)
.then((results) => {
let item_attendance = results;
})
. **catch** ((err) => {
let errorMsg = err;
});
return item_attendance;
}