# EM Impact CQL searching ### Overview {% content-ref url="../../../../concepts-and-fundamentals/on-a-computer/searching-filtering-and-querying-registers" %} [searching-filtering-and-querying-registers](https://docs.cw.crisisworks.com/concepts-and-fundamentals/on-a-computer/searching-filtering-and-querying-registers) {% endcontent-ref %} CQL (Crisisworks Query Language) can be used to perform advanced searches. They allow you to use structured queries to search for content. This page contains specific CQL examples for **EM Impact** reporting requirements. These can be copied and pasted into the search to find assessments that align with the EMV reporting parameters. {% hint style="warning" %} You MUST be in the correct Recovery module register for these searches to work {% endhint %} ## Query examples

### Persons queries

EMIA-1 Aboriginal/ Torres Strait Islander Impacted

In **Recovery > Persons:** ```sparql is:active atsi:Yes ```

EMIA-2 Aboriginal/ Torres Strait Islander Req’d Support

In **Recovery > Persons:** ```sparql is:active atsi:Yes AtsiCulturalSupport:[Yes,Potentially] ```

### Commercial queries

EMIA-13 Buildings Damaged Value* (excl. agriculture)

In **Recovery > Private Assets:** ```sparql is:active BuildingType:[vehicle/boat,dwelling/caravan,dwelling/flat,dwelling/holiday-rental,facility/other,structure/other,structure/shed,facility/shop] BuildingDamage:[2,3,5,1] Value:any RelatedCase:(is:active PropertyUseCommercial:Yes) ``` ^{_{\*To calculate the total damaged value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-14 Buildings Destroyed Loss (excl. agriculture)

In **Recovery > Cases:** ```sparql is:active PropertyUseCommercial:Yes PrivateAssets:(is:active BuildingType:[vehicle/boat,dwelling/caravan,dwelling/flat, dwelling/holiday-rental,facility/other,structure/other,structure/shed,facility/shop] BuildingDamage:4) ```

EMIA-15 Financial Loss value* (non-building)

In **Recovery > Private Assets:** ```sparql is:active Buildingtype:"Business Economic Impact" BuildingDamage:[4,1,3,2,5] Value:any RelatedCase:(is:active PropertyUseCommercial:Yes) ``` ^{_{\*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-16 Buildings Damaged (excl. agriculture)

In **Recovery > Cases:** ```sparql is:active PropertyUseCommercial:Yes PrivateAssets:(is:active Buildingtype:[vehicle/boat,dwelling/caravan,dwelling/flat,dwelling/holiday-rental,facility/other, structure/other,structure/shed,facility/shop] BuildingDamage:[2,3,5,1]) ```

EMIA-17 Buildings Destroyed Loss Value* (excl. agriculture)

In **Recovery > Private Assets:** ```sparql is:active BuildingType:[vehicle/boat,dwelling/caravan,dwelling/flat,dwelling/holiday-rental,facility/other,structure/other,structure/shed,facility/shop] BuildingDamage:4 Value:any RelatedCase:(is:active PropertyUseCommercial:Yes) ``` ^{_{\*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

### Infrastructure queries

EMIA-20 Local Community Facilities Damaged

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:[property,facility] DamageLevel:[2,3,5,1] ```

EMIA-21 Local Community Facilities Damaged (Loss Value*)

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:[property,facility] DamageLevel:[2,3,5,1] CostEstimate:any ``` ^{_{\*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-22 Local Community Facilities Destroyed

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:[property,facility] DamageLevel:4 ```

EMIA-23 Local Community Facilities Destroyed (Loss value*)

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:[property,facility] DamageLevel:4 CostEstimate:any ``` ^{_{\*To calculate the total destroyed value, export the resulting records to a report. Ensure the 'Approximate damage value' field is included in the export. The total value can then be calculated by summing this field in the downloaded file.}}

EMIA-34 Municipal Bridges Damaged

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:bridge DamageLevel:[2,3,5,1] ```

EMIA-35 Municipal Bridges Destroyed

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:bridge DamageLevel:4 ```

EMIA-36 Municipal Culverts & Drainage Struct. Damaged

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:[stormwater-pipe,stormwater-pit,culvert] DamageLevel:[1,3,2,5] ```

EMIA-37 Municipal Culverts & Drainage Struct. Destroyed

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:[stormwater-pipe,stormwater-pit,culvert] DamageLevel:4 ```

EMIA-38 Municipal Roads Damaged

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:road DamageLevel:[1,3,2,5] ```

EMIA-39 Municipal Roads Destroyed

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:road DamageLevel:4 ```

EMIA-40 Municipal Trails/Walkways Damaged

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:trails-walkway DamageLevel:[1,3,2,5] ```

EMIA-41 Municipal Trails/Walkways Destroyed

In **Recovery>** **Infrastructure:** ```sparql is:active InfrastructureType:trails-walkway DamageLevel:4 ```

EMIA-42 Municipal Roads Damaged (distance)

See EMIA-38

EMIA-43 Municipal Roads Destroyed (distance)

See EMIA-39

EMIA-44 Municipal Trails/Walkways Damaged (distance)

See EMIA-40

EMIA-45 Municipal Trails/Walkways Destroyed (distance)

See EMIA-41

### Residential queries

EMIA-77 Primary Private Residences (Damaged, habitable)

In **Recovery > Private Assets:** ```sparql is:active BuildingDamage:[1,3,5] PrimaryPlaceOfResidence:Yes RelatedCase:(is:active) ```

EMIA-78 Primary Private Residences (Damaged, uninhabitable)

In **Recovery > Private Assets:** ```sparql is:active BuildingDamage:[2,3,5] PrimaryPlaceOfResidence:Yes RelatedCase:(is:active) ```

EMIA-79 Primary Private Residences (Destroyed)

In **Recovery > Private Assets:** ```sparql is:active BuildingDamage:4 PrimaryPlaceOfResidence:Yes RelatedCase:(is:active) ```

EMIA-80 Non-Primary Private Residences (Damaged, habitable)

In **Recovery > Private Assets:** ```sparql is:active PrimaryPlaceOfResidence:No BuildingCategory:dwelling BuildingDamage:[1,3,5] RelatedCase:(is:active) ```

EMIA-81 Non-Primary Private Residences (Destroyed)

In **Recovery > Private Assets:** ```sparql is:active PrimaryPlaceOfResidence:No BuildingCategory:dwelling BuildingDamage:4 RelatedCase:(is:active) ```

EMIA-82 Non-Prim Private Residences (Damaged, uninhabitable)

In **Recovery > Private Assets:** ```sparql is:active PrimaryPlaceOfResidence:No BuildingCategory:dwelling BuildingDamage:[2,3,5] RelatedCase:(is:active) ```