export limit for database view

[Aka Guglielmo]

Hi,

I just figured out that, when I export data from database views, it exports only the first 10,000 records.

Even if I edit the value of the limit system property, the result doesn't change.

Any idea?

Thanks

Regards,

[SanjivMeher]

Change the property value glide.db.max_view_records and try to export. If the property doesnt exists, create it.

[Alikutty A]

A property called glide.db.max_view_records controls the maximum number of rows returned when running a GlideRecord query in a script. The default value for this property is 10,000. To change this value, add the property to the System Property [sys_properties] table and edit the number of rows to return.

This property only applies when querying a database view table in a script. When displaying the database view table in a list or report, this property does not apply.

http://wiki.servicenow.com/index.php?title=Database_Views#Task_4:_Specify_the_Number_of_Records_to_R...

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[Aka Guglielmo]

massimiliano check this out!