How Sharepoint

WSS and MOSS, status are stored as integers. The default values are: ErrorOccurred = 3, ErrorOccurredRetrying = 7, FailedOnStart = 1, FailedOnStartRetrying = 6, InProgress = 2, Max = 15, NotStarted = 0, StoppedByUser = 4, ViewQueryOverflow = 8 Rejected = 17 Approved = 16 Canceled = 15 The workflow status is stored as an integer. you need to filter for 'is equal to 15' to get the approved items

iLove SharePoint - Lookup Field with Picker.. http://ilovesharepoint.codeplex.com/ Error : "Only PickerDialog types can be used with the dialog. The type should be configured as a safecontrol in this site." To solve this problem I have add following safecontrol statement to the web.config file. STEP 1 Go to : C:\Inetpub\wwwroot\wss\VirtualDirectories\ STEP 2 Open the "web.config" file and find the place which safecontrol tag starts. STEP 3 Add the following statement within safecontrol Tags SafeControl Assembly="iLoveSharePoint.Fields.LookupFieldWithPicker, Version=1.0.0.0, Culture=neutral, PublicKeyToken=c8ecfa5d637948fe" Namespace="iLoveSharePoint.Fields" TypeName="*" Safe="True" * add "<" at the start of the above statement and add "/>" at the end of the statement

To Group a List by Week Number do the following: Make sure the list has a column that contains the Date you wish to GroupBy. I'll use the Start Time column of a standard Event list but you can use any Date/Time column. You don't need to filter out the Time portion first, it will be ignored. Add a Calculated column to the list called 'WeekNumber' that uses the following formula: =INT(([Start Time]-DATE(2007,1,1))/7) where [Start Time] is the date column whose week you want to group by. Set the data type of the Calculated Column to Number with 0 decimal places Create the view that you want Grouped by Week. SORT the view by [Start Time] and GROUPBY the [WeekNumber] column.

If you want to populate dropdown list based on other field you can use this. Download this : Query Based Lookup Field Control & Installation and Guidelines

At Site Settings > Site Features > Site Collection Features , you will want to have Office SharePoint Server Publishing Infrastructure set to active. Then, on the site, go to Site Settings > Site Features , and activate the Office SharePoint Server Publishign feature . You should then be able to add the content query web part to the site.

"Office SharePoint Server Publishing Create a Web page library as well as supporting libraries to create and publish pages based on page layouts. " When I try to activate it, it ask The Office SharePoint Server Standard Web application features feature must be activated at the web application level before this feature can be activated. So I did followings........... (run the following commands in command prompt) First: stsadm -o installfeature -name PublishingTimerJobs Second: stsadm.exe -o execadmsvcjobs Finally: psconfig -cmd upgrade -wait -inplace b2b Then I run the following commands and try activate feature again stsadm -o activatefeature -name PublishingSite -url http://sitecollection/ stsadm -o activatefeature -name PublishingWeb -url http://sitecollection/site