# Comics (MoC) ## Overview Everything about comics in this vault. Part of the [[Media (MoC)]]. The full collection (shelf, wishlist, collection, Kanban board) lives in [[Comics (Base).base]]. ## Want to Read <!-- QueryToSerialize: LIST FROM (#type/media/comic_series OR #type/media/comic) WHERE (status = "To Read" OR status = "To Read Again") AND public_note = true SORT priority ASC, manual_order ASC, file.name ASC --> ## Wishlist Public by design: a shareable gift list. <!-- QueryToSerialize: TABLE WITHOUT ID file.link AS "Comic", wishlist_priority AS "Wishlist Priority", join(formats, ", ") AS "Formats" FROM (#type/media/comic_series OR #type/media/comic) WHERE contains(ownership, "Wishlist") AND public_note = true SORT default(wishlist_priority, "9") ASC, priority ASC, file.name ASC --> <!-- SerializedQuery: TABLE WITHOUT ID file.link AS "Comic", wishlist_priority AS "Wishlist Priority", join(formats, ", ") AS "Formats" FROM (#type/media/comic_series OR #type/media/comic) WHERE contains(ownership, "Wishlist") AND public_note = true SORT default(wishlist_priority, "9") ASC, priority ASC, file.name ASC --> | Comic | Wishlist Priority | Formats | | ----- | ----------------- | ------- | <!-- SerializedQuery END --> ## Reading <!-- QueryToSerialize: LIST FROM (#type/media/comic_series OR #type/media/comic) WHERE status = "Reading" AND public_note = true SORT date_started DESC --> ## Completed by Year A series with album notes is listed through its albums. <!-- QueryToSerialize: TABLE WITHOUT ID y AS "Year", file.link AS "Comic", length(filter(cd, (d) => startswith(d, y))) AS "Times", rating AS "Rating" FROM (#type/media/comic_series OR #type/media/comic) FLATTEN list(unique(map(filter(flat(list(dates_completed, dates_played, choice(status = "Read", date_finished, null))), (d) => d), (d) => dateformat(date(d), "yyyy-MM-dd")))) AS cd FLATTEN unique(map(cd, (d) => substring(d, 0, 4))) AS y WHERE public_note = true AND !(econtains(file.tags, "#type/media/tv_show") AND any(file.inlinks, (l) => econtains(l.file.tags, "#type/media/tv_season"))) AND !(econtains(file.tags, "#type/media/comic_series") AND any(file.inlinks, (l) => econtains(l.file.tags, "#type/media/comic"))) SORT y DESC, file.name ASC --> <!-- SerializedQuery: TABLE WITHOUT ID y AS "Year", file.link AS "Comic", length(filter(cd, (d) => startswith(d, y))) AS "Times", rating AS "Rating" FROM (#type/media/comic_series OR #type/media/comic) FLATTEN list(unique(map(filter(flat(list(dates_completed, dates_played, choice(status = "Read", date_finished, null))), (d) => d), (d) => dateformat(date(d), "yyyy-MM-dd")))) AS cd FLATTEN unique(map(cd, (d) => substring(d, 0, 4))) AS y WHERE public_note = true AND !(econtains(file.tags, "#type/media/tv_show") AND any(file.inlinks, (l) => econtains(l.file.tags, "#type/media/tv_season"))) AND !(econtains(file.tags, "#type/media/comic_series") AND any(file.inlinks, (l) => econtains(l.file.tags, "#type/media/comic"))) SORT y DESC, file.name ASC --> | Year | Comic | Times | Rating | | ---- | ----- | ----- | ------ | <!-- SerializedQuery END --> ## Ratings <!-- QueryToSerialize: TABLE WITHOUT ID file.link AS "Comic", rating AS "Rating" FROM (#type/media/comic_series OR #type/media/comic) WHERE rating AND public_note = true SORT rating ASC, file.name ASC --> <!-- SerializedQuery: TABLE WITHOUT ID file.link AS "Comic", rating AS "Rating" FROM (#type/media/comic_series OR #type/media/comic) WHERE rating AND public_note = true SORT rating ASC, file.name ASC --> | Comic | Rating | | ----- | ------ | <!-- SerializedQuery END --> ## Notes <!-- QueryToSerialize: LIST WITHOUT ID key FROM (#type/media/comic_series OR #type/media/comic) FLATTEN file.inlinks AS n WHERE !econtains(n.file.tags, "#type/book") AND !econtains(n.file.tags, "#type/media") AND !econtains(n.file.tags, "#type/quote") AND !econtains(n.file.tags, "#type/creation/quote") AND !econtains(n.file.tags, "#type/map") AND !econtains(n.file.tags, "#type/folder_note") AND !econtains(n.file.tags, "#type/person") AND !econtains(n.file.tags, "#type/contact") AND !econtains(n.file.tags, "#type/highlight") AND length(n.file.tags) > 0 AND n.public_note = true GROUP BY n SORT key.file.name ASC --> ## Quotes <!-- QueryToSerialize: LIST WITHOUT ID key FROM (#type/media/comic_series OR #type/media/comic) FLATTEN file.inlinks AS n WHERE (econtains(n.file.tags, "#type/quote") OR econtains(n.file.tags, "#type/creation/quote")) AND n.public_note = true GROUP BY n SORT key.file.name ASC --> ## References ## Related - [[Media (MoC)]] - [[Favorite Comics (MoC)]]