Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata


Introduction

As support agent you have to consult people from different countries. Each country has a couple local divisions where you can direct users. 


 

Screenshots

Connected Grid configuration

gd.query=select d.address, d.phone, d.hours from divisions d where d.country = {customfield:10100}
gd.query.ds=mysql
gd.query.columns=address,phone,hours

gd.columns=address,phone,hours

col.address=Address
col.phone=Phone
col.hours=Working Hours

SQL Setup

drop table if exists divisions;
create table divisions(
	division_id integer primary key,
	country varchar(255),
	address varchar(255),
	phone varchar(20),
	hours varchar(20)
);
insert into divisions(division_id, country, address, phone, hours) values (1, 'France', '8 Rue de Londres 75009 Paris', '+33 (0)1 42 68 53 00', '10-18');
insert into divisions(division_id, country, address, phone, hours) values (2, 'Germany', 'Unter den Linden 14 10117 Berlin', '+49 30 303986300', '6-21');
insert into divisions(division_id, country, address, phone, hours) values (3, 'Canada', '1253 McGill College Montreal, Quebec, H3B 2Y5', '+1 514-670-8700', '12-16');
insert into divisions(division_id, country, address, phone, hours) values (4, 'Germany', 'ABC-Strasse 19 20354 Hamburg', '+49 40-80-81-79-000', '6-21');
  • No labels