A
A
Artcifra2017-08-01 15:13:12
MySQL
Artcifra, 2017-08-01 15:13:12

How to view Firebase Cloud Messaging statistics by messages?

Has anyone used Firebase Cloud Messaging?
In presentations, everything is always so cool, but then in life, then half is not in the documentation, and the rest you need to write yourself from scratch.
They stated that the built-in Analytic system.
How realistic it is then to look at:

  • how many subscribers
  • for each posting
  • how much did it turn out
  • how many unsubscribed
  • how many messages did not reach

this was not in Google Cloud Messaging
if there are any ready-made solutions such as paid CMS, throw those links plz

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
retvizan, 2019-03-05
@doneup

1) disable the ONLY_FULL_GROUP_BY mode, for example,
select @@sql_mode;
set @@sql_mode='list other modes without ONLY_FULL_GROUP_BY';
2) it is better to rewrite the query so that in the select part the fields that are not grouped by go using aggregate functions. There are at least 5 solutions, see the article Grouping in MySQL

A
Andrey Shatokhin, 2019-03-05
@Sovigod

Turn STRICT mode on mysql server off. And then your query is not unambiguous according to the results after grouping by only one field.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question