# Getting a list of all query expressions

**URL:** <https://meta.ip-tools.org/t/getting-a-list-of-all-query-expressions/119>\
**Category:** Documentation / Dokumentation\
**Created:** [February 9, 2019, 2:47am UTC](https://meta.ip-tools.org/t/getting-a-list-of-all-query-expressions/119 "2019-02-09T02:47:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andreas.Motl](https://meta.ip-tools.org/user_avatar/meta.ip-tools.org/andreas.motl/32/7_2.png) [@Andreas.Motl](https://meta.ip-tools.org/u/Andreas.Motl)\
**Post date:** [February 9, 2019, 2:47am UTC](https://meta.ip-tools.org/t/getting-a-list-of-all-query-expressions/119/1 "2019-02-09T02:47:21Z")

</div>

Researchers asked us about whether there’s a way to retrieve the full list of query expressions conducted during a research session about a specific topic.

The background of this request is that users’ customers are usually asking about a report document which outlines more details about the research procedure.

---

<div class="post-metadata">

**Author:** ![Andreas.Motl](https://meta.ip-tools.org/user_avatar/meta.ip-tools.org/andreas.motl/32/7_2.png) [@Andreas.Motl](https://meta.ip-tools.org/u/Andreas.Motl)\
**Post date:** [February 9, 2019, 3:03am UTC](https://meta.ip-tools.org/t/getting-a-list-of-all-query-expressions/119/2 "2019-02-09T03:03:35Z")

</div>

PatZilla offers a comprehensive export feature which already supports such things. We’d like to outline how you would work with that.

* * *

## Export dialog

After hitting the export button at the bottom of the project control widget …  
 ![image](https://meta.ip-tools.org/uploads/default/original/1X/c9c1a969dd2949d89a98a593c5792b00820035a5.png)

and selecting the “Office Workbook” output format like …

 ![image](https://meta.ip-tools.org/uploads/default/original/1X/0426ddcdea75b541915e53fccd2fb9741afcff37.png)

* * *

## Output examples

PatZilla will offer a `.xlsx` file for download. On the second worksheet called `queries` …  
 ![image](https://meta.ip-tools.org/uploads/default/original/1X/1d256a078f2ba6cc3bc05a51f87cf41c7a802d58.png)

you will be able to see the **list of all query expressions** used during the research session associated with the selected project, together with the **number of hits** , the **datasource name** and the **time** at which the search was conducted:

 ![image](https://meta.ip-tools.org/uploads/default/original/1X/c38fae7b8f15e447451ed82b9ff83abba53ce9e9.png)

---

<div class="post-metadata">

**Author:** ![Andreas.Motl](https://meta.ip-tools.org/user_avatar/meta.ip-tools.org/andreas.motl/32/7_2.png) [@Andreas.Motl](https://meta.ip-tools.org/u/Andreas.Motl)\
**Post date:** [February 9, 2019, 3:14am UTC](https://meta.ip-tools.org/t/getting-a-list-of-all-query-expressions/119/3 "2019-02-09T03:14:08Z")

</div>

If you need this information in different output formats, feel free to …

1. Select the “Zip archive” output format.  
 ![image](https://meta.ip-tools.org/uploads/default/original/1X/4e77a42f051f80ab68121108a93341e7636ecc89.png)

2. Choose from one or more report formats.  
 ![image](https://meta.ip-tools.org/uploads/default/original/1X/3611cec434dad9461c3a81a7c3fad68a60d5e511.png)

3. Enjoy a comprehensive Zip archive offered for download, which contains the requested information in different files and folders.

---

<div class="post-metadata">

**Author:** ![Andreas.Motl](https://meta.ip-tools.org/user_avatar/meta.ip-tools.org/andreas.motl/32/7_2.png) [@Andreas.Motl](https://meta.ip-tools.org/u/Andreas.Motl)\
**Post date:** [February 9, 2019, 3:15am UTC](https://meta.ip-tools.org/t/getting-a-list-of-all-query-expressions/119/4 "2019-02-09T03:15:01Z")

</div>

# Examples at a glance

## Office Workbook

 ![image](https://meta.ip-tools.org/uploads/default/original/1X/c38fae7b8f15e447451ed82b9ff83abba53ce9e9.png)

## CSV

```auto
criteria,expression,hits,datasource,timestamp
"{""inventor"": ""\""Edison Thomas\""""}","in=(""Edison Thomas"")",582,ops,2019-02-09T03:14:25+01:00

```

## JSON

```auto
[
    {
        "timestamp": "2019-02-09T03:14:25+01:00", 
        "hits": 582, 
        "expression": "in=(\"Edison Thomas\")", 
        "datasource": "ops", 
        "criteria": "{\"inventor\": \"\\\"Edison Thomas\\\"\"}"
    }
]

```
