Confluence User •

25 Oct, 2018 •

confluenceUser •

•

confluenceUser •

Check out the last part of this article to write the query - select VALUE, LABEL from table... JDBC Options Binder

Confluence User •

26 Oct, 2018 •

confluenceUser •

•

confluenceUser •

Thank you, we found a solution (Categories like A, B, C ...) like this :

select

  [MY_TABLE].id,

  SUBSTRING_INDEX(SUBSTRING_INDEX([MY_TABLE].[MY_CATEGORY], ';', numbers.n), ';', -1) name

from

  (select 1 n union all

   select 2 union all select 3 union all

   select 4 union all select 5) numbers INNER JOIN [MY_TABLE]

  on CHAR_LENGTH([MY_TABLE].[MY_CATEGORY])

     -CHAR_LENGTH(REPLACE([MY_TABLE].[MY_CATEGORY], ';', ''))>=numbers.n-1

  where c_processIdent='#process.processId#'

order by

  id, n

 

JDBC Binder CheckBox with several choices A,B,C ...

1

CSV | Excel | XML | PDF