Wednesday, August 11, 2010

SQL Scripts

List of all checked out files for an web applications:

SELECT
    sites.FullUrl AS SiteURL, tp_DirName AS Directory,  tp_LeafName AS Document,  [tp_CheckoutUserId] AS UserID

FROM 
[cms-roche.dev].[dbo].[AllUserData]

INNER JOIN 
[cms-roche.dev].dbo.[Sites] on sites.id=alluserdata.tp_SiteId

WHERE
[tp_CheckoutUserId]<>0

 

List of all activated Features for a web applciation:

SELECT 
sites.FullUrl AS SiteCollection,  Webs.FullUrl AS Site,  Features.FeatureId

FROM 
[cms-roche.dev].[dbo].[Features]

INNER JOIN 
[cms-roche.dev].dbo.Sites ON Features.SiteId=sites.Id

INNER JOIN 
[cms-roche.dev].dbo.Webs ON Features.WebId=Webs.Id

WHERE 
Features.FeatureId='00BFEA71-3A1D-41D3-A0EE-651D11570120'

Sunday, July 18, 2010

Hide a List with SharePoint Designer 2010

With SharePoint Designer 2010 it is possible to hide a list.

Just select the list an enable hidden

clip_image001

If you want to hide a list please uncheck "Display this ilist on the Quick Launch" otherwise you can not hide the list

After saving this works realy fine. You also would not see the list in SharePoint Designer again.

You can if you know the URL browse to the list and work with this list, but you can not configure it in SharePoint Designer.

There is a way to make the hidden list available again.

Select in SharePoint Designer in "All Files"/Lists with a right click the hidden list.

clip_image002

Then choose Properties

Now you can change all settings in SharePoint Designer and also change the hidden attribute

clip_image003

Create folder content type with metadata

Create new content type

clip_image001

Fill in name and choose Folder Content Type and Content Type “Folder” as parent

clip_image002

Assign the needed columns. In this case a status column

clip_image003

Choose add from existing content type to a document library

clip_image004

And choose new content type special folder

Afterwards you get a new column “status”

clip_image005

Now you can add a new folder with the New button for the document library

clip_image006

Now you can type the folder name and all meta data you configured. In this case the status

This is working for SharePoint 2007 and SharePoint 2010

Nintex Workflows 2010 Actions

Since Nintex release the new version of Nintex Workflow 2010 and the changes inside Nintex Workflow and SharePoint. I thought it is a good idea to post a picture of all actions.

This always was a good help for me to get an overview of the functionality.

clip_image001

clip_image002

clip_image003

clip_image004

clip_image005

clip_image006

clip_image007

clip_image008

clip_image009

clip_image010

clip_image011

clip_image012

clip_image013

clip_image014

clip_image015

clip_image016

clip_image017

clip_image018

clip_image019

clip_image020

clip_image021

clip_image022

clip_image023

clip_image024

clip_image025

clip_image026

clip_image027

clip_image028

clip_image029

clip_image030

clip_image031

clip_image032

clip_image033

clip_image034

clip_image035

clip_image036

clip_image037

clip_image038

clip_image039

clip_image040

clip_image041

clip_image042

clip_image043

clip_image044

clip_image045

clip_image046

clip_image047

clip_image048

clip_image049

clip_image050

clip_image051

clip_image052

clip_image053

clip_image054

clip_image055

clip_image056

clip_image057

clip_image058

clip_image059

clip_image060

clip_image061

clip_image062

clip_image063

clip_image064

clip_image065

clip_image066

clip_image067

clip_image068

clip_image069

clip_image070

clip_image071

clip_image072

clip_image073

clip_image074

clip_image075

clip_image076

clip_image077

clip_image078

clip_image079

clip_image080

clip_image081

clip_image082

clip_image083

clip_image084

clip_image085

clip_image086

clip_image087

clip_image088

clip_image089

clip_image090

clip_image091

clip_image092

clip_image093

clip_image094

clip_image095

clip_image096

clip_image097

clip_image098

clip_image099

clip_image100

clip_image101

clip_image102

clip_image103

clip_image104

clip_image105

clip_image106

clip_image107

clip_image108

clip_image109

clip_image110

clip_image111

clip_image112

clip_image113

clip_image114

clip_image115

clip_image116

clip_image117

clip_image118

clip_image119

clip_image120

clip_image121

clip_image122

clip_image123

clip_image124

clip_image125

clip_image126

clip_image127

clip_image128

clip_image129

clip_image130

clip_image131

clip_image132

clip_image133

clip_image134

clip_image135