CAML : filter items based on FieldType regardless of the Column name

Question

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 ?

Answer 1

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

Answer 2

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.