CHUVASH.eu

CHunky Universe of Vigourous Astonishing SHarepoint :)

Ändra query på en SPView i koden

När man vill ändra hur data ska visas i en SPView i SPList, då måste man ändra CAML-Query. Det enklaste sättet att skapa en CAML Query är att använda ett program som heter CAML Query Builder. Ta bara bort <Query> och </Query> för att de behövs inte.

Sedan är det bara att loopa igenom alla vyer man behöver.

private void UpdateQueryInGroupViews(SPList list)
{
    for (int i = 1; i < 11; i++)
    {
        string viewname = String.Format("Group {0:D2}", i);
        SPView view = list.Views[viewname];
        string query = 
                String.Format(
                        "<Where><Or><Contains><FieldRef Name='Group' />"
                        + "<Value Type='Text'>{0:D2}</Value></Contains>"
                        + "<IsNull><FieldRef Name='Group' /></IsNull></Or></Where>"
                        + "<OrderBy><FieldRef Name='EventDate' Ascending='True' />"
                        + "</OrderBy>", i);
        view.Query = query;
        view.Update();
    }
}

I denna query sorterar vi efter Start Date och visar bara händelser för sin grupp.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Вула Чăвашла

VulaCV - Чăвашла вулаттаракан сайт

Discovering SharePoint

And going crazy doing it

Bram de Jager - Coder, Speaker, Author

Office 365, SharePoint and Azure

SharePoint Dragons

Nikander & Margriet on SharePoint

Paul J. Swider - RealActivity

RealActivity is a specialized healthcare services and solution advisory firm.

Mai Omar Desouki - Avid SharePointer

Egyptian & Vodafoner - Senior SharePoint Consultant

Cameron Dwyer | Office 365, SharePoint, Outlook, OnePlace Solutions

Office 365, SharePoint, OnePlace Solutions & Life's Other Little Wonders

paul.tavares

Me and My doings!

Share SharePoint Points !

By Mohit Vashishtha

Jimmy Janlén "Den Scrummande Konsulten"

Erfarenheter, synpunkter och raljerande om Scrum från Jimmy Janlén

Aryan Nava

| Blockchain | Serverless Architecture | Microservices Architecture | DevOps | AWS Lambda | Teraform |

SPJoel

SharePoint for everyone

SharePointRyan

Ryan Dennis is a SharePoint Solution Architect with a passion for SharePoint and PowerShell

SharePoint 2020

The Vision for a Future of Clarity

Aharoni in Unicode

Treacle tarts for great justice

... And All That JS

JavaScript, Web Apps and SharePoint

blksthl

Mostly what I know about SharePoint - CommunicoCuspis

%d bloggers like this: