How to query on form data

Forms are often used in Landscape to collect custom information about a property or work item. Occasionally those forms are designed as scorecards, management activity trackers, or for similar scenarios where summarizing the form's data points for your entire portfolio is desired or useful. This article describes how to use Data Viewer to achieve this goal.


In a new View, select the work item that you want to query on. This should be the work item where you expect to find a specific form attached, whether because the form is set up to automatically attach to that work item in Settings, or because your internal procedures dictate this workflow.

This query is searching all General Work Items where the Type is 'Property Assessment Report'

Click on 'Fields' at the top of the Results list to start selecting the columns that you want to appear in your View. Use the vertical scroll bar to get to the Form fields — they are always at the bottom of the list — or click on the clipboard icon to only show Form fields.

You will be able to sort and filter on the form field columns in the final results list. If any form fields are numeric, you will also be able to sum those columns.


Note: If the form was applied to a work item other than the type specified in your query, those responses will not be included in your results. If you suspect that may be the case, you can try querying on Form Responses instead to cast a wider net; however, you will need to use Excel to parse the form data if you want to summarize any data fields.

Still need help? Contact Us Contact Us