ISearch Interface

public interface ISearch : IItemCollection, 
	IHierarchyItem, IHierarchyItemBase

Public Interface ISearch
	Inherits IItemCollection, IHierarchyItem, IHierarchyItemBase

public interface class ISearch : IItemCollection, 
	IHierarchyItem, IHierarchyItemBase

type ISearch =  
    interface
        interface IItemCollection
        interface IHierarchyItem
        interface IHierarchyItemBase
    end

public async Task<PageResults> SearchAsync(string searchString, SearchOptions options, List<PropertyName> propNames, long? offset, long? nResults)
{
    bool includeSnippet = propNames.Any(s => s.Name == snippetProperty);

    // search both in file name and content
    string commandText =
        @"SELECT System.ItemPathDisplay" + (includeSnippet ? " ,System.Search.AutoSummary" : string.Empty) + " FROM SystemIndex " +
        @"WHERE scope ='file:@Path' AND (System.ItemNameDisplay LIKE '@Name' OR FREETEXT('""@Content""')) " +
        @"ORDER BY System.Search.Rank DESC";

    commandText = PrepareCommand(commandText,
        "@Path", this.dirInfo.FullName,
        "@Name", searchString,
        "@Content", searchString);

    Dictionary<string, string> foundItems = new Dictionary<string, string>();
    try
    {
        // Sending SQL request to Windows Search. To get search results file system indexing must be enabled.
        // To find how to enable indexing follow this link: http://windows.microsoft.com/en-us/windows/improve-windows-searches-using-index-faq
        using (OleDbConnection connection = new OleDbConnection(windowsSearchProvider))
        using(OleDbCommand command = new OleDbCommand(commandText, connection))
        {
            connection.Open();
            using(OleDbDataReader reader = command.ExecuteReader())
            {
                while (await reader.ReadAsync())
                {
                    string snippet = string.Empty;
                    if (includeSnippet)
                    {
                        snippet = reader.GetValue(1) != DBNull.Value ? reader.GetString(1) : null;
                        // XML does not support control characters or permanently undefined Unicode characters. Removing them from snippet. https://www.w3.org/TR/xml/#charsets
                        if (!string.IsNullOrEmpty(snippet) && invalidXmlCharsPattern.IsMatch(snippet))
                        {
                            snippet = invalidXmlCharsPattern.Replace(snippet, String.Empty);
                        }
                    }
                    foundItems.Add(reader.GetString(0), snippet);
                }
            }
        }
    }
    catch (OleDbException ex) // explaining OleDbException
    {
        context.Logger.LogError(ex.Message, ex);
        switch (ex.ErrorCode)
        {
            case -2147217900: throw new DavException("Illegal symbols in search phrase.", DavStatus.CONFLICT);
            default: throw new DavException("Unknown error.", DavStatus.INTERNAL_ERROR);
        }
    }

    IList<IHierarchyItem> subtreeItems = new List<IHierarchyItem>();
    foreach (string path in foundItems.Keys)
    {
        IHierarchyItem item = await context.GetHierarchyItemAsync(GetRelativePath(path)) as IHierarchyItem;
        if (item == null)
        {
            continue;
        }

        if (includeSnippet && item is DavFile)
            (item as DavFile).Snippet = HighlightKeywords(searchString.Trim('%'), foundItems[path]);

        subtreeItems.Add(item);
    }

    return new PageResults(offset.HasValue && nResults.HasValue ? subtreeItems.Skip((int)offset.Value).Take((int)nResults.Value) : subtreeItems, subtreeItems.Count);

}

