Why is this date sorting not working?

Moralis General
#1

Hey,

I’m trying to sort the queries by date but it is not working as it gives me an error

useEffect(async () => {

        const pipeline = { sort : { updatedAt : 1 } }

        return data.aggregate(pipeline)

        const results = JSON.stringify(x, null, 2)

        const finalResult = JSON.parse(results)

        setResults(finalResult)

    }, [])
#2

what is the error that you get?

#3

TypeError: data.aggregate is not a function

#4

data is gotten from a inbuild moralis function in react


	const { data, error, isLoading } = useMoralisQuery("Posts");
#5

what is data in your case?

#6

Posts query which contains all the posts

#7

if you already have all the posts, you could sort them maybe differently directly in javascript, that syntax with aggregate is similar to do a sort in a query

#8

hm ok. Do you know why in the dashboard browser updated and createdAt are named “createdAt” and “updatedAt” but when connecting via some mongo db UI tool the columns are named _updated_at and_created_at ?

#9

that is an internal naming for some columns that are used different by the server, most of what you see here is from parse server that is used by moralis