You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
добрый день!
понимаю, что вопрос скорее по sql, но может быть кто-нибудь настраивал.
записи выводятся в БД mssql. в поле EXT выводится внутренний номер абонента (или группа). А нужно видеть имя абонента.
Wowa
unread,
Mar 20, 2018, 3:46:27 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
Делаете еще одну табличку в базе - соответствие ext и имени. Потом запросом вытягиваете через left join. Left - что бы не потерялся звонок, если вдруг забыли задать соответствие.
Алексей Алямкин
unread,
Mar 20, 2018, 4:41:10 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
а как делается это соответствие?
Wowa
unread,
Mar 20, 2018, 4:50:29 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
В Management Studio: Базы данных - esmdr - Таблицы - правой кнопкой - Создать таблицу.
Алексей Алямкин
unread,
Mar 20, 2018, 5:26:19 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
я имел в виду нужно ли создать первичный и внешний ключи
Message has been deleted
Wowa
unread,
Mar 20, 2018, 5:36:49 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
Внешний и будет ext, или pbxid+ext, если у вас несколько станций.
Message has been deleted
Алексей Алямкин
unread,
Mar 20, 2018, 5:58:57 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
входящий звонок может адресоваться группе. как предусмотреть такой вариант?
значит во второй таблице будут 2 строки с одинаковым ext и разными именами абонентов? такое возможно? или внешний ключ должен быть уникальным?
Wowa
unread,
Mar 20, 2018, 6:01:41 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
У группы свой номер, у вас будет, к примеру: 601 Отдел снабжения 201 Начальник ОС Иванов
Алексей Алямкин
unread,
Mar 20, 2018, 6:45:41 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
ну это в самом простом случае пойдет.
я имел в виду чуть-чуть посложнее.
для выборки по внутреннему номеру (указал номер 101 - вывелись входящие звонки по 101 номеру или группе, в которую входит номер 101)
Wowa
unread,
Mar 20, 2018, 6:51:28 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
Там две записи, входящий на группу, и вторая на EXT, который ответил. Разве что никто трубку не взял, тогда групповой будет висеть с признаком NA.
Алексей Алямкин
unread,
Mar 20, 2018, 7:01:00 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
точно. теперь обратил внимание
Алексей Алямкин
unread,
Mar 20, 2018, 7:24:31 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
задаю во второй таблице ext как primary key, в таблице calls поле ext - foreign key.
в бд перестают записываться значения.
Wowa
unread,
Mar 20, 2018, 7:31:27 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
Значит не задавайте. Достаточно сделать вторую таблицу, можно индекс в нее добавить по полю ext. И вьюшкой выбирать что вам нужно.
Алексей Алямкин
unread,
Mar 20, 2018, 9:10:08 AM3/20/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Форум сайта http://pbx.gal.cv.ua
все получилось. спасибо!
Алексей Алямкин
unread,
Mar 21, 2018, 4:53:28 AM3/21/18
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message