SP0099: Unsupported query expression detected.

Mar 14, 2008 at 8:19 AM
In my "Tasks" list in Sharepoint I have specified serveral custom columns. They all get mapped correctly in the SPML but once i try to query against it i get "SP0099: Unsupported query expression detected.". If I remove the WHERE against the column and simply enumerate the results and print out the column value i get nothing, the value is nothing...although in sharepoint it does have a value.

I am running:
MOSS 2007
VS2008 (project targetted at 3.5)

The column is mapped like this in my SPML:
<Field Name="Sx002dOrder" DisplayName="S-Order" Type="Text" Description="Serviceorder" Id="92219223-79d9-46d7-99e9-8811e0ab41c8" />

Thankful for any help! =)
Mar 14, 2008 at 2:00 PM
Please, attach some detailed information regarding your custom field. SchemaXml would be nice - like this: <Field ID="{038D1503-4629-40f6-ADAF-B47D1AB2D4FE}" Name="Company" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Company" Group="Core Contact and Calendar Columns" DisplayName="Company" Type="Text" />.
Mar 17, 2008 at 7:38 AM

smartin wrote:
Please, attach some detailed information regarding your custom field. SchemaXml would be nice - like this: <Field ID="{038D1503-4629-40f6-ADAF-B47D1AB2D4FE}" Name="Company" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Company" Group="Core Contact and Calendar Columns" DisplayName="Company" Type="Text" />.


Ok, but how do I get the SchemaXML of the field out of sharepoint. I have looked in the database but cannot find where the fields are stored.
Thanks!
Mar 17, 2008 at 9:48 AM
You can use SharePoint Explorer http://blog.mondosoft.com/ontolica/archive/2007/02/15/SharePoint-Explorer-for-WSS3.aspx
Mar 17, 2008 at 11:45 AM
Edited Mar 17, 2008 at 11:47 AM

smartin wrote:
You can use SharePoint Explorer http://blog.mondosoft.com/ontolica/archive/2007/02/15/SharePoint-Explorer-for-WSS3.aspx


Thank you very much! This looks like a great tool, awesome!. So here's my SchemaXML for the field:

<Field Type="Text" DisplayName="S-Order" Required="FALSE" MaxLength="255" ID="{e938e162-c1c3-49c5-9971-793673a16765}" SourceID="{304f80d5-33ab-460d-b0a8-743c4638223f}" StaticName="Sx002dOrder" Name="Sx002dOrder" ColName="nvarchar5" RowOrdinal="0" Version="2"><Default /></Field>