I want to save prepared OpenRPT report into PostgreSQL database but OpenRPT needs "relation". What tables do I need to create and with what structure?
At a minumum you need a table called report with with the following information:
create table report (
report_id serial primary key, -- unique id (must be auto assigned)
report_name text, -- the name of the report on the database
report_descript text, -- a description of the report on db.
report_grade integer not null, -- a positive integer (rank with higher number equals better)
report_source text -- the xml text of the document
The report renderer will take a name and try to load a report from the database with that name that has the highest grade. This allows multiple versions of a report to be on a database at a given time with the same. For software vendors it can be used as a means for customers to customize database reports while allowing the vendor to be able to upgrade reports without overwritting a customers changes.
What tables are needed to store the metasql queries tot the database?
You need the MetaSQL table:
CREATE TABLE metasql (
metasql_id serial primary key,
metasql_grade integer DEFAULT 0 NOT NULL
ALTER TABLE ONLY metasql
ADD CONSTRAINT metasql_metasql_group_name_grade_key UNIQUE (metasql_group, metasql_name, metasql_grade);
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.