Hi,
i am using Editor X Collections to store some custom user data. To further use this data i intalled the wix-data-sql package for velo.
The problem i have is, that the queries work kind of strage and sometimes give me different outputs when i run them multible times without changing something.
One problem for example is, that when i run a standard query like this:
export async function getAllUsers () {
try {
const results = await sql ( ‘SELECT * FROM User’ );
return results . payload . data ;
} catch ( error ) {
console . error ( error );
}
}
it will only return the data of 6 fields, which are all the system fields of my collection.
But when i adjust the query like this
export async function getAllUsers () {
try {
const results = await sql ( ‘SELECT * FROM User Where title=" Example "’ );
return results . payload . data ;
} catch ( error ) {
console . error ( error );
}
}
it will return the right 33 colums.
Does anyone know why this occurs or what i am doing wrong?
Thanks in advance!
Jari