I'm new to Apex, SOQL and the entire Salesforce world, so please forgive me if this is a silly question.

I'm working with a partner who has grouped their Soultion objects into categories. I can see these groupings with no problem in the UI of the Salesforce dashboard (Solutions tab), but cannot for the life of me conjure up the correct SOQL query to get a list of Solutions for a particular category.

For example, here's a query that seems reasonable based on what I've read in the documentation. Result *should* be an array of SolutionNames and SolutionNotes for Solutions in the category 'Foo'.

Code:

SELECT
   SolutionName, SolutionNote,
   (SELECT
       CategoryNode.MasterLabel
   FROM CategoryNode
   WHERE
      MasterLabel = 'Foo')
FROM Solution

 

Instead, I am treated to this error: INVALID_TYPE: Didn't understand relationship 'CategoryNode' in FROM part of query call. If you are attempting to use a custom relationship ...

For something as straightforward as "give me a list of Solutions within Category 'Foo'", I feel like I'm having a harder time than I should be.

What obvious thing am I missing? :)

Thank you!