Ask a question

Search Forums:

• Search CRM Development Forum
• Search All Dynamics Forums
• Search All Microsoft Forums

 

Creating a Contact View

• Friday, November 06, 2009 2:57 PMsburtonctr

   
  

  0

  Sign In to Vote
  I am trying to create a view using the Microsoft.Crm.SdkTypeProxy.CrmService library.  I have been successful in creating the view, however it does not show all the columns defined in the userquery.columnsetxml
  
  

  public void CreateContactView( string name ) {
  
      EntitySchema entitySchema = SchemaManager.GetEntitySchema( "myxmlfile.xml" );
  
      userquery query = new userquery( );
      query.name = name;
      query.columnsetxml = entitySchema.XmlColumnSetSchema;
  
      query.querytype = new CrmNumber( 0 );
      query.returnedtypecode = EntityName.contact.ToString( );
      query.fetchxml = entitySchema.XmlFetchSchema;
  
      TargetCreateUserQuery target = new TargetCreateUserQuery() { UserQuery = query };
      CreateRequest request = new CreateRequest( ) { Target = target };
      CreateResponse response = (CreateResponse)_service.Execute( request );
  
      PublishXmlRequest publishRequest = new PublishXmlRequest( ) { ParameterXml = "<importexportxml><entities><entity>contact</entity></entities><nodes /><securityroles /><settings /><workflows /></importexportxml>" };
      PublishXmlResponse publishResponse = (PublishXmlResponse)_service.Execute( publishRequest );    
  }
  

  The query.fetchxml = entitySchema.XmlFetchSchema looks like this:
  

  <fetch mapping="logical" count="50" version="1.0">
      <entity name="contact">
          <attribute name="donotemail" />
          <attribute name="donotphone" />
          <attribute name="emailaddress1" />
          <attribute name="firstname" />
          <attribute name="fullname" />
          <attribute name="lastname" />
          <attribute name="mobilephone" />
          <attribute name="modifiedon" />
          <attribute name="ryland_preferredphonetype" />
          <attribute name="telephone1" />
          <attribute name="telephone2" />
          <filter>
              <condition attribute="donotphone" operator="eq" value="0" />
          </filter>
      </entity>
  </fetch>
  

  The query.columnsetxml = entitySchema.XmlColumnSetSchema looks like this:
  
  

  <columnset>
      <column>donotemail</column>
      <column>donotphone</column>
      <column>emailaddress1</column>
      <column>firstname</column>
      <column>fullname</column>
      <column>lastname</column>
      <column>mobilephone</column>
      <column>modifiedon</column>
      <column>ryland_preferredphonetype</column>
      <column>telephone1</column>
      <column>telephone2</column>
  </columnset>
      
  

  The view is being created in Contact / MyViews which is correct, but the only column being displayed in the "Full Name".  Any ideas of what I am doing wrong?  Thanks in advance.
  • Reply
  • Quote