• Jason Mower 11
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies

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
 

Hi there

 

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?

 

Thanks

King

Can anyone tell me how to deploy App Permissions section of the profile (checkboxes like Edit Self-Service Users, Edit Case Comments etc) with Migration Tool?