Home RSS 2.0 ATOM 1.0  CDF  
 
CodeSegment - Carlos Segura Sanz (blog)
 

- Include List Data flag, if you enable the checkbox the xml data will include the underscore data (_ListTitle, _ListUrl, _SiteTitle, _SiteUrl, _ItemId, _ItemUrl, _ItemEdit)

- Queries

    -  CAML Query you can use a caml query to search on each list.
    -  RowLimit - maximun number of rows to return
    -  Recursive - the query recursive be made (great for Document Libraries)
    -  DebugQuery - show the xml from the query

   Special values that you can use on queries:

    [Login] - the logged user
    [UserName] - the complete user name
    [UserID] - the user ID
    [Now] - the current date and time
    [Now+x] - the current date and time + x days
    [Now-x] - the current date and time  - x days

  example:

   1:  <query>
   2:     <Where>
   3:        <And>
   4:           <Eq>
   5:              <FieldRef Name="Author" />
   6:   
   7:              <Value Type="Text">[UserName]</Value>
   8:           </Eq>
   9:   
  10:           <Eq>
  11:              <FieldRef Name="Modified" />
  12:   
  13:              <Value Type="DateTime">[Now-30]</Value>
  14:           </Eq>
  15:        </And>
  16:     </Where>
  17:   
  18:     <OrderBy>
  19:        <FieldRef Name="Modified" Ascending="False" />
  20:     </OrderBy>
  21:  </query>

   (Note, you need put all fields thats are on query in the fields property).

- CellConsumer interface, you can use an special value in queries called [CellProvider] this value is replaced with the cell value provide from other webpart.

Sample (conected to a document library)

<Where>

<Contains>

<FieldRef Name='FileRef'/>

<Value Type='Text'>[CellProvider]</Value>

</Contains>

</Where>

- CellProvider interface, you can provide a value to another webpart, any value that you wants, when rendering the xsl, you can add a __doPostBack('','Value') to provide values.

example:

   1:  <a href="javascript:__doPostBack('','{@Name}')">
   2:  <xsl:value-of select="_SiteTitle"/>
   3:  </a>

I have a Release Candidate version if somebody wants test it, please comment this post, thanks.

Friday, October 28, 2005 8:19:26 AM (Hora de verano romance, UTC+02:00)
I downloaded the previous version and I found it a great tool. Is it possible to have the new version?
Great stuff!!!!!
Thank you,
Bart Segers
Bart Segers
Friday, October 28, 2005 3:34:32 PM (Hora de verano romance, UTC+02:00)
I have been using the previous version, and is looking forward to the new version.

I would like to test it!
Frederik Nielsen
Friday, October 28, 2005 3:38:12 PM (Hora de verano romance, UTC+02:00)
Hi, I will give this a test idf you want - i think it's what I've been looking for
Friday, October 28, 2005 4:19:19 PM (Hora de verano romance, UTC+02:00)
Great! :)
I'll be out of the office during the next week, so if it's still relevant for the week after it, I would like to participate in the testing.
Dor Rotman
Sunday, October 30, 2005 11:06:58 PM (Hora estándar romance, UTC+01:00)
Seems really cool and I would really like to try it out.
Lars
Monday, October 31, 2005 3:42:42 AM (Hora estándar romance, UTC+01:00)
I would love to test the Release Candidate.
Monday, October 31, 2005 3:01:09 PM (Hora estándar romance, UTC+01:00)
I`d like to test this RC!
Roman Vecjhysq
Tuesday, November 01, 2005 10:09:02 AM (Hora estándar romance, UTC+01:00)
Where to download?
Serge
Tuesday, November 01, 2005 5:40:18 PM (Hora estándar romance, UTC+01:00)
I'd like to test this. Where do I download?
Tiffany
Wednesday, November 02, 2005 3:56:03 AM (Hora estándar romance, UTC+01:00)
Carlos, do you intend to include the ability to rollup SPS subareas as well as WSS subsites? This would be a fantastic feature.
Friday, November 04, 2005 3:28:21 PM (Hora estándar romance, UTC+01:00)
Hi Carlos,
I have tried out the RC and it is a great step forward for the csegRollup Webpart. However I cant get the CAML Query to work. If I test my query with the U2U Caml Builder tool and there it returns the correct result, but in the csegRollUpWebpart it does not perform the query. All rows on the list are returned... e.g querying the Tasks List with the following query (had to remove brackets cause html is not allowed):

Query
Where
Eq
FieldRef Name="Title" /
Value Type="Text" Test /Value
/Eq
/Where
/Query

Returns ALL tasks in the list, no "filtering" is performed...

Is it supposed to be like this or is it something wrong with my query?
Serge
Wednesday, November 09, 2005 8:35:29 AM (Hora estándar romance, UTC+01:00)
Hi,

I just tested your previous version and wondering about the performace when dealing with large number of rows. Finally, you've come out with the RowLimit feature.

Could I try your latest one? I'd like to test on the new features especially RowLimit.

Thanks in advance,
SJ
SJ
Wednesday, November 09, 2005 9:15:22 AM (Hora estándar romance, UTC+01:00)
Serge,

remove the "query" tag

Where
Eq
FieldRef Name="Title" /
Value Type="Text" Test /Value
/Eq
/Where

Wednesday, November 09, 2005 3:28:44 PM (Hora estándar romance, UTC+01:00)
Carlos,

keep up the good work,
I want to test the Cellprovider interface so if you could sign me up.

Cheers,

Thomas
Thomas Vanden Brande
Wednesday, November 09, 2005 8:35:58 PM (Hora estándar romance, UTC+01:00)
Thomas, emaul you.
Thursday, November 10, 2005 10:35:52 AM (Hora estándar romance, UTC+01:00)
Hello,

I just tested the Version II, and I think you've done really good work!!

Is it possible to become the new Version?

Regards
Florian
Saturday, November 12, 2005 10:05:26 AM (Hora estándar romance, UTC+01:00)
How do I download it?
Wednesday, November 16, 2005 1:53:36 PM (Hora estándar romance, UTC+01:00)
Hi Carlos,
I'm using version 2 - which is great. I'd love to try out the querying in version 3.
Regards,
Chris
Chris Walters
Wednesday, November 16, 2005 3:32:04 PM (Hora estándar romance, UTC+01:00)
The beta process is in standby, please read the post http://www.ideseg.com/MyWebpartsInStandby.aspx
Carlos.
Thursday, November 17, 2005 7:41:58 PM (Hora estándar romance, UTC+01:00)
Would love to try this out as well. Looks exactly what im looking for.
/Örjan
Örjan Nordlund
Tuesday, September 12, 2006 9:39:05 PM (Hora de verano romance, UTC+02:00)
Hello,

I am trying to create a view based on the logged user. The logged user submits items to a list and they should only be seeing the ones they are set as the owner. The Caml Query that I am using is the following

Where Eq FieldRef Name="Owner" / Value Type="Text"[UserName]/Value /Eq /Where

The query seems to work but I am getting a long error message also

Error: In Query
SharePoint Admin

Microsoft.SharePoint.SPException: SQL Server Error The SQL Server might not be started. --->

I also want to be able to implement an and statement to show only the users Owner information and another field that is designated as "1-Open"

If anyone can help , please!

My email is geniusktl@aim.com

Thank You -

Kevin
Kevin Locke
Comments are closed.

Copyright © 2008 Carlos Segura. All rights reserved.