Graphics

 View Only
  • 1.  Datalinq and Searching for specific Row.

    Posted 09-20-2018 23:31
    So I have a list of contests for an election and I would like to be able to display the results of a specific contest based on the name of the contest instead of inputting a row number using a datalink key. For example I'm currently have data coming from the tickit flow election system and am using the following data column Contests\Contest\..[I]can be any path in side the contest[/I]..\ where %contest% is a number 1-3 and depending on what I enter I get the needed info about the contest. My issue is my playlist for this is going to be say all the senate races in november and I want my users via the xpression plugin to only have to select a race by name and have the system figure out from there what index this race is in the playlist data set.


  • 2.  RE: Datalinq and Searching for specific Row.

    Posted 09-21-2018 00:47
    Yes, this should be possible but you'd have to show us what the xml data looks like so we could tell you what to put in the datalinq key.
    It would be something like ...\Contest\...
    #XPression


  • 3.  RE: Datalinq and Searching for specific Row.

    Posted 09-21-2018 17:19
    Had to change the file extension for xml to txt for the upload to work. This is just a simple sample data set that I'm working with for testing at the moment. For example I'm linking to a canidets first name as follows Contests\Contest\Choices\Choice<2>\FirstName but I would like to select the contest by contest name Contests\Contest\Office\Name. If I understand correcting I would want to do something like this. Contests\Contest\Choices\Choice<2>\FirstName
    #XPression


  • 4.  RE: Datalinq and Searching for specific Row.

    Posted 09-21-2018 17:26
    Contests\Contest\Choice...
    #XPression


  • 5.  RE: Datalinq and Searching for specific Row.

    Posted 09-21-2018 17:29
    FYI, this requires version 7.1 or higher:
    version 7.1 build 3908 (Sep 13th 2017)

    � [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\name

    #XPression


  • 6.  RE: Datalinq and Searching for specific Row.

    Posted 09-21-2018 17:49
    So I was able to get the following to work just fine Contests\Contest\Choices\Choice<2>\FirstName but when I try to link one more node further in like you suggested above no such luck. I.E. Contests\Contest\Choices\Choice<2>\FirstName
    #XPression


  • 7.  RE: Datalinq and Searching for specific Row.

    Posted 09-21-2018 17:53
    Thats my problem then I'm using 6.5. Time to upgrade I think.
    #XPression


  • 8.  RE: Datalinq and Searching for specific Row.

    Posted 09-21-2018 18:03
    I'm wondering if scripting this would be better in the long run as I also need to sort the data by certain fields for example races with more than two contestants we only want to show the top two or three contestants.
    #XPression


  • 9.  RE: Datalinq and Searching for specific Row.

    Posted 10-04-2018 21:23

    So to piggy back on this. What about using a column and a row? On the right is the old datalinq and on the left is the new feed.


    #XPression