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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Tue, 11 September 2018 07:02

Mikolaj Habdank

Messages: 3
Registered: September 2018

Junior Member

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

Report message to a moderator

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

Thu, 13 September 2018 20:42

Andrew Johnson

Messages: 205
Registered: July 2009

Senior Member

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

Report message to a moderator