Posts made by hotaru-ritsuki

Hi everyone,

I'm using jsreport with the jsreport-postgres-store extension to store my templates in a PostgreSQL database. My goal is to keep all jsreport-related tables within a separate schema (named pdf_template) rather than the default public schema.

Here is the relevant part of my jsreport.config.json:

{
  "httpPort": 5500,
  "store": {
    "provider": "postgres"
  },
  "blobStorage": {
    "provider": "postgres"
  },
  "reportTimeout": 600000,
  "workers": {
    "numberOfWorkers": 2
  },
  "extensions": { 
    "postgres-store": {
      "host": "localhost",
      "port": 5432,
      "database": "report", 
      "user": "postgres",
      "password": "postgres",
      "schema": "pdf_template",
      "prefix": "jsreport_",
      "schemaCreation": true,
      "ssl": false
    }
  }
}

I noticed that while most tables are created in the pdf_template schema as expected, the table for blob storage (jsreport_blob) ends up in the public schema.

I looked into the jsreport source code and saw that it uses pg-promise for PostgreSQL connections, and it appears that the schema parameter is passed on correctly for most of the queries. However, it seems like the blob storage table isn’t respecting the schema setting.

I'm using jsreport and jsreport-postgres-store latest versions.

Are there any workarounds or fixes for it? Any insights or suggestions would be greatly appreciated!

Thanks in advance for your help.

Sorry, wrong link

Here's link to playground : Playground

Hey!

Currently, I have a table and a chart. The table can exceed page size causing some content to be on another page and that's ok. The problem is that the chart should be strongly linked to a table and if the table exceeds page size and part of it is moved to the next page - chart should be repeated on the next page.

A solution that I have is to render the chart template and merge it to every page of the table's template. But that seems pretty odd since I'm using the 'render for every page' method which is deprecated and also I want to have that component to be single and not to be reliable on template merging.

Please advise if there are any other ways to achieve the same behavior and to have everything under the same component.

JSReport Online Studio for mentioned templates