Hey guys. I have two big datasets (more than 80.000 items). Im trying to perfome some queries and it works when the dataset is like 20.000 items but it crashes when its bigger. The message in the java console says: Uncaught (in promise) Error: WDE0028: Operation time limit exceeded. Here is part of the code: import wixData from 'wix-data'; $w("#table1").columns = [ { "id": "Diagnóstico", "dataPath": "Diagnóstico", "label": "Diagnóstico", "type": "string" }, { "id": "Porcentaje", "dataPath": "Porcentaje", "label": "Porcentaje", "type": "string" } ]; // Establecer la estructura de columnas en la tabla const columns = [ { "id": "Ciudad", "dataPath": "Diagnóstico", "label": "Ciudad", "type": "string" }, { "id": "Porcentaje", "dataPath": "Porcentaje", "label": "Porcentaje", "type": "string" } ]; $w("#tablaCiudad").columns = columns; const columnsProfesion = [ { "id": "Profesion", "dataPath": "Diagnóstico", "label": "Profesión", "type": "string" }, { "id": "Porcentaje", "dataPath": "Porcentaje", "label": "Porcentaje", "type": "string" } ]; $w("#profesionTable").columns = columnsProfesion; // Establecer la estructura de columnas en la tabla const columnsEncuesta = [ { "id": "Item", "dataPath": "Item", "label": "Item", "type": "string" }, { "id": "Porcentaje", "dataPath": "Porcentaje", "label": "Porcentaje", "type": "string" } ]; $w('#encuestaTable').columns = columnsEncuesta; async function countRecords() { let startDate = $w('#datePicker1').value; let endDate = $w('#datePicker2').value; let yearValue = startDate.getFullYear(); let monthValue = startDate.getMonth(); let dayValue = startDate.getDate(); let startDateSrch = new Date(yearValue, monthValue, dayValue, 0, 0, 0); yearValue = endDate.getFullYear(); monthValue = endDate.getMonth(); dayValue = endDate.getDate(); let endDateSrch = new Date(yearValue, monthValue, dayValue, 23, 59, 59); const MAX_ITEMS_PER_QUERY = 1000; async function fetchAllRecords(query) { let records = []; let skip = 0; let hasMoreRecords = true; while (hasMoreRecords) { let response = await query .limit(MAX_ITEMS_PER_QUERY) .skip(skip) .find(); records = records.concat(response.items); if (response.items.length < MAX_ITEMS_PER_QUERY) { hasMoreRecords = false; } else { skip += MAX_ITEMS_PER_QUERY; } } return records; } let hcCollection = await fetchAllRecords( wixData.query("BACKUPHC") .between("fechaConsulta", startDateSrch, endDateSrch) .eq("atendido", "ATENDIDO") .hasSome("codEmpresa", "PARTICULAR") ); let numeroIds = hcCollection.map(item => item.numeroId); let uniqueNumeroIds = [...new Set(numeroIds)]; console.log("LOS QUE SON", uniqueNumeroIds); // GÉNERO $w('#generoBtn').onClick(async (event) => { console.log("si"); let formCollection = await fetchAllRecords( wixData.query("FORMULARIOBK").hasSome("documentoIdentidad", uniqueNumeroIds) ); let matchingForms = formCollection.filter(form => uniqueNumeroIds.includes(form.documentoIdentidad)); let generosCoincidentes = matchingForms.map(form => `${form.documentoIdentidad} - ${form._createdDate.toLocaleDateString()}`); let formMaleCount = formCollection.filter(form => form.genero === "MASCULINO").length; let formFemaleCount = formCollection.filter(form => form.genero === "FEMENINO").length; let numFormRecords = formCollection.length; $w("#numFormRecords").text = numFormRecords.toString(); let numHCRecords = hcCollection.length; $w("#numHCRecords").text = numHCRecords.toString(); let numMaleRecords = formMaleCount; $w("#numMaleRecords").text = numMaleRecords.toString(); let numFemaleRecords = formFemaleCount; $w("#numFemaleRecords").text = numFemaleRecords.toString(); let numMatchingRecords = matchingForms.length; $w("#numMatchingRecords").text = numMatchingRecords.toString(); let malePercentage = (numMaleRecords / numMatchingRecords) * 100; $w("#porcentajeMasculino").text = malePercentage.toFixed(2).toString() + "%"; let femalePercentage = (numFemaleRecords / numMatchingRecords) * 100; $w("#porcentajeFemenino").text = femalePercentage.toFixed(2).toString() + "%"; }); Help!

