当前位置：文江博客话题详情

外部化 BIRT 查询

发布于 2024-08-24 15:29:31 字数 92 浏览 3 评论 0原文

有没有办法外部化 BIRT 报告的报告查询。我们需要支持多个数据库引擎，因此我们的查询根据底层数据库的不同而不同。我想使用配置参数来告诉 BIRT 报告使用特定的查询文件

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

耳钉梦 2024-08-31 15:29:31

当然可以。如果您在报告本身中编写一些 JavaScript，它可以访问磁盘上的文件以检索文本查询并在执行之前修改查询。

您需要为其编码的事件是数据源上的 beforeOpen。实际上，我们通过检测通配符参数是否设置为 "*" 并动态调整 SQL 查询，将其从：更改

select A from B where C = ?

为：

select A from B where ((C = ?) or (1==1))

丑陋的修改只是为了让我们不必担心改变位置参数。

您可以从磁盘文件中读取一行并使用以下内容更改查询：

try {
  var fip0 = new Packages.java.io.FileInputStream("/query.txt");
  try {
    var fip1 = new Packages.java.io.DataInputStream(fip0);
    try {
      queryText = fip1.readLine() + "";
    } catch(e1) {}
    fip1.close();
  } catch(e2) {}
  fip0.close();
} catch(e3) {}

尽管您可能应该有比这更好的错误检查:-)我删除了它，因为它（1）有点大； (2) 具有一定的专有性。

Sure you can. If you code up some Javascript in the report itself, it can access files on the disk to retrieve the textual queries and modify the query before it's executed.

The event you need to code for is beforeOpen on the data source. We actually use this for wildcarding parameters by detecting if they're set to "*" and dynamically adjusting the SQL query, changing it from:

select A from B where C = ?

to:

select A from B where ((C = ?) or (1==1))

The ugly modification is just so we don't have to worry about changing the positional parameters.

You can read a line from a disk file and change the query with something like:

try {
  var fip0 = new Packages.java.io.FileInputStream("/query.txt");
  try {
    var fip1 = new Packages.java.io.DataInputStream(fip0);
    try {
      queryText = fip1.readLine() + "";
    } catch(e1) {}
    fip1.close();
  } catch(e2) {}
  fip0.close();
} catch(e3) {}

although you should probably have better error checking than that :-) I removed it as it's (1) somewhat large; and (2) somewhat proprietary.

回复收藏 0 原文