Hi Sonja,
It looks like your data source is XML, so those SQL queries aren't going to work.
For filtering an XML source, make sure you're running at least XPression version 8.0 or above, so you have these features.
- [implemented] the XML/JSON datalinqs can now search multiple attributes or elements to return a node that matches all search criteria. e.g. players<team=NY;jersey=10>
- [implemented] the XML datalinq types can search for children elements/attributes in a level of the tree by using "childname.field=%key%". e.g. player<info.jersey=%num%>\name
I've not used XML filtering myself. But here are some examples of XML filters that work. I hope this is enough to get you started.
team<player.uni=%jersey%>\player\rcv is trying to return the team based on the jersey number entered ("Return the team that has a player with jersey number X"). However, \player\ is always going to return the first listed player on either team. The query is "working", it just happens that player<1> for either team is defensive, so they don't have any receiving numbers that would be nested within \rcv.
team<vh=%team%;player.uni=%jersey%>\player\rcv is doing the same thing; you're just additionally filtering by away/home ("Return the team that has a player with jersey number X, and has the vh designation of V/H"). In both cases the query is trying to return the first player listed on the team.
Original Message:
Sent: 12-13-2021 22:49
From: Sonja Broomfield
Subject: Datalinq script to filter stats by minimum games played?
Thank you Riley, this is great stuff I will certainly use, but unfortunately not the answer to my problem.
To use your example, I am trying to make a leaderboard of most popular Hollywood cops out of a data set of votes for most popular characters of which certain ones are identified as cops. Trying to make a subset of leaders, in other words.
S.
------------------------------
Sonja Broomfield
On-Air graphics (Duet & Xpression)
Freelance
Canada
Original Message:
Sent: 12-13-2021 15:26
From: Riley Gibbs
Subject: Datalinq script to filter stats by minimum games played?
I whipped up a scene to make sure It works, here is my result. This video is an excellent resource for accomplishing this very thing.
https://www.youtube.com/watch?v=RamDBQHU3tU
Let me know if you have any questions or if this is indeed a solution to your problem.
------------------------------
Riley Gibbs
Original Message:
Sent: 12-13-2021 11:01
From: Sonja Broomfield
Subject: Datalinq script to filter stats by minimum games played?
I'm making league leader boards and I want to filter data by minimum games played and by position.
I'm using Datalinq with data from NHL HITS via OASIS.
SQL scripting doesn't seem to work in this format.
Ideas?
Thanks so much! Sonja
------------------------------
Sonja Broomfield
------------------------------