How to filter world_event collection

Maybe I don't understand how to filter or limit API queries... but I'm trying to do it with:

https://census.daybreakgames.com/get/ps2/world_event/

The structure is like this:

Code:

{internal: false,returned: 10,timing: {total-ms: 1276,world_event-ms: 1276},world_event_list: [{duration_held: "104",event_type: "FacilityControl",facility_id: "310088",faction_new: "1",faction_old: "3",objective_id: "0",table_type: "facility_event",timestamp: "1371661421",world_id: "10",zone_id: "558694495"},{duration_held: "417061",event_type: "FacilityControl",facility_id: "310088",etc

So how would I limit the query to only return events for a particular facility_id? I've tried all of the following, with no luck:

http://census.daybreakgames.com/get/ps2-beta/world_event?world_event_list.facility_id=310088
http://census.daybreakgames.com/get/ps2-beta/world_event?facility_id=310088

Also, I can't figure out how to use c:show:

http://census.daybreakgames.com/get/ps2-beta/world_event?c:show=facility_id,timestamp

That doesn't seem to do anything...

What am I doing wrong here?

 

In all cases, you are missing a slash between /world_event/ and ?.

http://census.daybreakgames.com/xml/get/ps2-beta/world_event/?facility_id=310088
http://census.daybreakgames.com/xml/get/ps2-beta/world_event/?facility_id=310088&c:show=facility_id

However it looks like the world_event collation is totally bugged as neither of those URLs are filtering correctly either.

 

There seem to be a few collections in the PS2 api that behave like this. It's like they are doing resolves internally and due to that are unable to apply filters. Note, I believe it's mostly the event type collections that are like this.

 

The event types (event, characters_event, characters_event_grouped, world_event) do not support all the census api commands due to performance issues. There are billions of rows in those tables and they are specially optimized to be queryable by just a few fields, character_id, world_id, etc. It's clear we need a section to the documentation page http://census.daybreakgames.com/ that lists out the limitations of these and other types. I will hopefully get that documentation updated today.
Thanks

 

Please see the "exceptions/limitations" section on http://census.daybreakgames.com/. I hope that helps to clear things up.