/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

19 votes313 views1 answer
How to disable a gameObject unity c#
C#
0 vote302 views2 answers
External font family uwp c#
C#
32 votes274 views4 answers
How to get keyboard input in unity
C#
4 votes258 views3 answers
Unity ontriggerenter2d
C#
11 votes256 views6 answers
Ternary operator in c#
C#
174 votes479 views6 answers
C# foreach
C#
1 vote270 views1 answer
Asp net c# compare date to current
C#
4 votes294 views1 answer
How to get rigidbody speed in unity
C#Unity
5 votes322 views2 answers
Rigidbody velocity c# unity
C#Unity
8 votes276 views3 answers
C# increment by 1
C#