Pentaho

 View Only

  • 1.  Pentaho Report Designer 9.3 Sort Tables/Views in Query Designer

    Posted 02-21-2024 16:34
      |   view attached

    I am new to this community and to Pentaho Report Designer 9.3 but I have been using PRD since 5.x I am currently on 6.1 preparing to migrate to 9.3 or 10.x

    I am using PRD as a supplement to our EHR system CareLogic (developed and maintained by Qualifacts+Credible) designing customized reports

    Has anyone encountered the feature in Pentaho Report Designer 9.3 Query Designer where the Tables/Views are not sorted alphabetically as they are in 6.1?  At last estimation I counted over (700) tables makes it difficult to find a table especially if I am not certain which table I am looking for as when I first started with 9.3

    I am happy with PRD it is a good product stable and reliable it so far has done everything we needed it to do



    ------------------------------
    Laroy Rizley
    Others
    DP Data Services
    ------------------------------


  • 2.  RE: Pentaho Report Designer 9.3 Sort Tables/Views in Query Designer

    Posted 02-23-2024 05:16

    Hi Laroy,

    IMHO this depends on used JDBC driver. I checked in v9.4 MariaDB driver v3.1.4 and tables are sorted.



    ------------------------------
    Petr Prochazka
    Systems Engineer
    P.V.A. systems s.r.o.
    ------------------------------

    Original Message


  • 3.  RE: Pentaho Report Designer 9.3 Sort Tables/Views in Query Designer

    Posted 02-23-2024 18:16

    Thank you Petr for your reply and your consideration that is appreciated.  I am not certain what flavor of DB is being used I believe it is some variation of Apache Hive SQL.  The JDBC that was provided to me I believe is a custom driver developed by the software vendor Qualifacts.  So are you thinking it might be something about their JDBC driver?  They are saying it is not their issue it is an issue with the software.



    ------------------------------
    Laroy Rizley
    Others
    DP Data Services
    ------------------------------

    Original Message


Related Content