> ## Documentation Index
> Fetch the complete documentation index at: https://docs.fieldiu.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Advanced Find "Readings Example"

> ### 💡 Reading Report
>
> Here is an example of a report that provides the following information:
>
> * Work Order
>
> * Work Order Booking
>
> * Reading Name
>
> * Point Type
>
> * Action
>
> * Resource
>
> We will group the report by:
>
> * Work Order
>
> * Point Type
>
> We will filter the report to include only completed work order bookings.

### 1. Select Reading Table

<img src="https://mintcdn.com/fieldiu/AWln65_P7KuC5v3X/images/99a41356-e935-4d54-924f-4850c433995b.png?fit=max&auto=format&n=AWln65_P7KuC5v3X&q=85&s=ed89b5fd2475880390bc8364cb92ab53" alt="" width="607" height="157" data-path="images/99a41356-e935-4d54-924f-4850c433995b.png" />

### 2. Selecting Columns

Simply click the columns button and select the columns you want.

<img src="https://mintcdn.com/fieldiu/ASkbXz2A7i_wG3wf/images/038d23a6-3c5b-4322-b498-ffc03c9c0a62.png?fit=max&auto=format&n=ASkbXz2A7i_wG3wf&q=85&s=bf10568f26171bfd5455d3871d836467" alt="" width="603" height="236" data-path="images/038d23a6-3c5b-4322-b498-ffc03c9c0a62.png" />

### 3. Columns

For our example, we will select the following:

**Reading Table:**

* Work Order

* Work Order Booking

* Reading Name

* Point Type

* Action

**From Work Order Booking** (which is related to the Reading Table):

* Resource

<img src="https://mintcdn.com/fieldiu/1sFvM1xYsLMj5iCS/images/b58ad895-a7ee-4b8e-bc34-f9090f77b583.png?fit=max&auto=format&n=1sFvM1xYsLMj5iCS&q=85&s=37a670300caa91433575d4f5a73d62db" alt="" width="768" height="367" data-path="images/b58ad895-a7ee-4b8e-bc34-f9090f77b583.png" />

### 4. Click on OK

<img src="https://mintcdn.com/fieldiu/GgdB9rxDgC_7q1qM/images/6e9761ab-d0f4-4c83-8cc5-8879c60d26e2.png?fit=max&auto=format&n=GgdB9rxDgC_7q1qM&q=85&s=1716183247c05519e36083907a23d3f7" alt="" width="768" height="367" data-path="images/6e9761ab-d0f4-4c83-8cc5-8879c60d26e2.png" />

### 5. Grouping & Aggregate

Now, let's group it by clicking on **Grouping & Aggregate** Button.

<img src="https://mintcdn.com/fieldiu/1sFvM1xYsLMj5iCS/images/d484ef06-edf6-4288-bc73-1cd7010a8e17.png?fit=max&auto=format&n=1sFvM1xYsLMj5iCS&q=85&s=f67083b55dd3e226d110fab781225e22" alt="" width="574" height="277" data-path="images/d484ef06-edf6-4288-bc73-1cd7010a8e17.png" />

### 6. Grouping

Group By:

* Work Order

* Point Type

<img src="https://mintcdn.com/fieldiu/I0KX1uEaTN8rxrHM/images/8d05f771-6d4f-4936-aea8-5e7020000959.png?fit=max&auto=format&n=I0KX1uEaTN8rxrHM&q=85&s=b4cff5badf298ad5274911a50cf062f1" alt="" width="768" height="367" data-path="images/8d05f771-6d4f-4936-aea8-5e7020000959.png" />

### 7. Click on OK

<img src="https://mintcdn.com/fieldiu/GS4rQPdzw48eDklV/images/2b933a21-aa48-4aa3-a11f-c87d990e61c6.png?fit=max&auto=format&n=GS4rQPdzw48eDklV&q=85&s=a0ec54556a1f7b1c13ba44f69f55980a" alt="" width="530" height="518" data-path="images/2b933a21-aa48-4aa3-a11f-c87d990e61c6.png" />

### 8. Quick Review

It seems we have all the data we need in our example.

<img src="https://mintcdn.com/fieldiu/ASkbXz2A7i_wG3wf/images/043d9dcb-390b-48ea-9cc3-c906328c6d47.png?fit=max&auto=format&n=ASkbXz2A7i_wG3wf&q=85&s=f7aeb951fe221fb2c0007efb2cffe44e" alt="" width="1920" height="917" data-path="images/043d9dcb-390b-48ea-9cc3-c906328c6d47.png" />

### 9. Filtering

<img src="https://mintcdn.com/fieldiu/ASkbXz2A7i_wG3wf/images/1b3406d8-196c-4e03-880f-2644198d679d.png?fit=max&auto=format&n=ASkbXz2A7i_wG3wf&q=85&s=04b802d41867536200ca357e9d14b860" alt="" width="434" height="260" data-path="images/1b3406d8-196c-4e03-880f-2644198d679d.png" />

### 10. Creating Our Filter

Let’s set up our filter for booking status. We will apply the filter to show only records where the booking status is equal to "Completed."

<img src="https://mintcdn.com/fieldiu/GgdB9rxDgC_7q1qM/images/6ff5e4a0-fbe7-4eec-9b98-be93b298dc1f.png?fit=max&auto=format&n=GgdB9rxDgC_7q1qM&q=85&s=faa24c6aa5d498d27208a26552c73fe1" alt="" width="1267" height="669" data-path="images/6ff5e4a0-fbe7-4eec-9b98-be93b298dc1f.png" />

> ### 💡 Linked Entity "Tables"
>
> Since we have selected the Resource column from the Work Order Booking table (which is related to the Reading table), the Work Order Booking is already linked.
>
> If we didn't select the Resource column but want to filter by booking status, we can click on the link button, select the Work Order Booking table, and set our criteria.

### 11. The Resault

Now we have the report grouped and organized with the data we want, and it is ready to export or print.

<img src="https://mintcdn.com/fieldiu/AWln65_P7KuC5v3X/images/b1243eeb-ef2e-4d53-bbad-2ead9faa8998.png?fit=max&auto=format&n=AWln65_P7KuC5v3X&q=85&s=9bc4c34246e8dffe062c72e942007c22" alt="" width="1920" height="917" data-path="images/b1243eeb-ef2e-4d53-bbad-2ead9faa8998.png" />

### 12. Don't forget to save your Report.

<img src="https://mintcdn.com/fieldiu/AWln65_P7KuC5v3X/images/9151f312-cc6f-42b2-8cc7-ad47bbc149b4.png?fit=max&auto=format&n=AWln65_P7KuC5v3X&q=85&s=80265b0e6530894800909b0fc0ff4214" alt="" width="768" height="367" data-path="images/9151f312-cc6f-42b2-8cc7-ad47bbc149b4.png" />�����������������������
