Search by file extension and author

The following example shows you how to search by file extension and author.

C# example

using System;
using System.Net;
using Independentsoft.Share;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                Service service = new Service("https://independentsoft.sharepoint.com", "username", "password");

                Independentsoft.Share.Kql.IsEqualTo restriction1 = new Independentsoft.Share.Kql.IsEqualTo(SearchResultPropertyName.FileExtension, "docx");
                Independentsoft.Share.Kql.IsEqualTo restriction2 = new Independentsoft.Share.Kql.IsEqualTo(SearchResultPropertyName.Author, "Admin");
                Independentsoft.Share.Kql.And restriction3 = new Independentsoft.Share.Kql.And(restriction1, restriction2);

                SearchQuery query = new SearchQuery(restriction3);
                query.SelectProperties.Add(SearchResultPropertyName.Title);
                query.SelectProperties.Add(SearchResultPropertyName.Path);
                query.SelectProperties.Add(SearchResultPropertyName.CreatedTime);

                SearchResult searchResult = service.Search(query);

                SimpleDataTable table = searchResult.PrimaryQueryResult.RelevantResult.Table;

                foreach (SimpleDataRow row in table.Rows)
                {
                    foreach (KeyValue cell in row.Cells)
                    {
                        if (cell.Key == SearchResultPropertyName.Title)
                        {
                            Console.WriteLine("Title: " + cell.Value);
                        }
                        else if (cell.Key == SearchResultPropertyName.Path)
                        {
                            Console.WriteLine("Path: " + cell.Value);
                        }
                        else if (cell.Key == SearchResultPropertyName.CreatedTime)
                        {
                            DateTime localTime = DateTime.Parse(cell.Value);
                            Console.WriteLine("CreatedTime: " + localTime);
                        }
                    }
                }

                Console.Read();
            }
            catch (ServiceException ex)
            {
                Console.WriteLine("Error: " + ex.Message);
                Console.WriteLine("Error: " + ex.ErrorCode);
                Console.WriteLine("Error: " + ex.ErrorString);
                Console.WriteLine("Error: " + ex.RequestUrl);
                Console.Read();
            }
            catch (WebException ex)
            {
                Console.WriteLine("Error: " + ex.Message);
                Console.Read();
            }
        }
    }
}

VB example

Imports System
Imports System.Net
Imports Independentsoft.Share

Namespace Sample
    Class Module1
        Shared Sub Main(ByVal args As String())

            Try
                Dim service As New Service("https://independentsoft.sharepoint.com", "username", "password")

                Dim restriction1 As New Independentsoft.Share.Kql.IsEqualTo(SearchResultPropertyName.FileExtension, "docx")
                Dim restriction2 As New Independentsoft.Share.Kql.IsEqualTo(SearchResultPropertyName.Author, "Admin")
                Dim restriction3 As New Independentsoft.Share.Kql.And(restriction1, restriction2)

                Dim query As New SearchQuery(restriction3)
                query.SelectProperties.Add(SearchResultPropertyName.Title)
                query.SelectProperties.Add(SearchResultPropertyName.Path)
                query.SelectProperties.Add(SearchResultPropertyName.CreatedTime)

                Dim searchResult As SearchResult = service.Search(query)

                Dim table As SimpleDataTable = searchResult.PrimaryQueryResult.RelevantResult.Table

                For Each row As SimpleDataRow In table.Rows

                    For Each cell As KeyValue In row.Cells

                        If cell.Key = SearchResultPropertyName.Title Then

                            Console.WriteLine("Title: " + cell.Value)

                        ElseIf cell.Key = SearchResultPropertyName.Path Then

                            Console.WriteLine("Path: " + cell.Value)

                        ElseIf cell.Key = SearchResultPropertyName.CreatedTime Then

                            Dim localTime As DateTime = DateTime.Parse(cell.Value)
                            Console.WriteLine("CreatedTime: " & localTime)

                        End If

                    Next

                Next

                Console.Read()

            Catch ex As ServiceException
                Console.WriteLine("Error: " + ex.Message)
                Console.WriteLine("Error: " + ex.ErrorCode)
                Console.WriteLine("Error: " + ex.ErrorString)
                Console.WriteLine("Error: " + ex.RequestUrl)
                Console.Read()
            Catch ex As WebException
                Console.WriteLine("Error: " + ex.Message)
                Console.Read()
            End Try

        End Sub
    End Class
End Namespace

Independentsoft - any library, any programming language

Share .NET > Tutorial > Search by file extension and author

Need help? Ask our developers: