SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

var PicLibraryURL = "/SC/SW/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=TRUE&List=%7B9D30BD4A%2DBA0F%4ED2VM%2DBEBB%2D8CEC5D74A29B%7D";

How do I add a where clause to above javascript? I have a flag y/n column "ShowInRotator" in the pic libray and like to only fetch record where "ShowInRotator=Yes" (or true or 1, whatever it is).

I would also like to add additional text with the image rotator (the comments column in piclibrary has the text that I like display during image rotator.

share|improve this question
up vote 1 down vote accepted

You can create a View with a filter based on the criteria you want and then include the View parameter in your query string:

share|improve this answer
Thanks. I will certain try this. Actually, I do have a custom view where I added the active=1 filter. BTW, do you know how to put a link or link on the image SP OOTB picture library slide show web part – Julie May 26 '11 at 5:20
I don't think it's possible OOB. – Laurie May 26 '11 at 6:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.