谷歌云消息传递时间(Google cloud messaging time to live)

 那么，首先，请务必要求friends_birthday权限，否则无法获得朋友的生日日期。 
 
 如果您对Graph API Explorer不熟悉，则应该 - 您可以测试FQL查询以查找问题。 
 
 点击“获取访问令牌”，然后在“朋友数据权限”中选中“friends_birthday”，您就可以开始测试查询了。 
 
 其次，所有的生日都与实际出生年份一起存储，所以above today在FQL查询中询问above today内容总是不会返回任何结果。 为了“修复”日期 - 你实际上可以选择生日和今年的一部分，如下所示： 
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
AND birthday_date != 'null' 
 
 问题来了： 
 
 所选字段不是用户表的一部分，您无法对其进行排序，甚至无法使用WHERE。 我的猜测是，你必须让所有的朋友过生日，并使用JAVA过滤数据 - 这应该很容易，因为自定义选择字段中的日期是2013年而不是实际年份。 
 
 随意使用此链接测试 FQL。 
 
 编辑＃1 
 
 我想澄清一些事情，你想转换的原始查询不会 
 
 
 
 在未来30天内获取Facebook朋友的生日列表 
 
 
 当在查询中手动替换值时，我看到它返回了生日在同一个月的两个给定日期之间的所有朋友。 它没有找到所有在未来30天有生日的朋友。 
 
 编辑＃2 
 
 我已经找到了一种方法让这个月和下一个生日的所有朋友 - 这是更好的通过所有的朋友名单。 
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND (substr(birthday_date,0,2)='02' OR substr(birthday_date,0,2)='03')
 
 这应该会变得更容易在今天之前超过列表并过滤掉这些列表，并且从今天起不超过30天 - 这是我能想到的最佳解决方案。 
 
 编辑＃3我实际上可以使用来自编辑＃2的相同查询进行过滤，以获得今天之后的所有内容，并按其排序： 
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND (substr(birthday_date,0,2)='02' OR substr(birthday_date,0,2)='03')
    AND birthday_date > '02/23/2013'
ORDER BY birthday_date
 
 如果你想限制10： 
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND (substr(birthday_date,0,2)='02' OR substr(birthday_date,0,2)='03')
    AND birthday_date > '02/23/2013'
ORDER BY birthday_date
LIMIT 10
 
 编辑＃4 
 
 如果您计算Java中的日期并将其传递给查询，则更为简单 
 
SELECT name, birthday, birthday_date FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND birthday_date > '02/23/2013'
    AND birthday_date < '04/24/2013'
ORDER BY birthday_date ASC
 
 编辑＃5 
 
 一些Java代码： 
 
Calendar cal = Calendar.getInstance();
Date today = cal.getTime();
SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy");
String today_formatted = formatter.format(today);
cal.add(Calendar.DATE, 30);
String today_plus30_formatted = formatter.format(cal.getTime());

String query = 
"SELECT name, birthday, birthday_date FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND birthday_date > '" + today_formatted + "'
    AND birthday_date < '" + today_plus30_formatted + "'
ORDER BY birthday_date ASC";
 
 我没有测试过它，没有安装Java :-) 

Well, first of all, make sure to ask for friends_birthday permission, without it you can't get your friends birthday dates.
 
If you are not familiar with the Graph API Explorer, you should - you can test FQL queries to find problems.
 
Click the "Get Access Token" and in "Friends Data Permissions" check the "friends_birthday" and you are good to go testing the query.
 
Second, all the birthdays are stored with the actual birth year, so asking for above today in FQL query will always return nothing. to "fix" the date - you can actually select a portion of the birthday and this year to it like so:
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
AND birthday_date != 'null' 
 
And here comes the problem:
 
The selected field is not part of the user table, and you can't sort by it, or even use WHERE on it. My guess is that you have to get all your friends birthday and use JAVA to filter the data - It should be easy since the date in the custom selected field has 2013 instead of the real year.
 
Feel free to Test the FQL with this link.
 
EDIT #1
 
I want to be clear on something, the original query you wish to convert will not 
 
 
 
fetch list of Facebook friends those birthdays in next 30 days
 
 
When replacing the values manually in the query I saw that it returns all friends with birthday between 2 given days in the same month. It does not find the all the friends who has a birthday in the next 30 days.
 
EDIT #2
 
I have found a way to get all friends with birthday in this month and the next - which is much better the to go over all the friends list.
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND (substr(birthday_date,0,2)='02' OR substr(birthday_date,0,2)='03')
 
This should become much easier to go over the list and filter the ones before today and no more then 30 days from today - this is the best solution I can think of.
 
EDIT #3 I can actually filter using the same query from edit #2 to get all the ones after today, ordered by it:
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND (substr(birthday_date,0,2)='02' OR substr(birthday_date,0,2)='03')
    AND birthday_date > '02/23/2013'
ORDER BY birthday_date
 
And if you want to limit by 10:
 
SELECT name, birthday, birthday_date, concat(substr(birthday_date,0,6),"2013") FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND (substr(birthday_date,0,2)='02' OR substr(birthday_date,0,2)='03')
    AND birthday_date > '02/23/2013'
ORDER BY birthday_date
LIMIT 10
 
Edit #4
 
Much more simple if you calculate the dates in Java and pass it to the query
 
SELECT name, birthday, birthday_date FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND birthday_date > '02/23/2013'
    AND birthday_date < '04/24/2013'
ORDER BY birthday_date ASC
 
EDIT #5
 
Some Java code:
 
Calendar cal = Calendar.getInstance();
Date today = cal.getTime();
SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy");
String today_formatted = formatter.format(today);
cal.add(Calendar.DATE, 30);
String today_plus30_formatted = formatter.format(cal.getTime());

String query = 
"SELECT name, birthday, birthday_date FROM user 
WHERE uid in (SELECT uid2 FROM friend WHERE uid1 = me()) 
    AND birthday_date != 'null' 
    AND birthday_date > '" + today_formatted + "'
    AND birthday_date < '" + today_plus30_formatted + "'
ORDER BY birthday_date ASC";
 
I have not tested it, don't have Java installed :-)