Skip to content

Report Analysis

Roman edited this page Aug 27, 2019 · 1 revision

Reports analysis

JAcra provides a powerful search tool for your report analysis. It can be found in the 'Reports' tab. The sample search UI view is shown below:

reports-ui.png

Search query reference

JAcra provides an SQL-like search queries language. You may use either single or double quotes to protect multi-word terms, like "Creation date" or "Memory size". Consider using a '' character to use quotes in your terms, like "Reason" like "Cannot find "Action" button".

Currently, we support the following operations:

  • Equality: =, ==, !=, /=, <>, equals, equal, eq
  • Ordering: >, >=, <, <=
  • Substring: LIKE, CONTAINS, HAS, INCLUDES
  • Logical: AND, &&, OR, ||

We're trying to make the language as useful and handy for every-day purposes of any Android developer as possible. Feel free to submit an enhancement proposal through the Issues tab if you need an operation not listed above.

Special treatment for version columns

JAcra provides special treatment for versions columns. Lexical comparison does not work for them (e.g. 1.2 is less than 1.20 in string comparison). JAcra uses special versions storage format allowing you to search among versions 'natively', e.g. 1.2 is now less than 1.20, and 1.3.5 is less than 1.4. This feature is bundled in and needs no additional configuration. Try it on the demo instance below!

Working query examples

Find all the reports for package com.example.app with version above 1.4:

AppVer > 1.4 and Package = 'com.example.app'

Find all the reports from application version 1.7.3, except for reports from the 1.4 OS version (where your function is known to be broken by OS vendor, for example):

AppVer > 1.7.3 and OsVer <> "1.4"

Find all the reports from the newer (2.x+) versions, or from old versions except for a 'broken' OS version.

AppVer >= 2 or (AppVer < 2 and OsVer <> "1.4")

Sorting results

sorting-column.png

You can sort search results by clicking on table rows. Multiple sorting is supported. If multiple columns are selected, the actual sorting is performed in order of their selection: the list will firstly be sorted by the first column clicked. Feel free to try this sorting feature at the demo instance below!

Pagination

All the search and sorting operations are cross-pageable. This means, sorting is performed in a transitive manner: neither ordering nor sorting is reset on page (or page size) changes.

Performance issues

Search is performed directly by the database engine. This may lead to the poor performance for page report storages, consider adding indices to frequently used columns manually through your DBMS tools. Please, refer to your DBMS documentation for further information. Feel free to contact us about performance issues.

Full JSON view

json-view-report.png

You can click on the arrow at the top left cell of each row to open a JSON view with all the information presented. Those unfolded views will hide automatically when layout is changed.

You can’t perform that action at this time.