none
activity view XML full adapter error

    Question

  • Whenever I make any changes to this XML file for some reason I get the the full adapter error whenever I try to add more criteria...like created date. Is there something I can do to correct this?

    <ManagementPack ContentReadable="true" SchemaVersion="1.1" OriginalSchemaVersion="1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
     
      <Manifest>
     
        <Identity>
     
          <ID>ActivityManagement.Views</ID>
     
          <Version>7.5.1561.0</Version>
     
        </Identity>
     
        <Name>Activity Management Views</Name>
     
        <References>
     
          <Reference Alias="System">
     
            <ID>System.Library</ID>
     
            <Version>7.5.1561.0</Version>
     
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
     
          </Reference>
     
          <Reference Alias="WorkItem">
     
            <ID>System.WorkItem.Library</ID>
     
            <Version>7.5.1561.0</Version>
     
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
     
          </Reference>
     
          <Reference Alias="CoreChange">
     
            <ID>System.WorkItem.ChangeRequest.Library</ID>
     
            <Version>7.5.1561.0</Version>
     
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
     
          </Reference>
     
          <Reference Alias="Activity">
     
            <ID>ServiceManager.ActivityManagement.Library</ID>
     
            <Version>7.5.1561.0</Version>
     
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
     
          </Reference>
     
          <Reference Alias="CoreActivity">
     
            <ID>System.WorkItem.Activity.Library</ID>
     
            <Version>7.5.1561.0</Version>
     
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
     
          </Reference>
     
          <Reference Alias="SMConsole">
     
            <ID>Microsoft.EnterpriseManagement.ServiceManager.UI.Console</ID>
     
            <Version>7.5.1561.0</Version>
     
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
     
          </Reference>
     
        </References>
     
      </Manifest>
     
      <TypeDefinitions>
     
        <EntityTypes>
     
          <TypeProjections>
     
            <TypeProjection ID="System.WorkItem.ActivityChangeRequestViewProjection" Accessibility="Public" Type="CoreActivity!System.WorkItem.Activity">
     
              <Component Alias="ActivityAssignedTo" Path="$Target/Path[Relationship='WorkItem!System.WorkItemAssignedToUser']$" />
     
              <Component Alias="ParentWorkItem" Path="$Target/Path[Relationship='CoreActivity!System.WorkItemContainsActivity' SeedRole='Target' TypeConstraint='CoreChange!System.WorkItem.ChangeRequest']$" />
     
            </TypeProjection>
     
          </TypeProjections>
     
        </EntityTypes>
     
      </TypeDefinitions>
     
      <Categories>
     
        <Category ID="ActivityManagementViewsMPSolutionCategory" Value="Activity!Microsoft.EnterpriseManagement.ServiceManager.ManagementPack.Solution.ActivityManagement">
     
          <ManagementPackName>ActivityManagement.Views</ManagementPackName>
     
          <ManagementPackVersion>7.5.1561.0</ManagementPackVersion>
     
        </Category>
     
        <Category ID="ActivityManagement.Categories.AllActivitiesinChangeRequest" Target="ActivityManagement.Views.AllActivitiesinChangeRequest" Value="SMConsole!Microsoft.EnterpriseManagement.ServiceManager.UI.Console.ViewTasks" />
     
      </Categories>
     
      <Presentation>
     
        <Views>
     
          <View ID="ActivityManagement.Views.AllActivitiesinChangeRequest" Accessibility="Public" Enabled="true" Target="CoreActivity!System.WorkItem.Activity" TypeID="SMConsole!GridViewType" Visible="true">
     
            <Category>NotUsed</Category>
     
            <Data>
     
              <Adapters>
     
                <Adapter AdapterName="dataportal:EnterpriseManagementObjectProjectionAdapter">
     
                  <AdapterAssembly>Microsoft.EnterpriseManagement.UI.SdkDataAccess</AdapterAssembly>
     
                  <AdapterType>Microsoft.EnterpriseManagement.UI.SdkDataAccess.DataAdapters.EnterpriseManagementObjectProjectionAdapter</AdapterType>
     
                </Adapter>
     
                <Adapter AdapterName="viewframework://Adapters/AdvancedList">
     
                  <AdapterAssembly>Microsoft.EnterpriseManagement.UI.ViewFramework</AdapterAssembly>
     
                  <AdapterType>Microsoft.EnterpriseManagement.UI.ViewFramework.AdvancedListSupportAdapter</AdapterType>
     
                </Adapter>
     
              </Adapters>
     
              <ItemsSource>
     
                <AdvancedListSupportClass DataTypeName="" AdapterName="viewframework://Adapters/AdvancedList" FullUpdateAdapter="dataportal:EnterpriseManagementObjectProjectionAdapter" DataSource="mom:ManagementGroup" IsRecurring="true" RecurrenceFrequency="{x:Static s:Int32.MaxValue}" FullUpdateFrequency="1" Streaming="true" xmlns="clr-namespace:Microsoft.EnterpriseManagement.UI.ViewFramework;assembly=Microsoft.EnterpriseManagement.UI.ViewFramework" xmlns:av="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:s="clr-namespace:System;assembly=mscorlib">
     
                  <AdvancedListSupportClass.Parameters>
     
                    <QueryParameter Parameter="TypeProjectionId" Value="$MPElement[Name='System.WorkItem.ActivityChangeRequestViewProjection']$" />
     
                  </AdvancedListSupportClass.Parameters>
     
                </AdvancedListSupportClass>
     
              </ItemsSource>
     
              <Criteria>
     
                <QueryCriteria Adapter="omsdk://Adapters/Criteria" xmlns="http://tempuri.org/Criteria.xsd">
     
                  <Criteria>
     
                    <FreeformCriteria>
     
                      <Freeform>
     
                        <Criteria xmlns="http://Microsoft.EnterpriseManagement.Core.Criteria/">
     
                          <Expression>
     
                            <SimpleExpression>
     
                              <ValueExpressionLeft>
     
                                <Property>$Context/Path[Relationship='CoreActivity!System.WorkItemContainsActivity' SeedRole='Target' TypeConstraint='CoreChange!System.WorkItem.ChangeRequest']/Property[Type='CoreChange!System.WorkItem.ChangeRequest']/Status$</Property>
     
                              </ValueExpressionLeft>
     
                              <Operator>NotEqual</Operator>
     
                              <ValueExpressionRight>
     
                                <Value>$MPElement[Name="CoreChange!ChangeStatusEnum.Closed"]$</Value>
     
                              </ValueExpressionRight>
     
                            </SimpleExpression>
     
                          </Expression>
     
                        </Criteria>
     
                      </Freeform>
     
                    </FreeformCriteria>
     
                  </Criteria>
     
                </QueryCriteria>
     
              </Criteria>
     
            </Data>
     
            <Presentation>
     
              <Columns>
     
                <mux:ColumnCollection xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:mux="http://schemas.microsoft.com/SystemCenter/Common/UI/Views/GridView" xmlns:s="clr-namespace:System;assembly=mscorlib" xmlns:datebinding="clr-namespace:Microsoft.EnterpriseManagement.UI.SdkDataAccess.Common;assembly=Microsoft.EnterpriseManagement.UI.SdkDataAccess">
     
                  <mux:Column Name="id" DisplayMemberBinding="{Binding Path=Id}" Width="100" DisplayName="Header_Id" Property="Id$ReturnValueAsBigInt$" DataType="s:Int32" />
     
                  <mux:Column Name="title" DisplayMemberBinding="{Binding Path=Title}" Width="200" DisplayName="Header_Title" Property="Title" DataType="s:String" />
     
                  <mux:Column Name="parentDisplayName" DisplayMemberBinding="{Binding Path=ParentWorkItem/DisplayName}" Width="200" DisplayName="Header_Parent_DisplayName" Property="ParentWorkItem/DisplayName" DataType="s:String" />
     
                  <mux:Column Name="parentStatus" DisplayMemberBinding="{Binding Path=ParentWorkItem/Status.DisplayName}" Width="100" DisplayName="Header_Parent_Status" Property="ParentWorkItem/Status.DisplayName" DataType="s:String" />
     
                  <mux:Column Name="aDisplayName" DisplayMemberBinding="{Binding Path=ActivityAssignedTo.DisplayName}" Width="100" DisplayName="Header_Assigned_To" Property="ActivityAssignedTo.DisplayName" DataType="s:String" />
     
                  <mux:Column Name="statusDisplayName" DisplayMemberBinding="{Binding Path=Status.DisplayName}" Width="100" DisplayName="Header_Status" Property="Status.Ordinal" DataType="s:Double" />
     
                  <mux:Column Name="stageDisplayName" DisplayMemberBinding="{Binding Path=Stage.DisplayName}" Width="100" DisplayName="Header_Stage" Property="Stage.Ordinal" DataType="s:Double" />
     
                </mux:ColumnCollection>
     
              </Columns>
     
              <ViewStrings>
     
                <ViewString ID="Header_Id">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Id"]$</ViewString>
     
                <ViewString ID="Header_Title">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Title"]$</ViewString>
     
                <ViewString ID="Header_Parent_DisplayName">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_DisplayName"]$</ViewString>
     
                <ViewString ID="Header_Parent_Status">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_Status"]$</ViewString>
     
                <ViewString ID="Header_Assigned_To">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Assigned_To"]$</ViewString>
     
                <ViewString ID="Header_Status">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Status"]$</ViewString>
     
                <ViewString ID="Header_Stage">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Stage"]$</ViewString>
     
              </ViewStrings>
     
            </Presentation>
     
          </View>
     
        </Views>
     
        <FolderItems>
     
          <FolderItem ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest" ID="ActivityManagement.FolderItems.AllActivitiesinChangeRequest" Folder="Activity!ServiceManager.Console.ActivityManagement" />
     
        </FolderItems>
     
        <ImageReferences>
     
          <ImageReference ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest" ImageID="Activity!ActivityImage16x16" />
     
        </ImageReferences>
     
        <StringResources>
     
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Id" />
     
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Stage" />
     
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Status" />
     
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Title" />
     
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Assigned_To" />
     
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_DisplayName" />
     
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_Status" />
     
        </StringResources>
     
      </Presentation>
     
      <LanguagePacks>
     
        <LanguagePack ID="ENU" IsDefault="true">
     
          <DisplayStrings>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest">
     
              <Name>All Activities in Change Request</Name>
     
              <Description>All Activities in Change Request</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="System.WorkItem.ActivityChangeRequestViewProjection">
     
              <Name>Activity (typical)</Name>
     
              <Description>Defines the properties of activities typically used in views</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views">
     
              <Name>Activity Management Views Library</Name>
     
              <Description>Activity Management Views Library</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Id">
     
              <Name>ID</Name>
     
              <Description>ID</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Stage">
     
              <Name>Stage</Name>
     
              <Description>Stage</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Status">
     
              <Name>Status</Name>
     
              <Description>Status</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Title">
     
              <Name>Title</Name>
     
              <Description>Title</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Assigned_To">
     
              <Name>Assigned To</Name>
     
              <Description>Assigned To</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_DisplayName">
     
              <Name>Change Request</Name>
     
              <Description>Change Request</Description>
     
            </DisplayString>
     
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_Status">
     
              <Name>Change Request Status</Name>
     
              <Description>Change Request Status</Description>
     
            </DisplayString>
     
          </DisplayStrings>
     
        </LanguagePack>
     
      </LanguagePacks>
     
    </ManagementPack>
    

    Date: 2/12/2013 4:14:24 PM
    Application: Service Manager Console
    Application Version: 7.5.1561.116
    Severity: Error
    Message: An error occurred while loading the items.

    Microsoft.EnterpriseManagement.UI.ViewFramework.AdvancedListSupportException: The Full adapter threw an exception. See the FullUpdate property to see the exception.
       at Microsoft.EnterpriseManagement.UI.ViewFramework.AdvancedListSupportAdapter.DoAction(DataQueryBase query, IList`1 dataSources, IDictionary`2 parameters, IList`1 inputs, String outputCollectionName)
       at Microsoft.EnterpriseManagement.UI.DataModel.QueryQueue.StartExecuteQuery(Object sender, ConsoleJobEventArgs e)
       at Microsoft.EnterpriseManagement.ServiceManager.UI.Console.ConsoleJobExceptionHandler.ExecuteJob(IComponent component, EventHandler`1 job, Object sender, ConsoleJobEventArgs args)



    Help

    Tuesday, February 12, 2013 10:17 PM

