SPView.Query property

Gets or sets a string that contains the query for the view.

Namespace:  Microsoft.SharePoint
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)

Syntax

'Declaration
Public Property Query As String
    Get
    Set
'Usage
Dim instance As SPView
Dim value As String

value = instance.Query

instance.Query = value

public string Query { get; set; }

Property value

Type: System.String
A Collaborative Application Markup Language (CAML) string that contains a Where, Groupby, or Orderby clause for the query.

Remarks

Setting a query with the Query property requires that the Update method be used for changes to take effect in the database.

Examples

The following code example uses the Query property to return items where a specified field in the list contains values less than 1000.

Dim siteCollection As SPSite = SPControl.GetContextSite(Context)
Dim site As SPWeb = siteCollection.AllWebs("Site_Name")
Dim list As SPList = site.Lists("List_Name")
Dim view As SPView = list.Views("View_Name")

view.Query = "<Where><Leq><FieldRef Name='Field_Name'/>" _
             & "<Value Type='Number'>1000</Value></Leq></Where>"

view.Update()

SPSite oSiteCollection = SPContext.Current.Site;
using(SPWeb oWebsite = oSiteCollection.AllWebs["Website_Name"])
{
    SPList oList = oWebsite.Lists["List_Name"];
    SPView oView = oList.Views["View_Name"];

    oView.Query = "<Where><Leq><FieldRef Name=\"Field_Name\" />" +
    "<Value Type=\"Number\">1000</Value></Leq></Where>";

    oView.Update();
}

See also

Reference

SPView class

SPView members

Microsoft.SharePoint namespace