# Advanced Queries for Lines

**URL:** <https://forum.manager.io/t/advanced-queries-for-lines/52861>\
**Category:** Uncategorized\
**Created:** [April 15, 2024, 2:44pm UTC](https://forum.manager.io/t/advanced-queries-for-lines/52861 "2024-04-15T14:44:59Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [April 15, 2024, 2:44pm UTC](https://forum.manager.io/t/advanced-queries-for-lines/52861/1 "2024-04-15T14:44:59Z")

</div>

Continuing the discussion from [Sales Invoices - Lines screen and Advanced Queries, New from duplicate](https://forum.manager.io/t/sales-invoices-lines-screen-and-advanced-queries-new-from-duplicate/52658/4):

`Advanced Queries` is proving to be a powerful reporting tool in Manager, however, compared to `Custom Reports`, it lacks in one major area, namely, joining/merging tab data to line data.

For example, using `Custom Reports` we are able to query **Purchase Invoices** and filter by both document level `Custom Field` as well as with line level `Division`.

In `Advanced Queries`, however, you can only use document level `Custom Field` on tab data or use line level `Division` on line data, **but not both**.

The only solution is to run two advanced queries, copy to clipboard and then stitch them together in a spreadsheet.

@lubos Is there a plan to enable the joining of tab and lines data?

---

_[View the full topic](https://forum.manager.io/t/advanced-queries-for-lines/52861)._