ASP:NET MVC multiple words in search

Question

I having trouble finding out how to handle multiple words when the user searches. An example: Search: "Blue box" it should be able to find: "One box is blue". How would I do this? This is basically how my controller looks like atm:

public ActionResult Index(string searchString)
{
    var posts = from s in _context.Posts
                   select s;

    var postIndexViewModel = new PostIndexViewModel();

    if (!String.IsNullOrEmpty(searchString))
    {
            posts = posts.Where(s => s.Title.Contains(searchString));
     }

    // More code here

    return View(postIndexViewModel);

}

first use searchString.Split(' ') to split the searchstring into an array, then look here: stackoverflow.com/questions/2912476/… — Stephen
– Stephen, Commented Jul 3, 2015 at 11:21
split the searchString using space. Then use Array.Any() as shown here - stackoverflow.com/questions/1757214/… — ramiramilu
– ramiramilu, Commented Jul 3, 2015 at 11:22

Jamie Rees · Accepted Answer · 2015-07-07 08:06:37Z

3

Your problem is that you are doing the contains with a whole string. That means it must contain "Blue box" in that order.

This is what you need to do:

var strings = searchString.Split(' ');
var finalPosts = new List<string>();
if (!String.IsNullOrEmpty(searchString))
{
    foreach (var splitString in strings)
    {
        finalPosts.Add(posts.FirstOrDefault(s => s.Title.Contains(splitString)));
    }     
}

The finalPosts list then contains your results.

edited Jul 7, 2015 at 8:06

answered Jul 3, 2015 at 11:26

Jamie Rees

8,1832 gold badges51 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Rockyy Over a year ago

This looks correct. What would I do to fix the problem that cannot convert from 'System.Linq.IQueryable<WebApplication3.Models.Post>' to 'string' on the finalPosts.Add() line?

Jamie Rees Over a year ago

Apologies, I was unsure what your type was of post Just change the var finalPosts = new List<string>(); to: var finalPosts = new List<Post>();

Rockyy Over a year ago

:) I tried that aswell. Got cannot convert from 'System.Linq.IQueryable<WebApplication3.Models.Post>' to 'WebApplication3.Models.Post'

Jamie Rees Over a year ago

Ah posts is a List<Post> already. Use this finalPosts.Add(posts.FirstOrDefault(s => s.Title.Contains(splitString)));

Jamie Rees Over a year ago

@Rockyy Of course, I just created a new List since I did not know what you wanted to do with the results. Using the List you now have all of the search results in one place.

|

Yang Zhang · Accepted Answer · 2015-07-03 23:09:50Z

1

One way I can think of is to search term by term by splitting search string passed in.

public ActionResult Index(string searchString)
{
    var posts = from s in _context.Posts
                   select s;

    var postIndexViewModel = new PostIndexViewModel();

    if (!String.IsNullOrEmpty(searchString))
    {
        var terms = searchString.Trim().Split(' ');
        posts = posts.Where(s => terms.Any(terms.Contains));
     }

    // More code here

    return View(postIndexViewModel);

}

edited Jul 3, 2015 at 23:09

answered Jul 3, 2015 at 11:24

Yang Zhang

4,5704 gold badges39 silver badges35 bronze badges

Comments

SALIU OLADITAN · Accepted Answer · 2021-12-10 11:30:59Z

0

This works perfectly well for me. See the code snippet and the screenshot below:

string[] SplitValue = StaffSearch.Split(",");

List<HistorypodScans> query = new List<HistorypodScans>();

foreach (var word in SplitValue)
{
      var staffquery = _db.HistorypodScans.Where(x => x.Waybillnumber.Contains(word) || x.AWBNO.Contains(word)).ToList();
      query.AddRange(staffquery);

}

return View(query);


[enter image description here][1]

[1]: https://i.sstatic.net/TRmMW.jpg Multiple Words Search Result

answered Dec 10, 2021 at 11:30

SALIU OLADITAN

11 bronze badge

Collectives™ on Stack Overflow

ASP:NET MVC multiple words in search

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related