limits of list and JSON in advanced emcli scripting

Hi,

I am using  emcli scripting av I have found a strange thing with limits on use of list commands.

The reason I ask is that I am trying to get out the target properties and since I have almost a total of 100.000 properties from all targets I was trying to limit the selection.

I have tried to use list with resource='TargetProperties' but this is being capped by the max_fetch_rows...

target = list(resource='TargetProperties').out()['data']

So I thought I could use a sql against a mgmt$ views and limit the selection, example:

l_sql = "select * from mgmt$target_properties"