In a CAML query, can you filter items which has values in the column (Not Null), based on the FieldType of the column. regardless of the Column name ?
Add a comment
|
2 Answers
As you can see from CAML Query schema, the IsNotNull element requires the FieldRef element, whose Name attribute is the internal name of the field.
If you are building the CAML query in code, you can enumerate all the fields of the list and check if there is any that is of the type you are looking for; once found, you can get its internal name and use it dynamically populate the FieldRef Name attribute.
An example using the JSOM (in C# it would be similar) to retrieve all fields and their types can be found here on SharePoint.SE
answered Feb 7, 2014 at 17:19
-
1Nice workaround. I am using the Server Object model, but the example gave an idea. Used the field type to get hold of the column name through C# and used that for the CAML query. Thanks !– ShaamilFeb 10, 2014 at 12:30
Both Field Internal name and Value type (Field type) are required while making CAML queries. In REST you can query using field names only. However, I don't remember/know of any way where you can only specify field type only.
answered Feb 7, 2014 at 13:48
