08-01-2024 03:44 PM
Hi all,
How to download the table contents from the System --> database --> Tables or Views, when I tried to download, it is allowing to download the 50 rows only - I'm not sure where is a restriction like this and how would I avoid these issues?
Thanks
08-01-2024 03:49 PM
Go to security, select your user. Go to preferences and change the Grid Rows Per Page.
HC
08-01-2024 03:51 PM
Thanks @Hector - what if I have more than 1000 rows, then how would I do it? I tried that option, it has maximum of only 1000 rows.
Thanks
08-02-2024 03:41 AM
Hi @syedfasiullah,
In that case you might want to export the content of the table to .csv via a business rule.
You could do this by getting the data you want to export into a data table object like this:
Dim dtResult As DataTable
Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
Dim strSQL As New Text.StringBuilder
strSQL.AppendLine("Select * from TableToExport")
dtResult = BRApi.Database.ExecuteSqlUsingReader(dbConnApp, strSQL.ToString, False)
End Using
And then use the DataTableToFile function that I've shared on this post:
08-02-2024 11:32 AM
Thank you for providing help, let me try this and get back to you.