May 19, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Field not returned by enesysField not returned by enesys
Previous Previous
 
Next Next
New Post
 6/22/2009 3:40 PM
 

Some fields are not returned by enseys.

I have the following query:

<?xml version="1.0" encoding="uft-8" ?>
<root xmlns="http://enesyssoftware.com/schemas">
 
<list title="Demandes" relativeSiteUrl="/sites/SA/demande" tableName="Demandes">
<fields>EtatDemande</fields>
<query>
<Where>
        <And>
         <Geq>
            <FieldRef Name='Created' />
            <Value Type='DateTime'>@AfterDate!</Value>
         </Geq>
         <Eq>
            <FieldRef Name='PrioriteDemande' />
            <Value Type='Choice'>3-Haute</Value>
         </Eq>
      </And>
</Where>
<OrderBy>
<FieldRef Ascending="false" Name="Created"/>
</OrderBy>
</query>
</list>
<resultSet>Demandes</resultSet>

 </root>

When i look at the web query enesys generate to get the fields  (GetList() )i can see that sharepoint is returning the Field

HTTP/1.1 200 OK
Date: Mon, 22 Jun 2009 13:26:33 GMT
Server: Microsoft-IIS/6.0
MicrosoftSharePointTeamServices: 12.0.0.6219
X-Powered-By: ASP.NET
X-AspNet-Version: 2.0.50727
Set-Cookie: WSS_KeepSessionAuthenticated=80; path=/
Set-Cookie: MSOWebPartPage_AnonymousAccessCookie=80; expires=Mon, 22-Jun-2009 13:56:33 GMT; path=/
Cache-Control: private, max-age=0
Content-Type: text/xml; charset=utf-8
Content-Length: 51891
 
…..
<Field Type="Lookup" DisplayName="État de la demande" Description="État de la demande" Required="FALSE" List="33eba11e-262f-46b9-91ef-6069ad979ab1" ShowField="Title" UnlimitedLengthInDocumentLibrary="FALSE" Group="CDPQ - Gestion des demandes" ID="{ab5821e7-2ecc-42aa-8765-c46e31327970}" StaticName="EtatDemande" Name="EtatDemande" xmlns="http://schemas.microsoft.com/sharepoint/" Version="1" WebId="f7912367-d29b-4fde-834d-0bf5a5520d93" SourceID="http://schemas.microsoft.com/sharepoint/v3" ColName="int12" RowOrdinal="0"/>…

But the field is never display in visual studio.

I have try with  the 2008 version and i have the same behavior.

Any ideas?

 

 

 

New Post
 6/23/2009 9:18 AM
 

Hi mfilion,

We never encounter such behavior. I suppose that when you execute the query you wrote, you get an exception such as: "Your query does not contain any valid field to display"?

  1. Which version of ERSDE are you using?
  2. If you are using a version >= 3.0, can you use Query Builder to executes the query. (You can import a query in Query Builder by creating a new project, then selecting "Import" in the "Query" menu)
  3. Could you try to make this query with useDisplayName="true" so we can see if the field is correctly returned when using display names, your query would look like this:

<root>
<list title="Demandes" relativeSiteUrl="/sites/SA/demande" tableName="Demandes" useDisplayName="true">
<fields>État de la demande</fields>
<query></query>
</list>
</root>

Thank you,

Regards,
Marien Monnier
Enesys

New Post
 6/23/2009 6:55 PM
 

Thanks for the quick response

yes this is the message i am getting (with the 2008 version, with the version before i have no error message the field is just not showed)

1)we have the Enesys 2008 version in test and the previous version in production

 

2) I have the same error in the query builder. I can see the fiels in the list fields in the designer but it is not returned when the query is run

3)I have the same probleme using the query with the useDisplayName="true"  :-(

any more ideas?

 

 

New Post
 6/23/2009 7:07 PM
 

Hi mfilion,

Could you send us to our support address (available in the last page of the documentation) the list template (*.stp) of your list, so we can do internal tests to see what is going on.

Regards,
Marien Monnier
Enesys

New Post
 6/23/2009 10:24 PM
 

As a matter of fact, we have already encountered this problem with lookup fields installed through the feature provided here:

http://www.codeplex.com/SP2007LookupFields

It happened that the problem was due to the namespace encoded in the field’s schema. It is conflicting with the schema returned from the web service. By removing the namespace in the field definition solved the problem.

Obviously we could possibly completely discard any namespace in our approach either by XML Querying using local-name or by recapturing the xml node. However, I do not think this is a good idea to specify an explicit namespace the field level.

Could it be anything related?

We will anyway have a look at your list template.

Regards,


Frederic LATOUR
ENESYS
New Post
 6/25/2009 5:32 PM
 

I think you are perfectly right.

That would explain why the xml parser would not return does fields, and for that matter not see in the result.

The namespace that you see, is added automatically by the Microsoft solution generator when you generate field definition over an existing list.

I will try removing the namespace for a try.

New Post
 7/3/2009 5:25 PM
 

Just to let you know, we removed the xml Namespace on the field definition and it worked.

Thanks for your support.

Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Field not returned by enesysField not returned by enesys

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement