SharePoint query-language... completely undocumented....

When you convert a SharePoint list view (defined in CAML) to a XSLT Data View, Frontpage generates a query that looks like:

And the strange thing is that virtually NO information is available on the query syntax.Why o why are such large portions of SharePoint still undocumented?

If anyone has some pointers for me to documentation on this stuff, please let me know!!

Published Saturday, February 26, 2005 10:40 PM by svdoever
Filed under:

Comments

Saturday, February 26, 2005 5:06 PM by Rob Chartier

# re: SharePoint query-language... completely undocumented....


Just some thoughts, I've never actually used sharepoint so dont shoot me if im way off base here...

Looks like for the most part a SOAP envelope. If you remove all the SOAP stuff you are left with:

<dsp:dsquery select="/list[@id='{B077D467-7540-4358-8835-9775A3BF17D4}']" resultcontent="Both" resultroot="Rows" resultrow="Row" columnmapping="Attribute">
<dsp:query querytype="DSPQ">
<dsp:fields>
<dsp:allfields includehiddenfields="true"/>
</dsp:fields>
<dsp:orderby>
<dsp:orderfield>
<attribute name="Name">
<clientparametervalue name="dvt_sortfield"/>
</attribute>
<attribute name="Direction">
<clientparametervalue name="dvt_sortdir"/>
</attribute>
</dsp:orderfield>
<dsp:orderfield name="ThreadID" type="xsd:string" direction="DESC"/>
<dsp:orderfield name="Ordering" type="xsd:string" direction="ASC"/>
</dsp:orderby>
</dsp:query>
</dsp:dsquery>



If you consider

select="/list[@id='{B077D467-7540-4358-8835-9775A3BF17D4}']"

That appears to be an XSLT path/expression, maybe for the result of the SOAP call? Or the data which that query returns via the querytype="DSPQ"

The Fields and Orderby stuff are obvious..

HTH.

-Rob
rob dot chartier at gmail dotty commy
Saturday, February 26, 2005 7:02 PM by Serge van den Oever [Macaw]

# re: SharePoint query-language... completely undocumented....

But the problem is that the query language is not documented... how can I retrieve the first 10 items, or the last 10. How do specify where clauses, and which "keywords" are available in the where clauses....
Sunday, February 27, 2005 4:22 AM by Adrian Florea

# re: SharePoint query-language... completely undocumented....

DSPQ seems that stands for "Data Source Protocol Query"
Sunday, February 27, 2005 4:38 AM by Adrian Florea

# re: SharePoint query-language... completely undocumented....

I never used SharePoint but I see under the Microsoft.SharePoint.Dsp namespace some classes in obvious relationship to your schema:

dsp:queryrequest <-> Microsoft.SharePoint.Dsp.QueryRequest
dsp:dsquery <-> Microsoft.SharePoint.Dsp.DspQuery
dsp:fields <-> Microsoft.SharePoint.Dsp.Fields
dsp:allfields <-> Microsoft.SharePoint.Dsp.AllFields

etc...

So my suggestion is to study this object model in order to understand the schema
Sunday, February 27, 2005 6:53 AM by Serge van den Oever [Macaw]

# re: SharePoint query-language... completely undocumented....

Thursday, December 13, 2007 11:22 AM by Neil Richards

# re: SharePoint query-language... completely undocumented....

Wednesday, December 17, 2008 12:01 PM by Carol

# re: SharePoint query-language... completely undocumented....

Can I use this code or something like that, like UDC file for example, to read data from many different sharepoint lists using the same UDC file?

We input the list GUID in the code, but just for one list... I have 10 lists that I want to read data from, and display them into a drop down list in different forms libraries.

Do I need to customize one UDC file for each list that I want to read data from?

Isn´t there a better wya to do that?

Leave a Comment

(required) 
(required) 
(optional)
(required)