You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I.e. via this query I'm looking at using group_concat with SQLite to produce a newline-delimited output like:
selectjson_each.keyas configuration_key,
group_concat(
platform ||'/'|| organisation ||'/'|| repo,
char(13)
) as repos,
count(*) as num_repos_with_config,
total_repos.cas total_repos
from
renovate_configs,
json_each(renovate_configs.config),
(
selectcount(*) as c
from
renovate_configs
) as total_repos
group byjson_each.key
Which renders like so with sqlite3:
However, when using sql-studio, we see:
The text was updated successfully, but these errors were encountered:
I.e. via this query I'm looking at using
group_concat
with SQLite to produce a newline-delimited output like:Which renders like so with
sqlite3
:However, when using sql-studio, we see:
The text was updated successfully, but these errors were encountered: