Help getting faction_id from this query

I'm trying to get the faction_id from attacker_player_guid from this query:

http://census.daybreakgames.com/xml/get/ps2:v...acter^on:attacker_player_guid^show:faction_id
(this doesn't work for me)

http://census.daybreakgames.com/xml/get/ps2:v...ype:character^on:character_id^show:faction_id
(this works for character_id of vehicle destroyed, but faction_id is already returned anyway)


I'm confused, what am I doing wrong here to get the faction of the attacker?

 

The c:join command takes a "on" value which you correctly set to "attacker_player_guid". The c:join also has a "to" value which is the foreign key column name. "to" defaults to the value of "on". Since the character record doesn't have a column called "attacker_player_guid" and the correct column is "character_id" you should add "^to:character_id" to the join. I also added "inject_at:attacker" just to make the result a little prettier. Here is the final query with the attackers faction_id:

http://census.daybreakgames.com/json/get/ps2:...aracter_id^show:faction_id^inject_at:attacker

 

Awesome, thank you so much