Eclipse Community Forums: Memory Analyzer » MAT report with all rows from query (more than 25)

Home » Eclipse Projects » Memory Analyzer » MAT report with all rows from query (more than 25)

MAT report with all rows from query (more than 25) [message #1794921]

Tue, 11 September 2018 03:02

Eclipse User

Hi

I'm trying to get all rows from OQL query in MAT:

SELECT l.specificRecord.record_id.value FROM OBJECTS ( SELECT OBJECTS a.@referenceArray FROM OBJECTS 1112896 a ) l

where value is just Long
I've already created this:

<section name="Record Id">
<section name="Record Id">
<param key="html.separate_file" value="true" />
<template>org.eclipse.mat.api:overview</template>
</section>
<query name="record ids">
<command>oql "SELECT l.specificRecord.record_id.value FROM OBJECTS ( SELECT OBJECTS a.@referenceArray FROM OBJECTS 1112896 a ) l "</command>
</query>
</section>

but I get only HTML report with 25 rows
How can I get more than 25 objects?

Best

Mikolaj

Re: MAT report with all rows from query (more than 25) [message #1795065 is a reply to message #1794921]

Thu, 13 September 2018 16:42

Eclipse User

Try using a limit like

<param key="limit" value="200" />

as follows:

<section name="Record Id">
<section name="Record Id">
<param key="html.separate_file" value="true" />
<template>org.eclipse.mat.api:overview</template>
</section>
<query name="record ids">
<param key="limit" value="200" />
<command>oql "SELECT l.specificRecord.record_id.value FROM OBJECTS ( SELECT OBJECTS a.@referenceArray FROM OBJECTS 1112896 a ) l "</command>
</query>
</section>

The possible parameters are briefly documented here:
http://help.eclipse.org/photon/topic/org.eclipse.mat.ui.help/doc/org/eclipse/mat/report/Params.html
http://help.eclipse.org/photon/topic/org.eclipse.mat.ui.help/doc/org/eclipse/mat/report/Params.Html.html
http://help.eclipse.org/photon/topic/org.eclipse.mat.ui.help/doc/org/eclipse/mat/report/Params.Rendering.html

Re: MAT report with all rows from query (more than 25) [message #1795073 is a reply to message #1795065]

Fri, 14 September 2018 02:24

Eclipse User

Thanks this solution works as intended. Additional configuration options from docs are very useful.

Previous Topic:	Huge heap dump, but no content?
Next Topic:	MAT report from command line

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Nov 07 05:49:38 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter