Unless the data itself has something to flag the top 5 of a stat in then at some point you have to bring all the fgm into XPression so it can compare them and then know which is the highest. XPression doesn't know that 96 is the highest unless it sees all the other numbers to compare it to.
Not sure if that can be done in XML, hopefully, someone might jump in here and advise.
Original Message:
Sent: 01-09-2024 12:46
From: Philip Doherty
Subject: DataLinq with NCAA stats, starters and jersey numbers
It is somewhat what I am after. The main issue is that I don't want to have a million different text objects for each player, instead, I would love if I could automatically pull it from datalinq. Like I would love to be able to point it to the "fgm" stat for each player, and then allow me to increment the outputs to just pull the name, number, and fgm for the top 5. I would like to minimize the amount of visual logic needed.
------------------------------
Philip Doherty
Elon University
Original Message:
Sent: 01-09-2024 12:10
From: Simon Redmile
Subject: DataLinq with NCAA stats, starters and jersey numbers
I think this video is what you're after but let me know if not.
https://www.rossvideo.com/resources/ross-university/xpression-visual-logic-sort-selector-function-block/#:~:text=A%20Sort%20Selection%20function%20block,Function%20Blocks%20and%20Object%20Blocks.
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
Original Message:
Sent: 01-09-2024 12:08
From: Philip Doherty
Subject: DataLinq with NCAA stats, starters and jersey numbers
Yeah! Like the top 5 scorers for each team for example.
------------------------------
Philip Doherty
Elon University
Original Message:
Sent: 01-09-2024 12:05
From: Simon Redmile
Subject: DataLinq with NCAA stats, starters and jersey numbers
Highest scores or what?
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
Original Message:
Sent: 01-09-2024 12:03
From: Philip Doherty
Subject: DataLinq with NCAA stats, starters and jersey numbers
This does work! Thank you very much.
If I want to use this to pull the highest scorers and such, how would I do that?
------------------------------
Philip Doherty
Elon University
Original Message:
Sent: 01-09-2024 11:59
From: Simon Redmile
Subject: DataLinq with NCAA stats, starters and jersey numbers
I think that this will work;
team<vh=H>\player<oncourt=Y>
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
Original Message:
Sent: 01-09-2024 11:55
From: Philip Doherty
Subject: DataLinq with NCAA stats, starters and jersey numbers
I am not sure mine is exactly formatted that way, I'll send how a typical player is formatted. Sorry, I'm relatively new to this!
<player uni="1" code="1" name="Hill, Jami" checkname="HILL,JAMI" class="FR" gp="0" gs="0" pos="G" oncourt="N">
<stats fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="0" oreb="0" dreb="0" treb="0" pf="0" tf="0" to="0" dq="0" fgpct="0" fg3pct="0" ftpct="0">
</stats>
</player>
------------------------------
Philip Doherty
Elon University
Original Message:
Sent: 01-09-2024 11:47
From: Simon Redmile
Subject: DataLinq with NCAA stats, starters and jersey numbers
Have an object that looks up the on-field like this;
![](https://higherlogicdownload.s3.amazonaws.com/ROSSVIDEO/MessageImages/be3008babf784a8692642c404273b5af.png)
![](https://higherlogicdownload.s3.amazonaws.com/ROSSVIDEO/MessageImages/8cc5d0097668431fae158f0da1d2d6d2.png)
------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
Original Message:
Sent: 01-09-2024 11:36
From: Philip Doherty
Subject: DataLinq with NCAA stats, starters and jersey numbers
Hey! I am trying to figure out the best way to populate the names of players by jersey number and starters automatically. Currently, I am using this, which becomes an issue once there is a gap in player numbers. I believe this is a simple thing, but I am not 100% sure! I want to pull the starting 5 automatically using oncourt=Y and also pull names by using the uni box. Any ideas?
![](https://higherlogicdownload.s3.amazonaws.com/ROSSVIDEO/MessageImages/fb80fedf65a6427f81a11674e32c7143.png)
------------------------------
Philip Doherty
Elon University
------------------------------