Get Item's GUID with CAML

Question

Hi,
how can i retrieve an item guid in a caml query as a field and not as a property of the SPListItem? i want to use GetDataTable() and have all my field here so i have not cycle the table and put the guid one-to-one in the table.

thanks!

Answer 1

Add field with name "UID" to your ViewFields section

Answer 2

thanks for the reply.

i've tried to put <FieldRef Name='ID'/><FieldRef Name='UID'/><FieldRef Name='Title'/>
but only ID and Title are shower in the results table of the GetItems(query).GetDataTable();

if it can be usefull the list is a Document Library.


Thanks!

Answer 3

Hi Logan,

Please correct me if I am wrong....

As per my knowledge... SPList.ID returns GUID but SPListItem.ID returns only integer value (not GUID), so GetDataTable() doesn't contains SPListItem's GUID.

---

Regards, Avinash | avinashkt.blogspot.com

Answer 4

Hi logan1987,

In SharePoint API this field is called UniqueId (SPListItem.UniqueId). So if you get your items using CAML or by other mean then you can get it when looping through. But as you said you don't want this.

Maybe try <FieldRef Name='UniqueID'/>, because UniqueID seems like internal name for this field as well?

Hope that helps.

Best wishes,

---

Slava G
http://wyldesolutions.com
http://wyldesharepoint.blogspot.com

Answer 5

it doesn't work, it seem that for some mysterious way the guid isn't retrievable by caml query...

someone @ microsoft will come to help me? :P

Thanks

Answer 6

<FieldRef Name="GUID" />
         <Value Type="GUID">{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}</Value>

That will do.

Answer 7

<FieldRef Name="GUID" />
         <Value Type="GUID">{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}</Value>

That will do.

thanks, but i need the guid value in the ViewField, not in the where...

i need the value retrieved as a field in the query ;)

thanks

Answer 8

If you do not specify any field in <ViewFields> you should get back all the Fields.

Answer 9

If you do not specify any field in <ViewFields> you should get back all the Fields.

i know, but the guid field is not retrieved in this way,

thanks

Answer 10

Please try this code.

SPList list = web.Lists["ListName Here"]; 


SPQuery qry = new SPQuery(); 

 qry.ViewFields =

"<FielRef Name=\"UniqueId\" />"; 
 

SPListItemCollection coll = list.GetItems(qry);

SPListIttem item = coll[0]
item["UniqueId"]

0 above would be replaced with a interger counter to process all the items from the collection, in a loop.
The above should give the UniqueId value. Ofcourse please add other fields in ViewFields as needed for your requirement and 
let us know how it goes....

Mohan

 

Answer 11

So the right way is to loop through the list items and grab SPListItem.UniqueID.

Best wishes,

---

Slava G
http://wyldesolutions.com
http://wyldesharepoint.blogspot.com

Answer 12

Logan,
Verified running the CAML code i posted above. It does return UniqueId.

Would appreciate if you could please reply back when someone answers questions.

-- Mo

Answer 13

Hello Mohan,

So maybe then you could propose my post from Tuesday, February 02, 2010 6:47 AM as answer? :) Because it's exactly the same as your one.

Best wishes,

---

Slava G
http://wyldesolutions.com
http://wyldesharepoint.blogspot.com

Answer 14

Slava,

I just did :)

Answer 15

Thanks Mohan. Really appreciate. :)

Best wishes, 

---

Slava G
http://wyldesolutions.com
http://wyldesharepoint.blogspot.com