如何添加全选选项以选择CDE中的组件 [英] How to add a select all option to select component in CDE

问题描述

对于一个学生项目，我们正在与Pentaho CDE合作创建仪表板. 起初它可以正常工作，但现在我们不停地添加多个Select Component. 我们在Where语句中将选择组件的参数插入到SQL查询中，但是现在出现了问题，即不可能在一个选择组件中选择所有元素，而在其他选择组件中只能选择一个.由于我们无法找出如何在一个选择组件中选择所有选项并将其全部发送给查询，因此样本空间越来越小，我们添加的参数也越来越小. 在CDE中是否可以向选择组件添加选择所有元素选项"?甚至要取消激活选择组件并将此取消激活发送到SQL查询?

for a students projects we are working with Pentaho CDE to create a dashboard. At first it works fine, but now we are hanging at the point adding more than one Select Component. We inserted the Parameters of the Select Components to the SQL-Queries in the Where statement but now we have the problem, that it is not possible to select all elements in one select component and only one in the others. The sample space is getting smaller and smaller the more parameters we add because we can't find out how to select all option in one select component and send this all to the query. Is it possible in CDE to add an "select all elements option" to the select component? Or even to deactivate a select component and send this deactivation to the SQL-Query?

我们注意到有多个选择组件，但我们无法处理所需的自定义参数. 如果可以与选择的组件一起使用，那就很好了.

We noticed that there is a multiple select component but we were not able to handle the custom parameter needed for it. It would be fine if it works with the select components.

预先感谢您的支持.

推荐答案

使用SQL表达式的情况:

Use SQL expression CASE:

SELECT * FROM表WHERE 像城市($ {city} ='ALL'然后'％'ELSE $ {city}结尾的情况)

SELECT * FROM table WHERE cities LIKE (case when ${city} = 'ALL' then '%' ELSE ${city} end)

这篇关于如何添加全选选项以选择CDE中的组件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！