Hello. I’m newbie and need a little help. How can I use API to search an iten by term? Eg. /api/collections/get/products I have products with name field. Is there any to search products that name=Iphone?

Hi, you can provide a filter parameter. e.g: /api/collections/get/products?filter[name]=Iphone For more information: https://getcockpit.com/documentation/api/collections Greets Artur

Thank you for help me! Works fine, but doens’t work if I search by iphone. Is there any way to work with lowercase with the same result?

/api/collections/get/products?filter[name][$regex]=iphone

how do you filter by multiple fileds? for example name=iphone and published=1 ? *edit never mind; found out my self: ?filter[name]=iphone&filter[published]=1

Hi, Do you think it is possible to find differents terms at same time? /api/collections/get/products?filter[name]=Iphone&filter[name]=Samsung Thank you :slight_smile:

the query should look like this (requesting as application/json) { filter { $and: [ {name: 'Iphone'}, {name: 'Samsung'} ] } } Doing a GET request, this should look like this (not tested): /api/collections/get/products?filter[$and][][name]=Iphone&filter[$and][][name]=Samsun…

[image] artur: ?filter[$and][name]=Iphone&filter[$and][name]=Samsung Hey Artur, When you request as app/json, it’s working well! But i’m more interested in GET request, and your request doesn’t work.

[image] unenouvelleville: But i’m more interested in GET request, and your request doesn’t work. can’t test it right now, but try this: /api/collections/get/products?filter[$and][0][name]=Iphone&filter[$and][1][name]=Samsung

@artur Mmmmm, i think i am a bit tired! We can’t use AND, but OR! /api/collections/get/products?filter[$or][0][name]=iPhone&filter[$or][1][name]=Samsung Thank you for your precious help!

[image] artur: [$and][0][name] Hello ! How can we filter collections based on words contained in a field. (As the ‘LIKE’ condition in sql/sqlite). I’m using sqlite in my config but filtering work only when all the field’s value is filled in for the request. I mean, I’ve to query with all the…

Search itens by term

Support

raffaelj November 12, 2020, 8:50am 15

You can’t search in all collections by default, but you can write a custom api endpoint to do that job. In this thread are two possible solutions:

Topic		Replies	Views
API - Search for items containing text	2	1324	September 7, 2021
Locales Filters API Support	1	255	June 24, 2024
Filter collection entries by collection link Support	1	2578	September 24, 2018
Admin UI Filter/ search in specific language General	0	596	January 8, 2019
How do I 'get' a particular Collection item Support	4	847	November 28, 2021

Search itens by term

Related topics