Local divisions
- svitlana (Deactivated)
Owned by svitlana (Deactivated)
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 HoursSQL 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');