Export List of system fields

Dear Danilo,

Unfortunately, there is no place you can export all the system fields from. You can install SQL-executor from the Marketplace and execute the select queries with it to be able to view the content of the database tables and the fields that are used there.

We are planning to add the list of all the objects and field used in the system someday but there is no ETA for the task yet.  

Lisa

Thanks Lisa. I will give a try to the SQL executor

The SQL executor was enough for me

Dear Bryan,

There is no way to export the fields or columns that are in a table using SQL executor from the Marketplace. You can only view them. As for a queries, you may use basic ones that are enough to see the table content. For instance if you want to see the fields and columns in the Contact table, run 'select * from Contact', etc. As of the export option, our R&D team already accepted the idea of adding the list of all objects and fields for export, still we do not know when exactly it will be implemented. 

Best regards, 

Dean

We were able to export the feed, are you saying we can't do all of the columns?

Dear Bryan,

Thank you for the reply. I'm so sorry, I mislead you. I was using the older version of the SQL executor. Just updated to the latest one, which has the option 'Export to csv'. Using this option you can export all the records and columns from the table as well as the feed. 

Best regards,

Dean

Great! Can you provide the query to export everything at once?

Bryan Baker,

Hello,

There is no SQL-query that allows selecting all records from all tables and that's why it cannot be done. It is not something that bpm'online doesn't support. It is something that cannot be handled by SQL language itself. You need to run select queries one by one for all tables in the application (you can get a list of all system tables of the database using select * from sys.tables query) and export results for each query.

Best regards,

Oscar

This marketplace package installs a process you can run to export the entire system schema in an Excel file: 

https://marketplace.bpmonline.com/app/object-structure-export-bpmonline

Ryan