Hi, I’m migrating a web from DatoCMS to Builder. Previously, I had a query filter like this: const { allBlogs } = await dato().GetAlBlogs({ search, minYear, maxYear, dataProvided: dataProvided && { pattern: buildRegexp(dataProvided), caseSensitive: false …

Hi @emiliano , you can use the query option to set a search query here. Here is an example for how you could search the title field: await builder.getAll("blog-model", { options: { noTargeting: true }, limit: 100, query: { data: { title: { $regex: searchQuery }}} } ) You…

Thanks for answering @sarah ! Just some doubts: I can’t add javascript there… for example, I want to do toLowerCase() to title, so it’s easier to match the searchQuery Or for example, I want to filter by date, so previously I did this: Number(entry.date.slice(0, 4)) <= maxYear.getFullYear()… h…

Hi @emiliano , Can you elaborate a little on how to you want to use toLowerCase()? To filter by date you could use something like the example below: query: {createdDate: {$gt: timestamp}} To search for multiple values in an array, you can use something like this: const regexSearch = dataProvided…

Thanks for answering! the toLowerCase() I would use it because the ‘title’ might be, for example, ‘Getting Started with Scale’, and the user in the search input would type: ‘getting started with scale’, or ‘getting started with Scale’… so if I transform both title and search input to lower case, …

Hi @emiliano , You can use the $and operator to combine logic in the query. You can also use the toLowerCase() method. Here is an example: query: {$and: [ {createdDate: {$gt: timestamp}}, {createdDate: {$lt: timestamp}}, {name: {$regex: string.toLowerCase()}} ]} You…

Thanks! but this way I still cant add javascript to title, name, date, etc (the builder fields)… I would like to do something like this… [Screen Shot 2022-04-15 at 17.15.33]

Hi @emiliano , you’re correct, this will not work, but you could work around this by getting unfiltered data and then running these methods afterwards.

Hi again Sarah, I was searching and testing and I accomplish to do all the filters except for one. Currently I have this code: const sets = await builder.getAll('open-dataset', { options: { noTargeting: true }, omit: 'data.blocks', limit: 100, query: { data: { …

How can I filter with the GetAll('entry')?

General

sarah April 19, 2022, 5:57pm 10

Hi @emiliano,

I responded to this question here: FIlter entries inside the query - #2 by sarah

Topic		Replies	Views
API data query filtering Technical Questions react , api , nextjs	6	1397	April 20, 2022
FIlter entries inside the query General	1	829	April 19, 2022
Content API queries Technical Questions	4	1594	March 20, 2023
REST API query $or doesnt seem to properly work Technical Questions api	4	780	March 6, 2024
Fulltext search in custom fields Feature Requests	7	1914	April 6, 2022

How can I filter with the GetAll('entry')?

Related topics