Sends output to an interactive table in a separate window.

Syntax

Show-ListView [-PageSize <Int32>] [-Modal] [-ActionData <Object>] [-ViewName <String>] [-ActionsInSession] [-Show <None | SharedExport | Filter | PagingAlways | SharedActions | StatusBar | All>] [-InfoTitle <String>] [-InfoDescription <String>] [-MissingDataMessage <String>] [-Icon <String>] -Data <Object> [-Property <Object[]>] [-Title <String>] [-Width <Int32>] [-Height <Int32>]

Detailed Description

The Show-ListView command sends the output from a command to a grid view window where the output is displayed in an interactive table. Because this command requires a user interface, it does not work in a non-interactive scenarios like within web service calls. You can use the following features of the table to examine your data: -- Sort. To sort the data, click a column header. Click again to toggle from ascending to descending order. -- Quick Filter. Use the "Filter" box at the top of the window to search the text in the table. You can search for text in a particular column, search for literals, and search for multiple words. -- Execute actions on selected items. To execute action on the data from Show-ListView, Ctrl+click the items you want to be included in the action and press the desired action in the "Actions" chunk in the ribbon. -- Export contents of the view in XML, CSV, Json, HTML or Excel file and download that onto the user's computer. The downloaded results will take into account current filter and order of the items.

© 2010-2019 Adam Najmanowicz, Michael West. All rights reserved. Sitecore PowerShell Extensions

Parameters

-PageSize <Int32>

Number of results shown per page.

-Modal <SwitchParameter>

If this parameter is provided Results will show in a new window (in Sitecore 6.x up till Sitecore 7.1) or in a modal overlay (Sitecore 7.2+)

-ActionData <Object>

Additional data what will be passed to the view. All actions that are executed from that view window will have that data accessible to them as $actionData variable.

-ViewName <String>

View signature name - this can be used by action commands to determine whether to show an action or not using the Show/Enable rules.

-ActionsInSession <SwitchParameter>

If this parameter is specified actions will be executed in the same session as the one in which the command is executed.

-Show <ShowListViewFeatures>

Shows UI elements selectively in the results dialog -- All - shows all UI elements automatically - default value -- SharedExport - shows export filters that are not specific to this very -ViewName report (left-most ribbon panel) -- Filter - shows filter panel -- PagingAlways - shows paging when list is shorter than the page specified -- SharedActions - shows actions that are not specific to this very-ViewName report (right-most ribbon panel) -- StatusBar - shows status bar.

-InfoTitle <String>

Title on the panel that appears below the ribbon in the results window.

-InfoDescription <String>

Description that appears on the panel below the ribbon in the results window.

-MissingDataMessage <String>

If no Items were provided for -Data parameter the message provided in this parameter will be shown in the middle of the List View dialog to notify users of the lack of items to display.

-Icon <String>

Icon of the result window. (Shows in the top/left corner and on the Sitecore taskbar).

-Data <Object>

Data to be displayed in the view.

-Property <Object[]>

Specifies the object properties that appear in the display and the order in which they appear. Type one or more property names (separated by commas), or use a hash table to display a calculated property.

The value of the Property parameter can be a new calculated property. To create a calculated, property, use a hash table. Valid keys are: -- Name (or Label) <string> -- Expression <string> or <script block>

-Title <String>

Title of the results window.

-Width <Int32>

Width of the results window. Only applicable when also using the -Modal switch.

-Height <Int32>

Height of the results window. Only applicable when also using the -Modal switch.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

• System.Management.Automation.PSObject

Outputs

The output type is the type of the objects that the cmdlet emits.

• System.String

Notes

Help Author: Adam Najmanowicz, Michael West

Examples

EXAMPLE 1

This command formats information about Sitecore items in a table. The Get-ChildItem command gets objects representing the items. The pipeline operator (|) passes the object to the Show-ListView command. Show-ListView displays the objects in a table.

PS master:\> Get-Item -path master:\* | Show-ListView -Property Name, DisplayName, ProviderPath, TemplateName, Language

EXAMPLE 2

This command formats information about Sitecore items in a table. The Get-ItemReferrer command gets all references of the "Sample Item" template. The pipeline operator (|) passes the object to the Show-ListView command. Show-ListView displays the objects in a table. The Properties are not displaying straight properties but use the Name/Expression scheme to provide a nicely named values that like in the case of languages which are aggregarde form the "Languages" property.

PS master:\> Get-ItemReferrer -path 'master:\templates\Sample\Sample Item' | 
                 Show-ListView -Property `
                     @{Label="Name"; Expression={$_.DisplayName} }, 
                     @{Label="Path"; Expression={$_.Paths.Path} }, 
                     @{Label="Languages"; Expression={$_.Languages | % { $_.Name + ", "} } }

EXAMPLE 3

The following demonstrates the use of a custom object used in the report. Notice that a custom Icon can be set.

$item = Get-Item -Path "master:\content\home\sample item 1"
​
$customItem = [pscustomobject]@{
    "ID"=$Item.ID
    "Icon"=$Item.__Icon
    "DisplayName"=$Item.DisplayName
    "ItemPath"=$Item.ItemPath
    "Version"=$Item.Version
    "Language"=$Item.Language
    "__Updated"=$Item.__Updated
    "__Updated by"=$Item."__Updated by"
}
​
$customItem | Show-ListView

Related Topics

• ​Update-ListView​

• Out-GridView

• Format-Table

• ​Read-Variable​

• ​Show-Alert​

• ​Show-Application​

• ​Show-Confirm​

• ​Show-FieldEditor​

• ​Show-Input​

• ​Show-ModalDialog​

• ​Show-Result​

• ​Show-YesNoCancel​

• ​https://blog.najmanowicz.com/2014/10/25/creating-beautiful-sitecore-reports-easily-with-powershell-extensions/

• ​https://michaellwest.blogspot.com/2014/04/reports-with-sitecore-powershell.html

• ​https://sitecorejunkie.com/2014/05/28/create-a-custom-report-in-sitecore-powershell-extensions/

• ​https://github.com/SitecorePowerShell/Console/