Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by ThisisJP » Tue Jan 24, 2023 7:22 pm
Which language is needed to study to do advanced stats and report filters?
for example:
[...] exists(select 1 from tourney_hand_player_statistics hero where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero and hero.position = 9) [...]
thanks
-
ThisisJP
-
- Posts: 17
- Joined: Thu Apr 07, 2011 9:43 am
by Flag_Hippo » Wed Jan 25, 2023 6:44 am
That is a subquery used for
'vs Hero' custom statistics. These types of query are used if you want information about a player different from the one the stat is written for however using these types of queries means that the
database cache cannot be used. For more on how SELECT works see
here and from there you can also access further PostgreSQL documentation.
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by ThisisJP » Fri Jan 27, 2023 1:28 am
Thanks.
So mostly I should study postgreSql queries, that I can find on that documentation.
-
ThisisJP
-
- Posts: 17
- Joined: Thu Apr 07, 2011 9:43 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 22 guests