Aggregating task items using search provider

This walkthrough demonstrates how to configure the Lightning Conductor App Part to rollup all not completed task items, assigned to the person viewing the page, across all site collections using the search rollup engine provider.

If you have any questions please submit them on our web site page: Support Request.

This walkthrough demonstrates the following tasks:

• Selecting the search rollup engine provider.
  
  
• Limiting the App Part to display only my active task items.
  
  
• Select the columns you wish to display in the App Part.
  
  
• Configure how you wish to display the data from the task columns.
  

Prerequisites

You need the following components to complete this walkthrough:

• An Office 365™ tenant.
  
  
• Lightning Conductor app.

If you have not already done so, complete the following steps:

1. Add the Lightning Conductor app to your site.
   
   
2. Add the Lightning Conductor App Part to a page.

Requirements

The Lightning Conductor App Part should be configured to:

1. Display only task items that are not completed throughout the Office 365 tenant and are assigned to the person displaying the page.
   
   
2. The columns to be displayed are (in order): Task Name, Priority, Due Date, % Complete and Last Modified.
   
   
3. Task items are ordered with the oldest due date listed first.
   
   
4. The Priority column values will be conditionally formatted so that the value, (1) High is display as a red font and (2) Normal as green font.
   

*When using the Search Rollup Engine Provider most of the columns a list uses are not automatically displayed on the Configuring Lightning Conductor Columns tab and therefore you will need to use the equivalent Manage Properties. In this walkthrough you will use the managed properties:
    * Priority for the Priority column values.
    * DueDateOWSDATE for the Due Date column values.
    * PercentCompleteOWSNMBR for the % Complete column values.
Unfortunately many managed properties are of type Text, and therefore to achieve some of the requirements it is necessary to manipulate the managed properties using Calculated Columns formulas. Alteratively you could create additional Manage Properties of the required type, yourself or rename one of the unused managed properties using an Alias .

Select the Search Rollup Engine Provider

1. From the Actions menu, select either Configure Lightning Conductor, or if you have enabled multiple views, select Configure view.
   
   
   
   The Configure Lightning Conductor App dialog is displayed.
   
   
2. On the App Part tab, in the Configure Data Source Provider section, select Search Rollup Engine Provider.
   
   

Return only my active task items

1. Click the Data Source tab.
   
   
2. In the Search Query section, select Items matching a content type from the Result source list.
   
   
   
   
3. Modify the contents of the Query Text box so it contains the search query:
   (contentclass:STS_ListItem AssignedTo:{User.Name} PercentCompleteOWSNMBR<>1.00000000000000)
   
   
   
   
4. In the Query Template Variables section, to the right of the ContentTypeId text box, select the ellipses (…).
   
   The Select Value dialog is displayed.
   
   
5. From the Choose content type list, select Task.
   
   
   
   
6. Click Select to save your selection and close the Select Value dialog.
   
   The ContentTypeId text box, contains the value 0×0108*.
   
   

*Tip: When you want to limit the search results to a specific content type, and the Select Value dialog box does not show the required content type, then you can quickly find the content type id by clicking Site content types under Web Designer Galleries on the Site Settings page. Hoover over the content type, for example, Document, then in the browser status bar you will see the code:
javascript:GoToPage('\u002f_layouts/15/ManageContentType.aspx?ctype=0x0101');

Select Columns to display

1. Click the Columns tab.
   
   
2. Click the check boxes to the left of the following columns:
   
   

• Title
  
  
• LastModifiedTime

In the Managed property text box, type PercentCompleteOWSNMBR and then click the green plus icon !{IMAGE-LINK
+displayprof-greenplusicon2010}!



Repeat the above step to add the managed properties.

• 
  
  

Priority

DueDateOWSDATE

Click the check box to the left of the Priority and PercentCompleteOWSNMBR.

At the top right of the Columns section, click the Add calculated column icon.

The Edit calculated column dialog is displayed.

• 
  
  

In the Column name text box, type, Due Date

From the Column type list, select String, if it is not already selected.

In the Expression list select DueDateOWSDATE [String], and then in the Expression append .replace(/[TZ]/g,” “).



Click Save to close the Edit calculated column dialog.

At the top right of the Columns section, click the Add calculated column icon.

The Edit calculated column dialog is displayed.

• 
  
  

In the Column name text box, type, % Complete

From the Column type list, select Integer.

In the Expression list select PercentCompleteOWSNMBR [String], and then in the Expression append *1.



Click Save to close the Edit calculated column dialog.

For the Due Date column, select Descending from the Sorting list.

Drag and drop so the columns are in the order Title, Priority, Due Date, % Complete, LastModifiedTime and PercentCompleteOWSNMBR, as shown in the following screenshot.

Format column data

1. Click the Display tab.
   
   
2. In the Display Format column, format the following columns:
   
   

• % Complete, select Percent.
  
  
• LastModifiedTime, select Short Date.

In the Alias column, type the alias for the following columns:

• 
  
  

Title, type, Task Name.

LastModifiedTime, type, Last Modified.

Clear the Display checkbox for PercentCompleteOWSNMBR.

Click the Formatting icon for the Priority column to display the Configure Conditional Formatting dialog.

• 
  
  

In the Fore Color text box, type, FF0000, select the operation =, and type (1) High.

Click Add Formatting.

In the newly added Apply To Entire Row section, in the Fore Color text box, type, 00FF00.

Expand the newly added section – + to the left of Apply, select the operation =, and type (2) Normal.



Click Save to close the dialog.

Click Save to close the Configure Lightning Conductor App dialog.

Copyright © 2025 Lightning Tools — Powered by