Basic Views: Using Queries

Queries are a slightly more advanced way of building views than using filters.  Writing queries enables you to have more control over what you're filtering out of your data.  Luckily you don't have to know any programming languages to build queries in Landscape -- you can use drop down menus and pre-populated lists to help you build the perfect View.  

Step 1: Create a View and write your Query

To make a new View, go to Views tab from the home screen.


Click on the (+) button to create a new view


A new view is created, and is called 'Ad Hoc View' by default.  Change the view category drop down menu to the category you want to query.  It is possible to expand a query to include information from other list categories, but that's a topic for a follow-up article.


You can just build the query by using the drop down menus.  The language may be intimidating at first, but just read the query like a sentence and it will tell you what it's going to find.  For example


"All of these queries are true:  Name is not No Data" will return a list of properties where the name is not blank, so the result will be a list of all properties.


"All of these queries are true:  Current Size Greater Than 100" will return a list of all properties with a current size greater than 100 acres.   

Use the plus and minus buttons to add and subtract criteria.



"Any of these queries are true: Current Size Greater Than 50 / Interest One Of Fee Simple, Conservation Easement" will return a list of all properties that are greater than 50 acres or Fee simple or Conservation Easement lands.



Change the "Any" to "All", and you get a list of all Conservation Easements and Fee Simple lands over 50 acres.

Press the check mark to apply the query and generate the list.




However, this probably isn't displaying all of the information you need.  Which brings us to...

Step 2.  Choose the fields you want to display.

Click the mceclip0.png button to the left of "Property Results" to choose what fields you'd like to display


The fields on the left are the fields that can be added to the view. The fields on the right are fields which have been added.  Dragging them up and down the list will re-arrange them left to right in the view.  Click a field on the right to remove it.


Once the view is generated, you can click the column headers to sort the results by alphabetic or numeric order, depending on the field.




Once you're done, you can save the view by clicking the cloud button next to the View name


You can save the view as a View, Report (it would then show up in 'Saved Reports'), or Dashboard, which will create a widget.  Give it a descriptive name so you can pull it up later.  It's important to remember that if you go back in and edit the view, you may need to rename the view to describe its new function.


Once you've saved a view, you can pull it up at any time by going to Views, clicking the drop down menu, and selecting the view from 'Your Views'.



Here are some examples of common views that organizations use:

All Conservation Easements.

Might look like this:


All open issues within the past year:


My monitoring assignments (Stewardship Sites where I'm the staff lead):




Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk