Home > Forum > General > Calcuted Columns in Solr Reports

Calcuted Columns in Solr Reports
1

WEBCON

Hi Raluca,

Calculated columns are added to SearchIndex reports the same way they're added to SQL-based reports, but the difference is that you have to use Solr syntax.
First, you have to know what are the names of fields in Solr collections. You can check it by querying BPS_Elements collection in Solr admin page (example: instance creation date in SQL is stored in "WFD_TSInsert" column, but in Solr it is stored in "TS_Insert" field. There are other differences).
Then, to compare values and use conditions, you have to use Solr functions based on https://solr.apache.org/guide/solr/latest/query-guide/function-queries.html

I've attached screenshots with an example of an indicator that shows if an instance was modified in 2025.
It calculates a difference between TS_Insert and 2025-01-01 00:00:00, checks if the value is less or equal to 0, then returns "2" if statement if true or "0" if it's not.
It is a silly example to show the syntax.

Kind regards

WEBCON
In reply to: Wojciech Włodarczyk

AND how does this relate to item list columns? how do you bite it?

Lack of item lists is one of the known limitations of SearchIndex reports.
I've tried to fetch it using a calculated column (the Solr field name is "SUBS__{id}_SubElems"), but I failed because of the way it is stored in a collection.
I'm not sure whether this is possible at all in the current state.

MVP
In reply to: Konrad Keppert (WEBCON)

Lack of item lists is one of the known limitations of SearchIndex reports.
I've tried to fetch it using a calculated column (the Solr field name is "SUBS__{id}_SubElems"), but I failed because of the way it is stored in a collection.
I'm not sure whether this is possible at all in the current state.

Hi Konrad,

can you elaborate on which other known limitations there are?
One obvious one would be that it may take (a little) time until an updated workflow instance has been processed in the queue.
Item lists are a second one.
A third one would (probably) be, that we can only fields of the current workflow instance.

Thanks for providing the link to the query functions. I will have to take a look at those. :)

Best regards,
Daniel

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.