starred/CoreStore-JohnEstropia
1
0
Fork 0
mirror of https://github.com/JohnEstropia/CoreStore.git synced 2026-09-03 02:47:19 +02:00
Code Issues 95 Packages Projects Releases 10 Wiki Activity

Fetching fetch all categories where all items or sub_categories items are "veg" #331

New Issue
Open
opened 2025-12-29 18:25:45 +01:00 by adam · 1 comment
adam commented 2025-12-29 18:25:45 +01:00
Owner
Copy Link
Copy Source

Originally created by @techiesanjaypathak on GitHub (Jun 11, 2020).

My restaurant table structure is as follows:
MenuCategory
restaurant_id
category_id
category_name
items
sub_categories

                Either items or sub_categories will be present in the above table.

MenuSubCategory
ranking
sub_category_id
sub_caterory_name

MenuItem
item_id
item_name
item_price
item_type <------- Can be "veg" or "non-veg"

Currently, I am fetching all the categories for a particular restaurant like this:
CoreStoreDefaults.dataStack.fetchAll(
From()
.where(format:"%K = %@", #keyPath(MenuCategory.restaurant_id), restaurant_id)
.orderBy(.ascending(.category_id))
)

And accessing subCategories by category?[section].sub_categories
and accessing items category?[section].items

How to fetch all categories where all items or sub_categories items are "veg"?

Originally created by @techiesanjaypathak on GitHub (Jun 11, 2020). My restaurant table structure is as follows: **MenuCategory** _restaurant_id category_id category_name items sub_categories_ Either items or sub_categories will be present in the above table. **MenuSubCategory** _ranking sub_category_id sub_caterory_name_ **MenuItem** _item_id item_name item_price item_type_ <------- Can be "veg" or "non-veg" Currently, I am fetching all the categories for a particular restaurant like this: CoreStoreDefaults.dataStack.fetchAll( From<MenuCategory>() .where(format:"%K = %@", #keyPath(MenuCategory.restaurant_id), restaurant_id) .orderBy(.ascending(\.category_id)) ) And accessing subCategories by category?[section].sub_categories and accessing items category?[section].items How to fetch all categories where all items or sub_categories items are "veg"?
adam added the enhancementquestion labels 2025-12-29 18:25:45 +01:00
adam commented 2025-12-29 18:25:46 +01:00
Author
Owner
Copy Link
Copy Source

@JohnEstropia commented on GitHub (Jun 12, 2020):

There is no built-in syntax in CoreStore for this yet, but you can use SUBQUERY expressions in the where() clause

@JohnEstropia commented on GitHub (Jun 12, 2020): There is no built-in syntax in CoreStore for this yet, but you can use SUBQUERY expressions in the `where()` clause
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
abandoned
corestore bug
discussion
duplicate
enhancement
fixed
fixed
help wanted
in progress
investigating
ios/compiler bug
irreproducible
looking for workarounds
not a bug
pending
pending docs update
pull-request
Mirrored from GitHub Pull Request
 question
regression
user bug
wontfix
No labels enhancement question
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Melkus)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/CoreStore-JohnEstropia#331