In order to introduce the new features (esp multiple queries per widget) we have to simplify the cross tracker search widget structure first. Mainly removing the original search mode (aka non expert, not full TQL mode).

XLSX export

XSLX export is added to expert mode to be on par with "non expert mode". The exported file has the same columns as the table (ie from SELECT) and contains all the rows (no pagination.).

Convert non expert queries

Non expert queries are converted as full TQL. Current TQL doesn't allow to express exactly what was possible with non expert mode. For instance, non expert mode allows to select

• Bug from project Alpaca

• Stories from project Dog

During the conversion, it will be a merge of both SELECT ... FROM @project.name IN ('Alpaca', 'Dog') AND @tracker.name IN ('Bug', 'Stories').

Converted queries have no title but have a description "Converted from simple query on 'Bug from project Alpaca', 'Stories from project Dog'" (adapted depending on context obviously).

Only "always there fields" are converted to expert mode, which imply:

• Artifact column is split in two columns: Id (the artifact ID) and Tracker

• Status column is removed.

• Assigned to is also removed.

It's not possible to convert semantics "blindly" because there is a difference of behaviour between simple mode and expert mode. In expert mode if no tracker has a required semantic, it leads to an error while in simple mode it's ignore. We remove semantic to avoid conversions that could lead to an error.