I to everyone,
I am trying to create a query that modifies the data of two columns, but the various attempts seem not to work. Do you have any advice?
Thanks in advance as always
let today = new Date();
let code = $w( “#dts1” ).getCurrentItem().myCode; // code for query
wixData.query( “didacticalServices” )
.limit( 100 )
.eq( “codeTeacher” , code)
.eq( “typeService” , “LABORATORY” )
.find()
.then((res) => {
let items = res.items;
let item = items[ 0 ];
let dateEvent = $w(“#eventDate”).value;
if (dateEvent < today) {
for ( var i = 0 ; i < expired.item.length; i++) {
$w( “#dts2” ).setFieldValues({ . // dataset where change row record
“active” : false , // field to change
“status” : “CLOSED” , // field to change
})
$w( “#dts2” ).save();
}
}
})