All replies

  • Your view works perfectly for me but I see your are using UR3 and I am on SP1 which might make a difference. Does it throw the exception every time, for any console user? How about an admin?

    Or is does this problem litterally only happen after you make changes? If so, please let me know exactly what change you made and I will test...


    Rob Ford scsmnz.net
    Cireson www.cireson.com
    For a free SCSM 2012 Auto-Close app click here


    Thursday, February 14, 2013 7:57 PM
  • Sorry, I mis-read. I see what you mean, adding created date from GUI causes the error. I will take a quick look for you...

    Rob Ford scsmnz.net
    Cireson www.cireson.com
    For a free SCSM 2012 Auto-Close app click here

    Thursday, February 14, 2013 8:02 PM
  • Thanks Rob.

    Help

    Thursday, February 14, 2013 8:21 PM
  • I worked it out for you. The GUI does not understand the custom criteria and breaks it if you save the view from the console.

    After you make changes, export the MP and reset the entire Criteria block back to this:

     <Criteria>
                <QueryCriteria Adapter="omsdk://Adapters/Criteria" xmlns="http://tempuri.org/Criteria.xsd">
                  <Criteria>
                    <FreeformCriteria>
                      <Freeform>
                        <Criteria xmlns="http://Microsoft.EnterpriseManagement.Core.Criteria/">
                          <Expression>
                            <SimpleExpression>
                              <ValueExpressionLeft>
                                <Property>$Context/Path[Relationship='CoreActivity!System.WorkItemContainsActivity' SeedRole='Target' TypeConstraint='CoreChange!System.WorkItem.ChangeRequest']/Property[Type='CoreChange!System.WorkItem.ChangeRequest']/Status$</Property>
                              </ValueExpressionLeft>
                              <Operator>NotEqual</Operator>
                              <ValueExpressionRight>
                                <Value>$MPElement[Name="CoreChange!ChangeStatusEnum.Closed"]$</Value>
                              </ValueExpressionRight>
                            </SimpleExpression>
                          </Expression>
                        </Criteria>
                      </Freeform>
                    </FreeformCriteria>
                  </Criteria>
                </QueryCriteria>
              </Criteria>
    Reimport and the view will work ok (probably after a console restart).

    Rob Ford scsmnz.net
    Cireson www.cireson.com
    For a free SCSM 2012 Auto-Close app click here



    Thursday, February 14, 2013 9:52 PM
  • Ok it's weird cause now it stripped out after the error a few of the options like change requests from the XML file.

    So now it has fewer options after adding the date > getting the error > Exporting it out > making the change you requested > Importing it back in.

    *** Are those the correct steps?  Just want to make sure ****

    I then tried adding the date to the new view and it gave me a similar error:

    Date: 2/14/2013 4:16:04 PM
    Application: Service Manager Console
    Application Version: 7.5.1561.116
    Severity: Error
    Message: An error occurred while loading the items.

    Microsoft.EnterpriseManagement.UI.ViewFramework.AdvancedListSupportException: The Full adapter threw an exception. See the FullUpdate property to see the exception.
       at Microsoft.EnterpriseManagement.UI.ViewFramework.AdvancedListSupportAdapter.DoAction(DataQueryBase query, IList`1 dataSources, IDictionary`2 parameters, IList`1 inputs, String outputCollectionName)
       at Microsoft.EnterpriseManagement.UI.DataModel.QueryQueue.StartExecuteQuery(Object sender, ConsoleJobEventArgs e)
       at Microsoft.EnterpriseManagement.ServiceManager.UI.Console.ConsoleJobExceptionHandler.ExecuteJob(IComponent component, EventHandler`1 job, Object sender, ConsoleJobEventArgs args)


    Help

    Thursday, February 14, 2013 10:21 PM
  • Or do I make the change in the exported XML file and then also update the criteria.

    Thanks


    Help

    Thursday, February 14, 2013 10:23 PM
  • Add your columns in the console and export the Management Pack. In the XML, replace the criteria and reimport. If you edit the view in the console, even make no changes, and click OK, it will break again.


    Rob Ford scsmnz.net
    Cireson www.cireson.com
    For a free SCSM 2012 Auto-Close app click here

    Thursday, February 14, 2013 10:47 PM
  • P.S. The MP category is also "wrong" is this MP...

    Here is my working one with Area and Created Date added:;

    <ManagementPack ContentReadable="true" SchemaVersion="2.0" OriginalSchemaVersion="1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
      <Manifest>
        <Identity>
          <ID>ActivityManagement.Views</ID>
          <Version>7.5.1561.0</Version>
        </Identity>
        <Name>Activity Management Views</Name>
        <References>
          <Reference Alias="SMConsole">
            <ID>Microsoft.EnterpriseManagement.ServiceManager.UI.Console</ID>
            <Version>7.5.2905.0</Version>
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
          </Reference>
          <Reference Alias="WorkItem">
            <ID>System.WorkItem.Library</ID>
            <Version>7.5.2905.0</Version>
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
          </Reference>
          <Reference Alias="CoreChange">
            <ID>System.WorkItem.ChangeRequest.Library</ID>
            <Version>7.5.2905.0</Version>
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
          </Reference>
          <Reference Alias="CoreActivity">
            <ID>System.WorkItem.Activity.Library</ID>
            <Version>7.5.2905.0</Version>
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
          </Reference>
          <Reference Alias="Activity">
            <ID>ServiceManager.ActivityManagement.Library</ID>
            <Version>7.5.2905.0</Version>
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
          </Reference>
          <Reference Alias="System">
            <ID>System.Library</ID>
            <Version>7.5.8501.0</Version>
            <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
          </Reference>
        </References>
      </Manifest>
      <TypeDefinitions>
        <EntityTypes>
          <TypeProjections>
            <TypeProjection ID="System.WorkItem.ActivityChangeRequestViewProjection" Accessibility="Public" Type="CoreActivity!System.WorkItem.Activity">
              <Component Path="$Target/Path[Relationship='WorkItem!System.WorkItemAssignedToUser']$" Alias="ActivityAssignedTo" />
              <Component Path="$Target/Path[Relationship='CoreActivity!System.WorkItemContainsActivity' SeedRole='Target' TypeConstraint='CoreChange!System.WorkItem.ChangeRequest']$" Alias="ParentWorkItem" />
            </TypeProjection>
          </TypeProjections>
        </EntityTypes>
      </TypeDefinitions>
      <Categories>
        <Category ID="ActivityManagementViewsMPSolutionCategory" Value="SMConsole!Microsoft.EnterpriseManagement.ServiceManager.ManagementPack">
          <ManagementPackName>ActivityManagement.Views</ManagementPackName>
          <ManagementPackVersion>7.5.1561.0</ManagementPackVersion>
        </Category>
        <Category ID="ActivityManagement.Categories.AllActivitiesinChangeRequest" Target="ActivityManagement.Views.AllActivitiesinChangeRequest" Value="SMConsole!Microsoft.EnterpriseManagement.ServiceManager.UI.Console.ViewTasks" />
      </Categories>
      <Presentation>
        <Views>
          <View ID="ActivityManagement.Views.AllActivitiesinChangeRequest" Accessibility="Public" Enabled="true" Target="CoreActivity!System.WorkItem.Activity" TypeID="SMConsole!GridViewType" Visible="true">
            <Category>NotUsed</Category>
            <Data>
              <Adapters>
                <Adapter AdapterName="dataportal:EnterpriseManagementObjectProjectionAdapter">
                  <AdapterAssembly>Microsoft.EnterpriseManagement.UI.SdkDataAccess</AdapterAssembly>
                  <AdapterType>Microsoft.EnterpriseManagement.UI.SdkDataAccess.DataAdapters.EnterpriseManagementObjectProjectionAdapter</AdapterType>
                </Adapter>
                <Adapter AdapterName="viewframework://Adapters/AdvancedList">
                  <AdapterAssembly>Microsoft.EnterpriseManagement.UI.ViewFramework</AdapterAssembly>
                  <AdapterType>Microsoft.EnterpriseManagement.UI.ViewFramework.AdvancedListSupportAdapter</AdapterType>
                </Adapter>
                <Adapter AdapterName="omsdk://Adapters/Criteria">
                  <AdapterAssembly>Microsoft.EnterpriseManagement.UI.SdkDataAccess</AdapterAssembly>
                  <AdapterType>Microsoft.EnterpriseManagement.UI.SdkDataAccess.DataAdapters.SdkCriteriaAdapter</AdapterType>
                </Adapter>
              </Adapters>
              <ItemsSource>
                <AdvancedListSupportClass DataTypeName="" AdapterName="viewframework://Adapters/AdvancedList" FullUpdateAdapter="dataportal:EnterpriseManagementObjectProjectionAdapter" DataSource="mom:ManagementGroup" IsRecurring="true" RecurrenceFrequency="{x:Static s:Int32.MaxValue}" FullUpdateFrequency="1" Streaming="true" xmlns="clr-namespace:Microsoft.EnterpriseManagement.UI.ViewFramework;assembly=Microsoft.EnterpriseManagement.UI.ViewFramework" xmlns:av="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:s="clr-namespace:System;assembly=mscorlib">
                  <AdvancedListSupportClass.Parameters>
                    <QueryParameter Parameter="TypeProjectionId" Value="$MPElement[Name='System.WorkItem.ActivityChangeRequestViewProjection']$" />
                  </AdvancedListSupportClass.Parameters>
                </AdvancedListSupportClass>
              </ItemsSource>
              <Criteria>
                <QueryCriteria Adapter="omsdk://Adapters/Criteria" xmlns="http://tempuri.org/Criteria.xsd">
                  <Criteria>
                    <FreeformCriteria>
                      <Freeform>
                        <Criteria xmlns="http://Microsoft.EnterpriseManagement.Core.Criteria/">
                          <Expression>
                            <SimpleExpression>
                              <ValueExpressionLeft>
                                <Property>$Context/Path[Relationship='CoreActivity!System.WorkItemContainsActivity' SeedRole='Target' TypeConstraint='CoreChange!System.WorkItem.ChangeRequest']/Property[Type='CoreChange!System.WorkItem.ChangeRequest']/Status$</Property>
                              </ValueExpressionLeft>
                              <Operator>NotEqual</Operator>
                              <ValueExpressionRight>
                                <Value>$MPElement[Name="CoreChange!ChangeStatusEnum.Closed"]$</Value>
                              </ValueExpressionRight>
                            </SimpleExpression>
                          </Expression>
                        </Criteria>
                      </Freeform>
                    </FreeformCriteria>
                  </Criteria>
                </QueryCriteria>
              </Criteria>
            </Data>
            <Presentation>
              <Columns>
                <mux:ColumnCollection xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:mux="http://schemas.microsoft.com/SystemCenter/Common/UI/Views/GridView" xmlns:s="clr-namespace:System;assembly=mscorlib" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:datebinding="clr-namespace:Microsoft.EnterpriseManagement.UI.Extensions;assembly=Microsoft.EnterpriseManagement.UI.Extensions" xmlns:data="clr-namespace:Microsoft.EnterpriseManagement.UI.Extensions;assembly=Microsoft.EnterpriseManagement.UI.Extensions" xmlns:appCommon="clr-namespace:Microsoft.EnterpriseManagement.ServiceManager.Application.Common;assembly=Microsoft.EnterpriseManagement.ServiceManager.Application.Common" xmlns:toolbox="clr-namespace:Microsoft.EnterpriseManagement.UI.WpfToolbox;assembly=Microsoft.EnterpriseManagement.UI.FormsInfra" xmlns:slaBinding="clr-namespace:Microsoft.EnterpriseManagement.ServiceManager.SLA.Common;assembly=Microsoft.EnterpriseManagement.ServiceManager.SLA.Common">
                  <mux:Column Name="id" DisplayMemberBinding="{Binding Path=Id}" Width="100" DisplayName="Header_Id" Property="Id$ReturnValueAsBigInt$" DataType="s:Int32" />
                  <mux:Column Name="title" DisplayMemberBinding="{Binding Path=Title}" Width="200" DisplayName="Header_Title" Property="Title" DataType="s:String" />
                  <mux:Column Name="aDisplayName" DisplayMemberBinding="{Binding Path=ActivityAssignedTo.DisplayName}" Width="100" DisplayName="Header_Assigned_To" Property="ActivityAssignedTo.DisplayName" DataType="s:String" />
                  <mux:Column Name="statusDisplayName" DisplayMemberBinding="{Binding Path=Status.DisplayName}" Width="100" DisplayName="Header_Status" Property="Status.Ordinal" DataType="s:Double" />
                  <mux:Column Name="stageDisplayName" DisplayMemberBinding="{Binding Path=Stage.DisplayName}" Width="100" DisplayName="Header_Stage" Property="Stage.Ordinal" DataType="s:Double" />
                  <mux:Column Name="AreaDisplayName" DisplayMemberBinding="{Binding Path=Area.DisplayName}" Width="100" DisplayName="Header_Area" Property="Area.Ordinal" DataType="s:Double" />
                  <mux:Column Name="CreatedDate" DisplayMemberBinding="{datebinding:DateBinding Path=CreatedDate, Mode=OneWay}" Width="100" DisplayName="Header_CreatedDate" Property="CreatedDate" DataType="s:DateTime" />
                </mux:ColumnCollection>
              </Columns>
              <AdditonalProperties />
              <ViewStrings>
                <ViewString ID="Header_Id">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Id"]$</ViewString>
                <ViewString ID="Header_Title">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Title"]$</ViewString>
                <ViewString ID="Header_Assigned_To">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Assigned_To"]$</ViewString>
                <ViewString ID="Header_Status">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Status"]$</ViewString>
                <ViewString ID="Header_Stage">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Stage"]$</ViewString>
                <ViewString ID="Header_Area">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Area"]$</ViewString>
                <ViewString ID="Header_CreatedDate">$MPElement[Name="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_CreatedDate"]$</ViewString>
              </ViewStrings>
            </Presentation>
          </View>
        </Views>
        <FolderItems>
          <FolderItem ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest" ID="ActivityManagement.FolderItems.AllActivitiesinChangeRequest" Folder="Activity!ServiceManager.Console.ActivityManagement" />
        </FolderItems>
        <ImageReferences>
          <ImageReference ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest" ImageID="Activity!ActivityImage16x16" />
        </ImageReferences>
        <StringResources>
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Id" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Stage" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Status" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Area" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Title" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_CreatedDate" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Assigned_To" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_DisplayName" />
          <StringResource ID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_Status" />
        </StringResources>
      </Presentation>
      <LanguagePacks>
        <LanguagePack ID="ENU" IsDefault="true">
          <DisplayStrings>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest">
              <Name>All Activities in Change Request</Name>
              <Description>All Activities in Change Request</Description>
            </DisplayString>
            <DisplayString ElementID="System.WorkItem.ActivityChangeRequestViewProjection">
              <Name>Activity (typical)</Name>
              <Description>Defines the properties of activities typically used in views</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views">
              <Name>Activity Management Views Library</Name>
              <Description>Activity Management Views Library</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Id">
              <Name>ID</Name>
              <Description>ID</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Stage">
              <Name>Stage</Name>
              <Description>Stage</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Area">
              <Name>Area</Name>
              <Description>Area</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_CreatedDate">
              <Name>CreatedDate</Name>
              <Description>CreatedDate</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Status">
              <Name>Status</Name>
              <Description>Status</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Title">
              <Name>Title</Name>
              <Description>Title</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Assigned_To">
              <Name>Assigned To</Name>
              <Description>Assigned To</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_DisplayName">
              <Name>Change Request</Name>
              <Description>Change Request</Description>
            </DisplayString>
            <DisplayString ElementID="ActivityManagement.Views.AllActivitiesinChangeRequest.Header_Parent_Status">
              <Name>Change Request Status</Name>
              <Description>Change Request Status</Description>
            </DisplayString>
          </DisplayStrings>
        </LanguagePack>
      </LanguagePacks>
    </ManagementPack>


    Rob Ford scsmnz.net
    Cireson www.cireson.com
    For a free SCSM 2012 Auto-Close app click here

    Thursday, February 14, 2013 10:49 PM
  • Could you try adding Criteria so it only show 2013....I see you added the columns but I am adding criteria....does that work for you? I will try your mp and see if I can do it as well.

    Thanks


    Help

    Thursday, February 14, 2013 11:27 PM
  • Ok tried yours and it works but when I add criteria it gives me the full adapter error.

    Just weird


    Help

    Friday, February 15, 2013 2:58 PM
  • Ok so not sure why but when I remove the closed criteria and tried adding the date range criteria and I get the full adapter error. I remove the date range criteria and got all the Change Request created.  I added the does not equal = closed criteria(contains activity) and the view works just fine.

    Not really good at reading the XML but am I missing something there to be able to add more criteria?


    Help

    Friday, February 15, 2013 4:00 PM
  • You need to use an <And> block, see here for an example:

    http://scsmnz.net/how-to-get-all-the-review-activities-for-a-given-user-using-the-sdk/


    Rob Ford scsmnz.net
    Cireson www.cireson.com
    For a free SCSM 2012 Auto-Close app click here

    Saturday, February 16, 2013 12:57 AM
  • Check the last comment I left here:

    http://blogs.technet.com/b/servicemanager/archive/2010/03/04/create-a-view-of-all-activities-that-are-a-part-of-a-change-request-and-see-the-change-request-information-in-the-view-columns.aspx#3552866

    In summary, you can only use properties from the class referenced on the relationship, but no property from the parent or extensions of that class.

    Saturday, February 16, 2013 2:07 AM
  • German - I don't see any comments on that website. Just letting you know.

    Help

    Tuesday, February 26, 2013 5:14 PM