# Multiselect query – get both, unpublished AND publish children pages

**URL:** <https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408>\
**Category:** Questions\
**Tags:** v3\
**Created:** [June 2, 2020, 2:18pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408 "2020-06-02T14:18:51Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![teh](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/teh/32/9669_2.png) [@teh](https://forum.getkirby.com/u/teh)\
**Post date:** [June 2, 2020, 2:18pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/1 "2020-06-02T14:18:51Z")

</div>

In a structure field I’m trying to query all children pages from a parent page via a multiselect field. Unfortunately my query only gets the published children pages. Is there a query option to get both, unpublished AND publish children pages?

```
projekt:
  type: multiselect
  options: query
  query: site.children.template("projekte").children

```

OR like:

```
projekt:
    type: multiselect
    options: query
    query: site.children.template("projekte").children.template("projekt")

```

Thanks for any tips!

---

<div class="post-metadata">

**Author:** ![texnixe](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/texnixe/32/5754_2.png) [@texnixe](https://forum.getkirby.com/u/texnixe)\
**Post date:** [June 2, 2020, 3:04pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/2 "2020-06-02T15:04:54Z")

</div>

Do you mean drafts? Then you need `childrenAndDrafts()` not `children()`

---

<div class="post-metadata">

**Author:** ![teh](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/teh/32/9669_2.png) [@teh](https://forum.getkirby.com/u/teh)\
**Post date:** [June 2, 2020, 3:41pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/3 "2020-06-02T15:41:43Z")

</div>

Ah ok, but this

`query: site.children.template("projekte").childrenAndDrafts`  
instead of this  
`query: site.children.template("projekte").children`

gives me an _Invalid query result data_. 😕

---

<div class="post-metadata">

**Author:** ![teh](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/teh/32/9669_2.png) [@teh](https://forum.getkirby.com/u/teh)\
**Post date:** [June 2, 2020, 3:45pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/4 "2020-06-02T15:45:48Z")

</div>

This is the status part in the blueprint:

```
status:
  draft: Unveröffentlicht
  listed: Veröffentlicht
```

---

<div class="post-metadata">

**Author:** ![texnixe](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/texnixe/32/5754_2.png) [@texnixe](https://forum.getkirby.com/u/texnixe)\
**Post date:** [June 2, 2020, 5:10pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/5 "2020-06-02T17:10:40Z")

</div>

> [@teh](#):
>
> query: site.children.template(“projekte”).children

But this query gives you the right results, apart from the fact that drafts are not included?

---

<div class="post-metadata">

**Author:** ![teh](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/teh/32/9669_2.png) [@teh](https://forum.getkirby.com/u/teh)\
**Post date:** [June 2, 2020, 7:49pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/6 "2020-06-02T19:49:20Z")

</div>

yes, exactly

---

<div class="post-metadata">

**Author:** ![texnixe](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/texnixe/32/5754_2.png) [@texnixe](https://forum.getkirby.com/u/texnixe)\
**Post date:** [June 2, 2020, 7:51pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/7 "2020-06-02T19:51:02Z")

</div>

🤔

Could you please post your page structure? Think I have to test it to see what is happening.

---

<div class="post-metadata">

**Author:** ![teh](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.getkirby.com/teh/32/9669_2.png) [@teh](https://forum.getkirby.com/u/teh)\
**Post date:** [June 3, 2020, 12:19pm UTC](https://forum.getkirby.com/t/multiselect-query-get-both-unpublished-and-publish-children-pages/18408/8 "2020-06-03T12:19:18Z")

</div>

Hey, I gave it a second thought and maybe it makes more sense to only show the published items in a multiselect anyways! Otherwise it probably breaks the site. But thanks for the _childrenAndDrafts_ suggestion!