How to get distinct records in NexjOO query language.

[ramesh bunga]

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

[Owen Pond]

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

[Owen Pond]

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

[ramesh bunga]

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

[Owen Pond]

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

[Owen Pond]

Here is the article

0

[Author]

Posts