# DP1 Portal tutorial 106.1 missing ADQL

**URL:** <https://www.rubin.community/t/dp1-portal-tutorial-106-1-missing-adql/11586>\
**Category:** Support\
**Created:** [February 10, 2026, 10:19pm UTC](https://www.rubin.community/t/dp1-portal-tutorial-106-1-missing-adql/11586 "2026-02-10T22:19:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![solontoi](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/solontoi/32/1173_2.png) [@solontoi](https://www.rubin.community/u/solontoi)\
**Post date:** [February 10, 2026, 10:19pm UTC](https://www.rubin.community/t/dp1-portal-tutorial-106-1-missing-adql/11586/1 "2026-02-10T22:19:06Z")

</div>

DP1 Portal tutorial **106.1 Upload a table and spatially cross-match** asks the user to leave the ADQL query as the default, but if someone has been following the tutorials sequentially that query has long since been overwritten.

---

<div class="post-metadata">

**Author:** ![MelissaGraham](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/melissagraham/32/2549_2.png) [@MelissaGraham](https://www.rubin.community/u/MelissaGraham)\
**Post date:** [February 11, 2026, 8:13pm UTC](https://www.rubin.community/t/dp1-portal-tutorial-106-1-missing-adql/11586/2 "2026-02-11T20:13:07Z")

</div>

Hi @solontoi, thanks for reporting an issue with [Portal tutorial 106.1](https://dp1.lsst.io/tutorials/portal/106/portal-106-1.html).

That particular tutorial doesn’t use ADQL but I inferred that the ambiguity was in step 2, where it said “_Leave the default table selection_”. I’ve updated that statement to say “_To ensure this user interface is set to the default: select the “dp1.Object” table from the right-hand drop-down menu and click “Reset Column Selection and Constraints” at upper right_”.

If the above doesn’t resolve the issue, please unmark this post as the topic’s solution and let me know how best to fix Portal tutorial 106.1?

---

<div class="post-metadata">

**Author:** ![solontoi](https://sea2.discourse-cdn.com/flex002/user_avatar/www.rubin.community/solontoi/32/1173_2.png) [@solontoi](https://www.rubin.community/u/solontoi)\
**Post date:** [February 11, 2026, 10:01pm UTC](https://www.rubin.community/t/dp1-portal-tutorial-106-1-missing-adql/11586/3 "2026-02-11T22:01:48Z")

</div>

Perfect - that clears it completely up, the similar language from the previous tutorials using ADQL likely led to my confusion. Much appreciated!