Home Forums Business Model Queries How to get distinct records in NexjOO query language.

Viewing 4 reply threads
  • Author
    Posts
    • #7775
      Ramesh Bungaramesh bunga
      Participant

      Hi
      I am trying to get distinct records from a report query as shown below.
      I am polulating the “subReportWhere” but i couldn’t get distinct records from EntityActRollup table.
      Can any one hlep on how do we retrive distinct records using NexjOO language .

      Below is the Report Query:
      (EntityActRollup ((act startTime) (act summaryStringTouchTypeReport)
      (act attachmentListSummaryString) (act attachmentIcon) )
      $P{subReportWhere}
      (((@ act startTime) . #f))
      )

      0
    • #7797
      Owen PondOwen Pond
      Participant

      Hi Ramesh,

      Just a comment before I answer your actual question. Is this a sub report? If not, then you don’t need to use the subReportWhere. You can just set the reportWhere attribute in the report command class. This way you don’t need to add the parameter $P{subReportWhere} to your query.

      0
    • #7805
      Owen PondOwen Pond
      Participant

      Hi Ramesh,

      What you would like to do is currently not supported by the NexJOO datasource.

      There is though another way to achieve what you are trying to do. Your NexJOO query can point to a proxy class. The proxy class can then take full advantage of object’read or object’aggregate. Please look here for more information about object’read.

      Do you need more information around building a proxy class?

       

      0
      • #7824
        Ramesh Bungaramesh bunga
        Participant

        Hi Owen , Thank you very much for the reply. Yes it is a Subreport . This subreport is populating data by querying EntityActRollup.
        It would be great if you shed some light on building proxy class.

        thanks in advance
        Ramesh.

        0
    • #7835
      Owen PondOwen Pond
      Participant

      Hi Ramesh,

      We are just about to publish an article on creating a proxy class. I’ll link to that as soon as it is available.

      Regards

      Owen

      0
    • #7846
      Owen PondOwen Pond
      Participant

      Here is the article

      0
Viewing 4 reply threads
  • You must be logged in to reply to this topic.