Does FQL have a "NOT NULL" type operator?

Question

I'm messing around with FQL, and I have this query:

SELECT created_time, attachment, message FROM stream  WHERE source_id = me() LIMIT 1000

which returns 1000 results, most not relevant to me. I'd like to filter, for example, on MESSAGE IS NOT NULL. Is that (or something equivalent) possible with FQL?

score 12 · Answer 1 · answered Oct 24 '12 at 20:56

12

Just adding AND message to the WHERE clause works as well – an empty value is considered “false” by FQL.

answered Oct 24 '12 at 20:56

CBroe

91,630
14
92
150

score 3 · Answer 2 · edited Apr 02 '13 at 17:09

3

Add type to the SELECT clause and in the WHERE clause add AND type > 0.

edited Apr 02 '13 at 17:09

Michael Waterfall

20,497
27
111
168

answered Oct 24 '12 at 20:06

Marty Stake

31
1

Does FQL have a "NOT NULL" type operator?

2 Answers2