Hi guys: I have an aggregation for my database but i need to group by date interval. This is the code: export function datePicker2_change_1(event) { function pad(num, size) { var s = num+""; while (s.length < size) s = "0" + s; return s; } const pickerDay = $w('#datePicker1').value.getDate().toLocaleString(); const pickerMonth = $w('#datePicker1').value.getMonth()+1; const pickerYear = $w('#datePicker1').value.getFullYear().toString(); const pickerDateMin = new Date(pickerYear+"-"+pad(pickerMonth,2)+"-"+pad(pickerDay,2)+"T00:00:00.000Z"); const pickerDay2 = $w('#datePicker2').value.getDate().toLocaleString(); const pickerMonth2 = $w('#datePicker2').value.getMonth()+1; const pickerYear2 = $w('#datePicker2').value.getFullYear().toString(); const pickerDateMax = new Date(pickerYear2+"-"+pad(pickerMonth2,2)+"-"+pad(pickerDay2,2)+"T23:59:59.999Z"); console.log(pickerDateMin, "end date"); console.log(pickerDateMax, "end date"); const filter = wixData.filter().contains("codEmpresa", codEmpresa) const dates = wixData.filter().gt("fechaConsulta", pickerDateMin).lt("fechaConsulta", pickerDateMax); wixData.aggregate("HistoriaClinica") .having(dates) .filter(filter) .group("ciudad") .count() .run() .then( (results) => { let items = results.items; $w("#table1").rows = items; console.log(items) }) } But it doesnt work. Any suggestions?

Guys I have a problem: I need to show the count results from an Aggregate code into a repeater. In the console it works fine but when I try to show the results in a repeater I have this 2 messages: Wix code SDK Warning: The text parameter of "ciudad" that is passed to the text method cannot be set to null or undefined. Wix code SDK error: Each item in the items array must have a member named `_id` which contains a unique value identifying the item. This is the code Im using: export function button15_click(event) { $w('#repeater2').forEachItem (($item, itemData) => { $item("#ciudad").text = itemData.ciudad; }) wixData.aggregate("HistoriaClinica") .group("ciudad") .count() .run() .then( (results) => { let items = results.items; $w("#repeater2").data = results.items; console.log(items) } ); } Any thoughts? Thanks!

Hi guys: How can I see the owner Id Nickname of the field? In the Owner ID field it shows: cb64693d-aa2a-40c7-beb5-acdea517e9da thanks!

Guys I have a problem. Im using SetFieldValue in my code two months ago, but today sometimes it works and some times doesnt. This is the code export function crear_click(event) { $w("#dataset1").setFieldValue("atendido", "PENDIENTE"); $w("#dataset1").save() } Any ideas?

Guys I have a problem: I have a Database that has been filter by user Badge. Aditionally I have a search engine to search by LastName in the same database, but if the user Badge filter is active the search engine doesnt work. This is the code import wixData from 'wix-data'; import wixUsers from 'wix-users'; //////FILTER BY BADGE/////// $w.onReady(function () { check();}); wixUsers.onLogin( (user) => {check();} ); function check () { wixData.query("Members/Badges") .hasSome("members", wixUsers.currentUser.id) .find() .then((results) => { let a = results.items[0].title; if (a === 'KPMG') { $w('#tabla').show(); wixData.query("HistoriaClinica") .hasSome("empresa", ["KPMG SAS", "ADVISORY TAX & LEGAL SAS", "ADV.SERV.BOGOTA"]) .find() .then( (results) => { $w("#tabla").rows = results.items; } ); ////SEARCH ENGINE//// let debounceTimer; export function iTitle_keyPress_1(event, $w) { if (debounceTimer) { clearTimeout(debounceTimer); debounceTimer = undefined; } debounceTimer = setTimeout(() => { filter($w('#iTitle').value); }, 200); } let lastFilterTitle; function filter(title) { if (lastFilterTitle !== title) { $w('#dataset1').setFilter(wixData.filter() .contains('numeroId', title) .or(wixData.filter() .contains("primerApellido", title))) lastFilterTitle = title } } Any Ideas?

I have a calculated field and I need to save it into a database. The calculated field is working fine but the save button doesnt The code: //CALCULATED FIELD export function calcularIMC_click_1(event, $w) { let Talla = Number($w("#talla").value); let Peso = Number($w("#peso").value);   $w("#imc").value = (Peso/(Talla*Talla)).toString(); } //SAVE BUTTON export function salvar_click(event){    $w("#dataset1").setFieldValue("mdImc", $w("#imc").value);    } It doesnt work. Can you help me?