Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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