/C#/Sharepoint c# get list item query by lookup

Sharepoint c# get list item query by lookup

CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='yourColumn' LookupId='TRUE'/><Value Type='Lookup'>123</Value></Eq></Where></Query></View>";
List listByTitle = clientContext.Web.Lists.GetByTitle("YourListName");
ListItemCollection yourListItem = listByTitle.GetItems(camlQuery);

clientContext.Load(yourListItem);
clientContext.ExecuteQuery();

Similar codes

39 votes203 views2 answers
Text Split
C#
0 vote192 views3 answers
Instantiate object inside of object Unity
C#
0 vote274 views1 answer
Console.out
C#
2 votes356 views1 answer
Change array size in unity
C#Unity
0 vote185 views1 answer
Pointer in c#
C#
1 vote383 views1 answer
Unity get script from gameobject
C#Unity
0 vote196 views1 answer
Get path revit linked unload
C#
2 votes152 views1 answer
Xml c#
C#
0 vote246 views1 answer
Uri file path c#
C#
-2 votes205 views2 answers
Save image in C#
C#