Skip to main content
J
JensN.1-Visitor
1-Visitor
May 2, 2016
Question

How to get the number of query-results into a report

  • May 2, 2016
  • 1 reply
  • 2104 views

Hi @all,

the base for a report is mostly (always?) a query. I would like to state in the header of the report how many results this report includes?

Thanks, Jens

    1 reply

    K
    KaelLizak16-Pearl
    16-Pearl
    May 5, 2016

    Hello Jens-Uwe Nixdorf,

    That could get interesting, depending on the nature of the report.  If it's a mutli-level relationship walking report, the results could potentially contain many more items than there are results in the query (in the form of child items), and those child items could well be duplicated under several parents.

    I suspect the easiest way to do this is with JavaScript, but I don't have the details myself.

    Regards,
    Kael

      J
      JensN.1-VisitorAuthor
      1-Visitor
      May 9, 2016

      Hi Kael,

      thanks for your answer. Maybe i could count the results by myself with Javascript in the recipe or so, in the first step only for the initial query-results without counting the relationship walking. But i would prefer to get this information directly from Integrity, because i think that Integrity should already know how much results the query is giving.

      kind regards, Jens

      K
      KaelLizak16-Pearl
      16-Pearl
      May 9, 2016

      Hi Jens-Uwe Nixdorf‌,

      I agree, it does look like something Integrity should have, and which should be fairly easy to get.  Unfortunately, that doesn't seem to be the case:  I took a second look at our R&D system.  It looks like there was once an old request for exactly that as an enhancement.  There is no workaround listed, and no customer has requested this information since we switched to KCS (our current KB system).

      It seems that the best way at this point to make Product Management aware of this request is to submit an Idea for it.

      Regards,
      Kael

      Terms & ConditionsAccessibility statement