Configuring Microsoft 365 Web Queries for partial name object search

Applies to: Cayosoft Administrator 9.x or later.

Summary: Cayosoft Administrator uses MS Graph API for searching. MS Graph API doesn't support wildcards and 'contains' search, it uses only 'startswith' for the search. Learn more in: Use query parameters - Filter parameter. This article has two examples of configuring Microsoft 365 web queries to return a list of objects by the part of the name using 'contains'. In the first one, in the result grid post-filtering is used. In the second example, changes should be made per web query in design mode.

Configuration

Example 1

1. In the Web Portal, click Web Query.

2. Set Show to All.

3. Search for Objects.

4. In the Name column, type a search value that contains a part of the object name.

Example 2

This configuration can be applied to the following web queries:

1. Users web query

2. Contacts web query

3. Groups web query

4. Groups-Security web query

5. Guest Users web query

6. Teams web query

For example, Team names:

Team1 - Community Services - Public

Team2 - Community Services - Private

We need to configure the Teams web query that will return all Teams with Public or Private in their names.

1. In the Cayosoft Administrator Console, navigate to Teams web query.

2. Open the Other Query settings section.

3. Copy/paste this script to the Initialization Section and replace the Team name search string with your search value:

   Copy

   {if ($MSGraphAdvancedQueries -eq "0")
   {
   $stokens = @("Private","Public")
   $tmp = @()
   $stokens | %{ $stoken = $_; $tmp += [string]::Format('"displayName:{0}"', $s
   $searchStr = [string]::Join(" OR ", $tmp)
   $global:QueryOptions += @{"`$search"=$searchStr}
   }}

4. Set MS Graph advanced queries to Enabled.

5. Enable Design Mode.

6. On the Query tab, open the Pre-processing section.

7. Move the Initialization data command down after the Preparedata command.

   NOTE: If you are using Cayosoft Administrator version 10.1.1 or later, skip this step. It is already included in these versions.

8. Save changes.