I m new to MongoDB, for me I need to search the name " Raja Sekar " from name field in the database, I have indexed it. But my condition is search term should match 75 percent of similar records. Can you please help me with this db.customers.find({$text: {$search: "raja sekar kumar"}}, {score: {$meta: "textScore"}}).sort({score:{$meta:"textScore"}}) ..
Category : search
I am trying to put a search engine in my laravel page, but I have a lot of difficulties to be able to achieve it, clearly I cannot find the way to work correctly. the version of laravel I use is 5.8. I leave the code to see if someone can help me! Form in ..
I’m trying to create a very basic fuzzy search that uses the values of an object in props. The below search works fine, but only checks for speciality.name How would I modify this to allow for it to check not only candidate.speciality.name but other values from inside candidate? i.e. how would I go about letting ..
Trying to make a partial search on an indexed field. I use Laravel 6.9. I ‘ve created a field for every document in my collection that consists of the data of 5 other fields seperated with a ~. For example name~surname~address~phone~mobile. I created just one field so that i can make the search faster. This ..
In laravel nova resource index i want to add custom input fields(text form checkbox) to interact with table via submit button. I want the same operation with filters. But i don’t want in table’s right corner. I want them above the table. Is also possible to hide default create button and form? how i set ..
I have job_sector table in which sector_id and job_id fields are there. I just want to search job_id by the sectors which I have selected through checkbox. One may select multiple sectors. My model : public function scopeSelectedOptions($query, $input = []) { if(!empty($input)) { if(array_key_exists(‘sector_id’, $input)) { $query->whereHas(‘sector_id’, function($q) use ($input) { return $q->whereIn(‘sector_id’, $input[‘sector_id’]); ..
I am trying to filter the records from min to max. I have two nodes from where I want to filter one is min and other is max. Here is what i tried I have two values to compare $request->min && $request->max . I don’t know what i am doing wrong. Here is my PHP ..
I have sector table in which sector_id and job_id is there. I just want to search job_id by the sectors which I have selected through checkbox. I may select multiple sectors. My model : public function scopeSelectedOptions($query, $input = []) { if(!empty($input)) { if(array_key_exists(‘sector_id’, $input)) { $query->whereHas(‘sector_id’, function($q) use ($input) { return $q->whereIn(‘sector_id’, $input[‘sector_id’]); }); ..
In the database there are 1000 User and 2000 Items for sign out. There is a Transaction Form where you select User then the Item they are borrowing then click Submit. I’m trying to create a Search for User and Item. I’m avoiding third-party Laravel plugins like Select2. Is there a better way to search ..
I have a Laravel 7 app that uses Spatie’s tagging package, and also Algolia search using their standard library via its stock Laravel Scout integration. The two search mechanisms come down to this for the tags: $items = Item::withAllTags( $searchtags, Item::TAGTYPE_PRIMARY ); This apparently returns an Eloquent "scope", not a builder or collection, which I ..
Question : I have a table called product with some bunch of columns. One of which is name. The problem is : Sample entries: name: Salt Powder. name: Chilli powdeR The problem When i do a query for https://example.com/public/api/products?search=name%3Apowder I get 0 results . Expectation is to return Salt Powder & Chilli powdeR since the ..
I’m building a search mechanism with Laravel and Vue in which a panel is shown displaying the thumbnail of each of the products as you type. So, as soon as you type more than 3 letters, for each letter it’s updating that list asynchronously. My question is: should I preload all of the results and ..
I need to search multiple words in title column in laravel. Like if i search tea break then i need to fetch only those rows that title content tea and break. If any title contain only tea then it will not come on my result. I have added below code but it’s fetch only contain ..
I have an addresses table in my MYSQL database with the following structure: The first column ID, is a primary, auto-increment column. The second column Name is varchar. The third column contains address (text), filled by user. The forth column contains address slug, which is basically the address (Third Column) in lower case and without ..
I’m doing a search a month, but I can’t find anything. Start is a column of type date, 2020-07-23. Controller: public function cityName(Request $request, City $city) { $month = $request->month; $status = $request->status; if (!empty($month)) { $chamado = Chamados::where(‘cite_id’, $city->id) ->whereMonth(‘start’, $month) ->when($status, function ($query, $status) { return $query->where(‘status’, $status); })->get(); } else { $chamado ..
$students = Student::elect(‘students.*’, ‘users.email’)->join(‘users’, ‘students.user_id’, ‘users.id’)->orderBy("id", "desc")->skip($page * $pageSize)->take($pageSize); if (request(‘se’) != "" || request(‘se’) != null) { $se = request(‘se’); $se = str_replace("+", " ", $se); $students = $students ->where(function ($q) use ($se) { $q->where(‘students.student_number’, ‘like’, ‘%’ .$se. ‘%’) ->orWhere(DB::raw("CONCAT(`first_name`, ‘ ‘, `last_name`)"), ‘LIKE’, ‘%’ . $se . ‘%’) ->orWhere(‘students.gender’, $se) ->orWhere(‘students.phone’, ‘like’, ‘%’ ..
I’m having a problem when I need to make a Search on my datatable. I have 4 columns with relation with another tables. On my controller I make a join to convert this data, so when I put some ID on search box, the filter works nicely, but I need make this search work only ..
i am trying to work with Algolia on LAREVEL 6 and I get this error AlgoliaAlgoliaSearchExceptionsUnreachableException : Impossible to connect, please check your Algolia Application Id. I don’t have an Algolia app id or secret , how can I get it please ? Thank you Source: Laravel Sta..
I tried to code a request with search system. Here the code: $search = request()->get(‘search’); if(Auth::user()->hasRole(‘admin’) || true) { list($orderBy, $orderDirection) = explode(‘.’, request()->get(‘sort_by’)); $prestations = Prestation::with( ‘service:id,name’, ‘facility:id,name’ ) ->orWhere(‘service:name’, ‘regexp’, “/$search/i”) ->orderBy($orderBy, $orderDirection) ->simplePaginate(50); $res = [ ‘results’ => $prestations, ‘total’ => Prestation::all()->count(), ]; return $res; } The problem is that I don’t ..