I noticed when I was trying to compile a list of characters that need a certain feat that I was not getting accurate results because I was using the characters_active_feat collection which doesn't have all of the "active" feats that a character may have. When querying for a feat like this you will get nothing back. I did a workaround by doing a comparison of characters_completed_feat with the feat collection in code. As an example the feat_id for Accidental Collection is 2446482. Running this query you get nothing: http://census.daybreakgames.com/s:example/get/dcuo:v1/characters_active_feat?c:limit=50&feat_id=2446482 Running a query on the Tough on Crime (feat_id is 2477652) feat you get a character list: http://census.daybreakgames.com/s:example/get/dcuo:v1/characters_active_feat?c:limit=50&feat_id=2477652 Even some older feats don't work like Find the Bat-Signal (feat_id is 952459): http://census.daybreakgames.com/s:example/get/dcuo:v1/characters_active_feat?c:limit=50&feat_id=952459 Likewise if you lookup a character_id you won't get back any of the affected feats. Let me know if you need more information. Workaround Like I said you can get around this by building a total feat list from the feat collection, build a list of feats completed by a character (or vice-versa) and doing a comparison between the two. I used hashes with the feat_id as the key and iterated through the total feat list. Checked to see if an entry existed in the completed feat hash and if it did not I added that feat to the "active" feat hash that I built internally. This works and it works with 2 query to the database (compared to 1 query per feat using COUNT) but it is not ideal as it should be. It is a simple 1 iteration check so it is fast as an alternative still. For my app I already wanted to store the full feat list so I am only creating 1 additional list. However for someone that just wants the active feats of a character they would need 3 times the lists they should normally need (1 list). Suggestions In relation to this bug it would be very helpful to search by guild_id similar to how you can search by character_id. For another part of my app I had to join the guild_roster collection with the characters_active_feat collection and do another check of that list to see which guild member had or did not have a feat. I did this by checking if the character_id_join_characters_completed_feat field exists in my query. If I pass a guild_id and feat_id to the characters_completed_feat or (active) collection it would be nice to get back a list of guild members that need the specific feat.