Public Async Function SearchAsync(searchString As String, options As SearchOptions, propNames As List(Of PropertyName), offset As Long?, nResults As Long?) As Task(Of PageResults) Implements ISearch.SearchAsync
    Dim includeSnippet As Boolean = propNames.Any(Function(s) s.Name = snippetProperty)
    ' search both in file name and content
    Dim commandText As String = "SELECT System.ItemPathDisplay" & (If(includeSnippet, " ,System.Search.AutoSummary", String.Empty)) & " FROM SystemIndex " & "WHERE scope ='file:@Path' AND (System.ItemNameDisplay LIKE '@Name' OR FREETEXT('""@Content""')) " & "ORDER BY System.Search.Rank DESC"
    commandText = PrepareCommand(commandText,
                                "@Path", Me.dirInfo.FullName,
                                "@Name", searchString,
                                "@Content", searchString)
    Dim foundItems As Dictionary(Of String, String) = New Dictionary(Of String, String)()
    Try
        Using connection As OleDbConnection = New OleDbConnection(windowsSearchProvider)
            Using command As OleDbCommand = New OleDbCommand(commandText, connection)
                connection.Open()
                Using reader As OleDbDataReader = command.ExecuteReader()
                    While Await reader.ReadAsync()
                        Dim snippet As String = String.Empty
                        If includeSnippet Then
                            snippet = If(reader.GetValue(1) <> DBNull.Value, reader.GetString(1), Nothing)
                            ' XML does not support control characters or permanently undefined Unicode characters. Removing them from snippet. https:'www.w3.org/TR/xml/#charsets
                            If Not String.IsNullOrEmpty(snippet) AndAlso invalidXmlCharsPattern.IsMatch(snippet) Then
                                snippet = invalidXmlCharsPattern.Replace(snippet, [String].Empty)
                            End If
                        End If

                        foundItems.Add(reader.GetString(0), snippet)
                    End While
                End Using
            End Using
        End Using
    Catch ex As OleDbException
        context.Logger.LogError(ex.Message, ex)
        Select Case ex.ErrorCode
            Case -2147217900
                Throw New DavException("Illegal symbols in search phrase.", DavStatus.CONFLICT)
            Case Else
                Throw New DavException("Unknown error.", DavStatus.INTERNAL_ERROR)
        End Select

    End Try

    Dim subtreeItems As IList(Of IHierarchyItem) = New List(Of IHierarchyItem)()
    For Each path As String In foundItems.Keys
        Dim item As IHierarchyItem = TryCast(Await context.GetHierarchyItemAsync(GetRelativePath(path)), IHierarchyItem)
        If item Is Nothing Then
            Continue For
        End If

        If includeSnippet AndAlso TypeOf item Is DavFile Then TryCast(item, DavFile).Snippet = HighlightKeywords(searchString.Trim("%"c), foundItems(path))
        subtreeItems.Add(item)
    Next

    Return New PageResults(If(offset.HasValue AndAlso nResults.HasValue, subtreeItems.Skip(CInt(offset.Value)).Take(CInt(nResults.Value)), subtreeItems), subtreeItems.Count)
End Function

No code example is currently available or this language may not be supported.

No code example is currently available or this language may not be supported.

public async Task<PageResults> SearchAsync(string searchString, SearchOptions options, List<PropertyName> propNames, long? offset, long? nResults)
{
    bool includeSnippet = propNames.Any(s => s.Name == snippetProperty);

    // search both in file name and content
    string commandText =
        @"SELECT System.ItemPathDisplay" + (includeSnippet ? " ,System.Search.AutoSummary" : string.Empty) + " FROM SystemIndex " +
        @"WHERE scope ='file:@Path' AND (System.ItemNameDisplay LIKE '@Name' OR FREETEXT('""@Content""')) " +
        @"ORDER BY System.Search.Rank DESC";

    commandText = PrepareCommand(commandText,
        "@Path", this.dirInfo.FullName,
        "@Name", searchString,
        "@Content", searchString);

    Dictionary<string, string> foundItems = new Dictionary<string, string>();
    try
    {
        // Sending SQL request to Windows Search. To get search results file system indexing must be enabled.
        // To find how to enable indexing follow this link: http://windows.microsoft.com/en-us/windows/improve-windows-searches-using-index-faq
        await using (OleDbConnection connection = new OleDbConnection(context.Config.WindowsSearchProvider))
        await using(OleDbCommand command = new OleDbCommand(commandText, connection))
        {
            connection.Open();
            await using(OleDbDataReader reader = command.ExecuteReader())
            {
                while (await reader.ReadAsync())
                {
                    string snippet = string.Empty;
                    if (includeSnippet)
                    {
                        snippet = reader.GetValue(1) != DBNull.Value ? reader.GetString(1) : null;
                        // XML does not support control characters or permanently undefined Unicode characters. Removing them from snippet. https://www.w3.org/TR/xml/#charsets
                        if (!string.IsNullOrEmpty(snippet) && invalidXmlCharsPattern.IsMatch(snippet))
                        {
                            snippet = invalidXmlCharsPattern.Replace(snippet, String.Empty);
                        }
                    }
                    foundItems.Add(reader.GetString(0), snippet);
                }
            }
        }
    }
    catch (OleDbException ex) // explaining OleDbException
    {
        context.Logger.LogError(ex.Message, ex);
        switch (ex.ErrorCode)
        {
            case -2147217900: throw new DavException("Illegal symbols in search phrase.", DavStatus.CONFLICT);
            default: throw new DavException("Unknown error.", DavStatus.INTERNAL_ERROR);
        }
    }

    IList<IHierarchyItem> subtreeItems = new List<IHierarchyItem>();
    foreach (string path in foundItems.Keys)
    {
        IHierarchyItem item = await context.GetHierarchyItemAsync(GetRelativePath(path)) as IHierarchyItem;
        if (item == null)
        {
            continue;
        }

        if (includeSnippet && item is DavFile)
            (item as DavFile).Snippet = HighlightKeywords(searchString.Trim('%'), foundItems[path]);

        subtreeItems.Add(item);
    }

    return new PageResults(offset.HasValue && nResults.HasValue ? subtreeItems.Skip((int)offset.Value).Take((int)nResults.Value) : subtreeItems, subtreeItems.Count);

}