SharePoint 2010 books
Hi All, Does anyone have a good reference for SharePoint 2010 books both for dev admin (prefer each book for each dev admin)? Have a good weekend, Many thanks, Etmilis ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Need help with CAML query, please...
Hi everyone, Can someone please help me with CAML query? I have site that looks like this: - HQ Local Offices (more than one) Australia New Zealand So each office including HQ has its own calendar. We have a custom calendar webpart that has a flag whether to rollup to the HQ, So when the calendar item from local office has rollup flag on, the webpart needs to show the item. When the user creates a calendar item on HQ, the rollup flag is hidden/invisible (default value is on for HQ) Sweet and simple, yeah. I have data that looks like this --- Row | List| Web | Title/Desc | Local Offices | RollUp --- 1. A HQ test 1 1 2. A HQ test2 1 3. A HQ test3 1 4. B Local AU-test1AU 1 5. B Local AU-test2AU 0 6. B Local AU-test3AU 1 7. C Local NZ-test1NZ 0 8. C Local NZ-test2NZ 1 This custom webpart needs to show all data from HQ + any data from local offices that has RollUf flag on (=1). The code to get the data looks like this: *** SPSiteDataQuery query = new SPSiteDataQuery(); query.Lists = Lists ServerTemplate=\106\ /; // calendar list query.Query = camlQuery; // struggling here :-( query.Webs = Webs Scope='Recursive' /; query.ViewFields = customViewFields; DataTable tb = SPContext.Current.Web.GetSiteData(query); I have tried simple queries like: - EqFieldRef Name=\RollupInternational\ /Value Type=\Boolean\1/Value/Eq - this only returns HQ data But I can't seem to get the CAML query right. I just wonder whether the different list and web have any impact to the query Can someone please help me with CAML query? Heap of thanks, etmilis ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
RE: Peeping into CAML Query from CQWP
Hi Paul, What I am referring is the U2U WinForm app, not the webpart. Thanks for this, this is gold. Will install it and check it out. Cheers, etmilis From: paul.no...@ceosyd.catholic.edu.au.akapost.com [mailto:paul.no...@ceosyd.catholic.edu.au.akapost.com] Sent: Wednesday, 17 February 2010 8:47 AM To: ozMOSS Subject: RE: Peeping into CAML Query from CQWP U2U CAML Query feature handles recursion and also let's you specify a specific folder to search within. Regards, Paul Online Developer, ICT CEO Sydney -Original Message- From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Chris Milne Sent: Tuesday, 16 February 2010 2:53 PM To: ozMOSS Subject: RE: Peeping into CAML Query from CQWP Hoi hoi, This may do the trick for recursion for you; spQueryObject.ViewAttributes = Scope='Recursive'; As for pulling out the CAML, I recall someone mentioning something like that here a while ago but I don't recall the specifics. C -Original Message- From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of etmi...@akapost.com Sent: Tuesday, 16 February 2010 1:49 PM To: 'ozMOSS' Subject: Peeping into CAML Query from CQWP Hi everyone, Is there a way or ways to peep into or get the CAML query from out of the box content query web part? I have been playing with CAML query and I can see some grey hairs growing immediately :-) The reason I ask is, I am maintaining a web part developed by someone and need to modify/overwrite the caml query. I can get what I want using the OOTB CQWP but I want the actual CAML query. I have tried using U2U CAML query builder but still have no luck since the query needs to be RECURSVIE and I don't think U2U supports it yet. Thanks, etmilis ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss image001.jpg___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Cannot modify shared webpart
Hi everyone, I am newbie to SharePoint, so please bare with my question :-) We have deploy a webpart used in 2 different sites, but in site B we cannot modify the shared webpart to see the properties, etc. We see the usual error An unexpected error has occurred., trying to open the page using SharePoint Designer, it complains that the master page is invalid. We have reset the master page but still no luck. Any idea? Or can someone point us where/what we should start looking into? Thanks, etmilis ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss