Hi all, I am having a problem where my query produces an internal error whenever I sort with .ascending a field that is type number and run with .distinct for a field that is a string. A simple example is: wixData.query("DB") .ascending('index') .distinct('itemName') .then( (res…

Wixdata Query Fails When .ascending and .distinct are different types

statzern October 13, 2019, 1:31pm 3

Thanks, that will work well. Also, it does work with aggregate as well, apparently just not .distinct, in case anyone else runs into this problem

Topic		Replies	Views
WixDataQuery sort question Ask the community code , design , question	4	151	July 21, 2020
WixData Query - Need to create array of just one field Ask the community code , question	7	379	May 29, 2022
distinct() --- issue Ask the community code , question	9	404	August 21, 2019
Documentation - typo (for Wix Team) Ask the community code , question	1	122	August 20, 2019
Ascending & distinct Ask the community code , question	4	502	September 9, 2020