Report based on solr

1

HI,
You need to be more specific about your question.
Data from item lists are indexed by solr and can also be searched using search.

I agree, my question is not precise enough.
I need to add a column to a report from a list of items. I am looking for a solution to this issue.

Showing data from an item list column on a solr report may be problematic, at least I can't answer whether using some query for a calculated column can achieve this.
But you can approach the topic differently, if it meets your requirements. You can create a multi-line field and update this field with data from the list of items, properly formatted into an HTML table.
Then display this field as a column in the solr report. example below.

Regards.

Good idea :)
Thank you for your reply. Unfortunately the table has a very large number of rows :(

Maybe subworkflows for each list item and display these elements on the report (along with data from the main workflow),
more work to create and maintain, but you can get the desired effect

Regards

Maybe someone knows how to return in the calculated SOLR column, concatenated all rows of one column and display in single row of the report.

Hi Radoslaw,

Although it's not the best solution from a performance point of view, you can add grouped data from an item list with the calculated column on a regular report. I didn't try it yet on a SOLR report but I suspect it should work the same.

Here is the SQL for the calculated column:

(
SELECT COUNT(*) FROM WFElementDetails
WHERE DET_WFDID = WFElems.WFD_ID
AND DET_Att3 = 1
)

Attached also an image.

Hope it helps.

Wow, this is nice! Never thought of it. Thanks for the idea! :)