Q. Can a user include column values in a Query that are not present in the grid when the Query is created?
A. Not directly. The 'Column Values' listbox in the Query Builder shows a list of distinct column values currently in the grid. You cannot add your own items freehand to this list (as experience has shown that it soon gets messy with lots of alternate spellings for the same item). You can include the search text in the Ranges section.
Obviously if the Query is built at design time and shipped with the product then it can include any Column Values that the developers want to include - they don't need to be present in the grid at the time of creation.
Q. Can we add our own list of items for the Column Values listbox in the Query Builder?
A. Not at present but you will shortly. We plan to implement this feature in Q2 of 2018. Once it is implemented you will be able to listen to the event and provide your own list of column values instead fo the default alternative (which is that we create a list of all distinct items in the column).
Q. Can we re-use the same query in different Functions - e.g. create a Query in Plus / Minus and use it also in Advanced Search?
A. At present no. Each Query is tied to a single Adaptable Blotter Object and Function. We might in the future allow you to re-use Queries, but experience form Adaptable Blotter.NET shows that this easily leads to complications if not well managed. You can create User Filters and re-use them in Queries but you cannot re-use Queries themselves.
Q. I want to show details of a Search in my own control. How can I do that?
A. You can access the Advanced Search Adaptable Blotter Object from our store and have full visibility over its contents including the Query that it contains.
Q. Can we add our own filters to the list shown in a query?
A. Yes you can - but per-column only. This is achieved by using User Filters.
Q. Can a Range reference other columns e.g. Trade Date > Effective Date?
A. Yes, this feature was introduced in 1.6. When creating a range you have the choice of comparing to an absolute value or that in another column.
Q. Can a Range reference other columns and absolute values e.g. 'Bid' > ('Ask' +5)?
A. Not at the moment. But we might add this functionality in future releases.