How to fetch core data relationships in one single NSFetchRequest?

Question

I have a core data app with the model setup just like the image below:

The relationships are setup like this:

Category<-->>Subcategory<-->>Item

Now, is it possible in one single fetch to get objects from Subcategory and Item entities that have the same attribute called categoryName? I think it can be done by using relationships, but the code I am using is not working which is:

let fetchNote = NSFetchRequest(entityName: "Category")
    fetchNote.predicate = NSPredicate(format: "ANY subcategory.name == %@ AND item.name == %@", "Badaue", "Badaue")
    let notes = try! appDel.managedObjectContext.executeFetchRequest(fetchNote) as? [Category]
    print(notes)

Answer 1

To avoid confusion, I'd suggest renaming item to items to reflect that it's a to-many relationship. Same goes for subcategory.

EDIT2 - You are asking to get the Subcategory and Item objects that have a certain categoryName, correct? The query you've written above doesn't do that at all.

First, yes, you will need 2 queries, as you can only fetch 1 Entity type at a time.

Second, let's re-write your syntax because right now it's super dangerous.

do {
  let predicate = NSPredicate(format: "categoryName == %@", "yourCategoryHere")
  let fetchSubcategory = NSFetchRequest(entityName: "Subcategory")
  fetchSubcategory.predicate = predicate
  if let subCategoryResults = try context.executeFetchRequest(fetchSubcategory) as? [Subcategory] {
    //do stuff
  }
  let fetchItem = NSFetchRequest(entityName: "Item")
  fetchItem.predicate = predicate
  if let itemResults = try context.executeFetchRequest(fetchItem) as? [Item] {
    //do stuff
  }
}catch {
  print(error)
}

Answer 2

If you fetch Categories you will get an array of Category objects. Each of those objects will have a property, subcategory, which is a set containing all the related Subcategory objects. And each of those objects will have a property, item, which is a set containing all the Item objects related to that Subcategory. The related objects are "nested" within the Category and Subcategory objects.

When you fetch the Categories, you do not need to specify a predicate to get the related objects. They will be automatically fetched as soon as you access the subcategory or item properties. So, for example, if myCategory is a Category object you have fetched,

let mySubcategories = myCategory.subcategory
for subcat in mySubcategories {
    print("\(subcat)")
}

should print each of the related subcategories.

If those properties are nil, it might be that you have not yet established the relationships. That is normally done when you first create the objects. For example, if you create a Subcategory with categoryName = "Badaue", you might establish the relationship with the Category with name = "Badaue" like this:

let newSubcategory = ....
newSubcategory.categoryName = "Badaue"
let fetchCategory = NSFetchRequest(entityName: "Category")
fetchCategory.predicate = NSPredicate(format: "name == %@", newSubcategory.categoryName)
let categories = try! appDel.managedObjectContext.executeFetchRequest(fetchNote) as? [Category]
if (categories!.count > 0) {
    let firstCategory = categories[0]
    newSubCategory.category = firstCategory
} else {
    // no existing Category with the correct name, so create one....
    let newCategory = ....
    // ... and then establish the relationship to the Subcategory
    newSubCategory.category = newCategory
}