Use Advanced search to find specific components or references using field values. You can do simple searches or search for multiple data sets for more specific results.
When building a query using Advanced search, you can choose to search for components or references and whether you wish the results to match all or any of the rules you defined.
Moreover, you can search for components or references of a certain type or with specific field values. For example:
Components in workspace “Application services” that don’t have a “Criticality” value
References of type “Uses” that have a specific tag
Components that are either “Capability” or “Strategic Capability”
Components that have the “State” field with the value “AS-IS” and are either an “Application” or a “Service”
Components that were created in October
Table of Contents:
Simple Search
Find components based on one rule only. For instance, you can search for all components with a specific field value.
Multiple data sets
You can also search for multiple data sets by adding as many rules or subqueries as you need. For instance:
Components that have the “State” field with the value “AS-IS” and are either an “Application” or a “Service”.
How to Find Components and References Using Advanced Search
There are two ways in which you can access Advanced search. From:
Using Advanced Search From Analytics > Advanced Search
To build and Advanced search query from the Analytics menu:
Hover over the "Analytics" icon on the left side bar menu and select "Advanced search".
Choose to search for components or references and whether you wish the results to match all or any of the rules you defined.
Next, select a field and an operator. For example, "equal to" or "not equal to".
Add more rules or subqueries to refine your search.
Click "Search" and see the results below the Advanced search query builder.
From here, you can export your search results as an .xls file or create a report by clicking on the "Create report" button at the top right corner of the screen. It will take you to the Report Builder.
Using Advanced Search From the Report Builder
To create an Advanced search report, see our detailed guide on how to create a report here or follow the steps below:
Navigate to the Home page or the Report Overview page.
From the Home page, click on "Create new > Report" at the top right corner of the screen. From the Report Overview page, select "Create new".
Select "Advanced search" in the first step of the Report Builder.
Select the workspace(s) you wish to query.
Choose to search for components or references and whether you wish the results to match all or any of the rules you defined.
Build your query.
Click "Next" and see your search results.
How to Export Advanced Search Results
From Analytics > Advanced search: You can export your Advanced search results as an .xls file (import format) from the Analytics menu by clicking the "Export to Excel" button at the top right corner of the screen.
From the Report reader: Open a report or create and save one to access the Report Reader. From there, click on the export icon to the right top corner of the screen and choose:
Export to Excel (report data only) when you need to download an .xls file that includes the selected columns in the report only and lists names instead of IDs for source, type, target, and reference columns.
Export to Excel (import format) when you need to re-import the .xls file into Ardoq using the Excel integration
JSON when you need the data in a computer readable format
Troubleshooting
You have added or removed a field that is being used in a report or a dashboard chart.
This may cause one of the following things:
Your report or chart is showing 0 results
Your chart is showing a number instead of a sum or average
Your chart is showing different periods of history for different fields
My report is not returning any results anymore.
You have had a report for a long time that usually had returned results, but suddenly it gives 0 results. This may be because you have removed a field on that component or reference that was specified in the search.
For example, if you have searched for “All components with a criticality of High” and you remove the criticality field and replace it with two fields (“Criticality list” and “Criticality number”) the original search will not return any values because there are no components with the“Criticality” field.
My dashboard chart is not showing the full history.
When you save a query, we start snapshotting it on a nightly basis. Still, you might have an incomplete history because you have added a field to your component or reference at a later point.
How does historical data work in reports, and how can I preserve it when moving or modifying charts.
Historical data in reports is tied directly to the report itself, not the chart or dashboard. If you modify or recreate a chart or report in a different dashboard, the historical data may not appear because the history is linked to the original report.