We have a Data Category Group called 'Locations'. I am hoping to write a SOQL query to find articles that have at least USA__c and Canada__c data category selections.
The documentation specifies how to use 'AND' to filter from two different groups but doesn't specify filtering from the same group. Is this possible with SOQL?
Including both Locations in my query is giving an 'unexpected error':
SELECT Title, Id FROM Products__kav WITH DATA CATEGORY Locations__c AT USA__c AND Locations__c AT Canada__c
However including just one is working:
SELECT Title, Id FROM Products__kav WITH DATA CATEGORY Locations__c AT USA__c
It seems to me that the "ALL ROWS" keyword that you use in SOQL (to access records in the recycled bin) can only be used in Apex.
I went to Developer Console in the Query Editor and tried typing this
SELECT ID FROM Fruit__c
and it executes.
But If I add "ALL ROWS" at the end, i.e.
SELECT ID FROM Fruit__c ALL ROWS
then I got
"Unknown error parsing query" error.
If I write this in an Apex code, like this
List<Fruit__c> fruits = [SELECT ID FROM Fruit__c ALL ROWS];
then the line actually executes successfully.
It seems weird to me that "ALL ROWS" keyword cannot be used inside the Query Editor. Wondering if anyone has encountered that?