[Git][noosfero/noosfero][master] social-statistics: update blazer config to new category schema

[Rodrigo Souto]

Rodrigo Souto pushed to branch master at Noosfero / noosfero


Commits:
7d3a4ee3 by Rodrigo Souto at 2018-06-28T17:35:33Z
social-statistics: update blazer config to new category schema

- - - - -


1 changed file:

- plugins/social_statistics/config/blazer.yml.dist


Changes:

=====================================
plugins/social_statistics/config/blazer.yml.dist
=====================================
--- a/plugins/social_statistics/config/blazer.yml.dist
+++ b/plugins/social_statistics/config/blazer.yml.dist
@@ -25,8 +25,8 @@ data_sources:
       # zone_id: "SELECT id, name FROM zones ORDER BY name ASC"
       period: ["day", "week", "month"]
       # status: {0: "Active", 1: "Archived"}
-      category_id: "SELECT id, name FROM categories where type is null ORDER BY name ASC"
-      category_parent_id: "SELECT parents.id, parents.name FROM categories as parents inner join categories as children on parents.id = children.parent_id where parents.type is null ORDER BY parents.name ASC"
+      category_id: "SELECT id, name FROM categories where type = 'Category' ORDER BY name ASC"
+      category_parent_id: "SELECT parents.id, parents.name FROM categories as parents inner join categories as children on parents.id = children.parent_id where parents.type = 'Category' ORDER BY parents.name ASC"
       region_id: "SELECT id, name FROM categories where type = 'Region' ORDER BY name ASC"
       region_parent_id: "SELECT parents.id, parents.name FROM categories as parents inner join categories as children on parents.id = children.parent_id where parents.type = 'Region' ORDER BY parents.name ASC"
       tag_id: "SELECT id, name FROM tags ORDER BY name ASC"



View it on GitLab: https://gitlab.com/noosfero/noosfero/commit/7d3a4ee3e4f2818cd6827421880893b9662d2663

-- 
View it on GitLab: https://gitlab.com/noosfero/noosfero/commit/7d3a4ee3e4f2818cd6827421880893b9662d2663
You're receiving this email because of your account on gitlab.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/noosfero-dev/attachments/20180628/29351632/attachment.html>