| Новости | FAQ | Авторы | Документация | В действии | Библиотека |
| Инструменты | Полезные ссылки | Хостинги | Скачать | Примеры | Форум |
Sumo 14.11 21:41 / 14.11 21:42
Если внимательно написать запросы, которые костя показывал. У меня сейчас третий Сфинкс, но и для второго по тоже работает — я пробовал когда ввели фичу. ^connect[$core.sphinx.connectString]{
$res[^hash::sql{
select 0, account_id, address
from index_1
where match('иванов')
and period in ('2026-01-01', '2026-02-01')
limit 10
facet 1, region_id, region_name
facet 2, period, mc_name
}[
$.type[table]
$.distinct(true)
]]
}
<pre>
^json:string[$res;$.indent(true)]
</pre>
{
"0":[
{"0":"0","account_id":"10108...","address":"..."},
{"0":"0","account_id":"10114...","address":"..."},
{"0":"0","account_id":"10504...","address":"..."},
{"0":"0","account_id":"10507...","address":"..."},
{"0":"0","account_id":"10582...","address":"..."},
{"0":"0","account_id":"10603...","address":"..."},
{"0":"0","account_id":"10604...","address":"..."},
{"0":"0","account_id":"10507...","address":"..."},
{"0":"0","account_id":"10401...","address":"..."},
{"0":"0","account_id":"10606...","address":"..."}
],
"1":[
{"1":"1","region_id":"101","region_name":"...","count(*)":"18"},
{"1":"1","region_id":"105","region_name":"...","count(*)":"17"},
{"1":"1","region_id":"106","region_name":"...","count(*)":"11"},
{"1":"1","region_id":"104","region_name":"...","count(*)":"6"},
{"1":"1","region_id":"107","region_name":"...","count(*)":"11"},
{"1":"1","region_id":"108","region_name":"...","count(*)":"10"},
{"1":"1","region_id":"102","region_name":"...","count(*)":"5"},
{"1":"1","region_id":"103","region_name":"...","count(*)":"2"},
{"1":"1","region_id":"109","region_name":"...","count(*)":"2"}
],
"2":[
{"2":"2","period":"2026-02-01","mc_name":"..."},
{"2":"2","period":"2026-02-01","mc_name":"..."},
{"2":"2","period":"2026-02-01","mc_name":"..."},
{"2":"2","period":"2026-01-01","mc_name":"..."}
]
}и тоже самое, но в массив таблиц... ^connect[$core.sphinx.connectString]{
$res[^array::sql{
select 0, account_id, address
from index_1
where match('иванов')
and period in ('2026-01-01', '2026-02-01')
limit 10
facet 1, region_id, region_name
facet 2, period, mc_name
}[
$.type[table]
$.distinct(true)
$.sparse(true)
]]
}
<pre>
^json:string[$res;$.indent(true)]
</pre>
[
[
{"0":"0","account_id":"10108...","address":"..."},
{"0":"0","account_id":"10114...","address":"..."},
{"0":"0","account_id":"10504...","address":"..."},
{"0":"0","account_id":"10507...","address":"..."},
{"0":"0","account_id":"10582...","address":"..."},
{"0":"0","account_id":"10603...","address":"..."},
{"0":"0","account_id":"10604...","address":"..."},
{"0":"0","account_id":"10507...","address":"..."},
{"0":"0","account_id":"10401...","address":"..."},
{"0":"0","account_id":"10606...","address":"..."}
],
[
{"1":"1","region_id":"101","region_name":"...","count(*)":"18"},
{"1":"1","region_id":"105","region_name":"...","count(*)":"17"},
{"1":"1","region_id":"106","region_name":"...","count(*)":"11"},
{"1":"1","region_id":"104","region_name":"...","count(*)":"6"},
{"1":"1","region_id":"107","region_name":"...","count(*)":"11"},
{"1":"1","region_id":"108","region_name":"...","count(*)":"10"},
{"1":"1","region_id":"102","region_name":"...","count(*)":"5"},
{"1":"1","region_id":"103","region_name":"...","count(*)":"2"},
{"1":"1","region_id":"109","region_name":"...","count(*)":"2"}
],
[
{"2":"2","period":"2026-02-01","mc_name":"..."},
{"2":"2","period":"2026-02-01","mc_name":"..."},
{"2":"2","period":"2026-02-01","mc_name":"..."},
{"2":"2","period":"2026-01-01","mc_name":"..."}
]
]А дальше вытаскиваем уже по номеру результата.