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