Ordering and filtering from a CSV

[nuxt]

Ordering and filtering from a CSV

[benjamincanac]

Hi @dolbex,

The sortBy method is used to sort documents in a directory.

When using CSV, the lines are transformed into an array and stored in a body variable inside a single document. Like MongoDB, you cannot sort an array inside of a document.

You could perform a sort with Lodash for example:

const { body } = await $content('deniro').fetch()

return {
    movies: sortBy(body, 'title')
}

[dolbex]

@benjamincanac

Right on, and that's exactly what I did in my little test. I will say though, coming in cold, it's a little confusing seeing the comparisons to mongo, the cool queries on the document directories and then it not working in the following scenarios:

• CSV with a bunch of rows of data
• Single JSON file with an array of objects.

I'm not even implying that it should work for those two scenarios - it's just where I got a little head scratchy while working with hit for the first time.

I'm looking to see how I can use this for a client project that is a small CMS. Definitely looking forward to working with it.

[benjamincanac]

@dolbex

To detail the comparison with MongoDB, a directory is like a collection and a file is a document inside that collection.

As far as JSON arrays and CSV, the only way would be to flatten them inside the collection. However documents would have the same slug so it wouldn't be possible to fetch them anymore.

[salv0]

The sortBy method is used to sort documents in a directory.

When using CSV, the lines are transformed into an array and stored in a body variable inside a single document. Like MongoDB, you cannot sort an array inside of a document.

Even though this issue is already closed, it would be very helpful to add the information to the documentation and save all the future users a possible headache.