goran ljubic

goran ljubic

  • NA
  • 27
  • 2.9k

what's wrong with query

Apr 25 2018 2:05 PM
 i have a event receiver that after changing item document  in document library it changes item value in another list. i created the 4 spquery's on same document library and 4 splistitem collections  i need items count for every spquery. i have problem with the first spquery every time i receive count=0 but i have documents on this location (5 documents). my code for spsuery and splistcollection is next
  1. SPQuery fajloviviewAD100 = new SPQuery();  
  2.                     fajloviviewAD100.Query = "<Where><And><Contains><FieldRef Name='FileRef'/><Value Type='Text'>A?/100</Value></Contains><Eq><FieldRef Name='FSObjType'/><Value Type='Text'>0</Value></Eq></And></Where>";  
  3.                     fajloviviewAD100.ViewAttributes = "Scope='RecursiveAll'";  
  4.                     SPListItemCollection fajloviAD1000 = properties.List.GetItems(fajloviviewAD100);  
  5.                     SPQuery fajlovi2 = new SPQuery();  
  6.                     fajlovi2.Query = "<Where><And><Contains><FieldRef Name='FileRef'/><Value Type='Text'>???/500</Value></Contains><Eq><FieldRef Name='FSObjType'/><Value Type='Text'>0</Value></Eq></And></Where>";  
  7.                     fajlovi2.ViewAttributes = "Scope='RecursiveAll'";  
  8.                     SPListItemCollection fajloviSIK500 = properties.List.GetItems(fajlovi2);  
  9.                     SPQuery fajlovi3 = new SPQuery();  
  10.                     fajlovi3.Query = "<Where><And><Contains><FieldRef Name='FileRef'/><Value Type='Text'>???/600</Value></Contains><Eq><FieldRef Name='FSObjType'/><Value Type='Text'>0</Value></Eq></And></Where>";  
  11.                     fajlovi3.ViewAttributes = "Scope='RecursiveAll'";  
  12.                     SPListItemCollection fajloviSIK600 = properties.List.GetItems(fajlovi3);  
  13.                     SPQuery fajlovi4 = new SPQuery();  
  14.                     fajlovi4.Query = "<Where><And><Contains><FieldRef Name='FileRef'/><Value Type='Text'>??/700</Value></Contains><Eq><FieldRef Name='FSObjType'/><Value Type='Text'>0</Value></Eq></And></Where>";  
  15.                     fajlovi4.ViewAttributes = "Scope='RecursiveAll'";  
  16.                     SPListItemCollection fajloviAD700 = properties.List.GetItems(fajlovi4); 
fajloviAD100.Count.ToString() 
fajloviSIK500.Count.ToString();
fajloviSIK600.Count.ToString();
fajloviAD700.Count.ToString();
 
fajloviSIK500.Count, fajloviSIK600.count and fajloviAD700.count back values but fajloviAD100.count back 0
 
why? where i made mistake

Answers (2)