Graphics

Yes there is, are you using the master summary database or are you using xml's from the dak? 

Do you know how to write queries to get data? 

I tried responding from the email notification that you responded, but not sure it went to the correct place, Basically, I did not set this up originally, but am seeing that it is named Master Database Summary, so I'm guessing it is that(see picture for confirmation)..

Also, I do not have any experience writing a query to pull data(I've only used the Datalinq Properties tabs to pull data) or even know where to do so, but I'd be willing to try anything if you can point me in the right direction.

Thanks,

Jordan

------------------------------
Jordan Shew
------------------------------


Original Message:
Sent: 08-09-2023 05:10
From: Simon Redmile
Subject: Using Two data sources in the same scene together

Yes there is, are you using the master summary database or are you using xml's from the dak? 

Do you know how to write queries to get data? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom

Hey, up that's the master summary database. 

OK in that case its laying it out like a table so what you can do is things like this. 

This is the home player table in dak master summery, there is G and S for Game and Season. 

This what you are used of I would imagine, so this would be linked to the first name on the first row in the home player table. 

In order to get the data you want based on a datalinqkey you'll need to use a query. 

SELECT [column you want] FROM [table you want] WHERE (column you want to search by] = value you want to use to search eg "11G"

The example below shows I am looking for first name from home player table where the datalinqkey called "Jersey" is whatever value you have entered and you'll see the letter G for game next to it, if I wanted season it would be an S there. 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom
------------------------------


Original Message:
Sent: 08-09-2023 15:31
From: Jordan Shew
Subject: Using Two data sources in the same scene together

I tried responding from the email notification that you responded, but not sure it went to the correct place, Basically, I did not set this up originally, but am seeing that it is named Master Database Summary, so I'm guessing it is that(see picture for confirmation)..

Also, I do not have any experience writing a query to pull data(I've only used the Datalinq Properties tabs to pull data) or even know where to do so, but I'd be willing to try anything if you can point me in the right direction.

Thanks,

Jordan

------------------------------
Jordan Shew


Original Message:
Sent: 08-09-2023 05:10
From: Simon Redmile
Subject: Using Two data sources in the same scene together

Yes there is, are you using the master summary database or are you using xml's from the dak? 

Do you know how to write queries to get data? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom

OK, that was actually really helpful, but not for the problem I was trying to solve for...I see what you are doingand that would eliminate my excel document, which I like and I have that working, but what I am wanting to do is eliminate the need to update the jersey number manually at all as well. When the DakStats updates for the current batter, the variable noB_NUMBER is passing the current batter, and what I would like to do is use that number to return the batter information instead of my manually entered Jersey Number, so I would like to not use a DataLinq Key at all, but I'm not sure how to combine the game in progress information with the Master Roster Information...essentially two lookups into the same lookup...Does that make sense?

I tried creating a Text Field that is pulling noB_NUMBER, and it does output the correct number, but I'm not sure how to use that text field as part of the query?

Does that make sense? 

Hey, up that's the master summary database. 

OK in that case its laying it out like a table so what you can do is things like this. 

This is the home player table in dak master summery, there is G and S for Game and Season. 

This what you are used of I would imagine, so this would be linked to the first name on the first row in the home player table. 

In order to get the data you want based on a datalinqkey you'll need to use a query. 

SELECT [column you want] FROM [table you want] WHERE (column you want to search by] = value you want to use to search eg "11G"

The example below shows I am looking for first name from home player table where the datalinqkey called "Jersey" is whatever value you have entered and you'll see the letter G for game next to it, if I wanted season it would be an S there. 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom


Original Message:
Sent: 08-09-2023 15:31
From: Jordan Shew
Subject: Using Two data sources in the same scene together

I tried responding from the email notification that you responded, but not sure it went to the correct place, Basically, I did not set this up originally, but am seeing that it is named Master Database Summary, so I'm guessing it is that(see picture for confirmation)..

Also, I do not have any experience writing a query to pull data(I've only used the Datalinq Properties tabs to pull data) or even know where to do so, but I'd be willing to try anything if you can point me in the right direction.

Thanks,

Jordan

------------------------------
Jordan Shew


Original Message:
Sent: 08-09-2023 05:10
From: Simon Redmile
Subject: Using Two data sources in the same scene together

Yes there is, are you using the master summary database or are you using xml's from the dak? 

Do you know how to write queries to get data? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom

Try this while you wait for a reply...

In the query in the "table" field replace %Jersey% with @thenameofthedummytextobject@, using the name you used in your project

OK, that was actually really helpful, but not for the problem I was trying to solve for...I see what you are doingand that would eliminate my excel document, which I like and I have that working, but what I am wanting to do is eliminate the need to update the jersey number manually at all as well. When the DakStats updates for the current batter, the variable noB_NUMBER is passing the current batter, and what I would like to do is use that number to return the batter information instead of my manually entered Jersey Number, so I would like to not use a DataLinq Key at all, but I'm not sure how to combine the game in progress information with the Master Roster Information...essentially two lookups into the same lookup...Does that make sense?

I tried creating a Text Field that is pulling noB_NUMBER, and it does output the correct number, but I'm not sure how to use that text field as part of the query?

Does that make sense? 

Hey, up that's the master summary database. 

OK in that case its laying it out like a table so what you can do is things like this. 

This is the home player table in dak master summery, there is G and S for Game and Season. 

This what you are used of I would imagine, so this would be linked to the first name on the first row in the home player table. 

In order to get the data you want based on a datalinqkey you'll need to use a query. 

SELECT [column you want] FROM [table you want] WHERE (column you want to search by] = value you want to use to search eg "11G"

The example below shows I am looking for first name from home player table where the datalinqkey called "Jersey" is whatever value you have entered and you'll see the letter G for game next to it, if I wanted season it would be an S there. 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom


Original Message:
Sent: 08-09-2023 15:31
From: Jordan Shew
Subject: Using Two data sources in the same scene together

I tried responding from the email notification that you responded, but not sure it went to the correct place, Basically, I did not set this up originally, but am seeing that it is named Master Database Summary, so I'm guessing it is that(see picture for confirmation)..

Also, I do not have any experience writing a query to pull data(I've only used the Datalinq Properties tabs to pull data) or even know where to do so, but I'd be willing to try anything if you can point me in the right direction.

Thanks,

Jordan

------------------------------
Jordan Shew


Original Message:
Sent: 08-09-2023 05:10
From: Simon Redmile
Subject: Using Two data sources in the same scene together

Yes there is, are you using the master summary database or are you using xml's from the dak? 

Do you know how to write queries to get data? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom

Yah, I tried that as well, and it was not working...but I do have a solution for anyone else following. If I replace Simon's query from above with the text below:

SELECT [fstFIRSTNAME] FROM [HPlayerGmSn] WHERE [fstNUMBER] = (SELECT [noB_NUMBER] FROM [GameInProgress])

It works. That is pulling the number from the Game in Progress table, and using it in the Roster table to return the correct name.

Thanks everyone for your help! 

------------------------------
Jordan Shew
------------------------------


Original Message:
Sent: 08-12-2023 19:32
From: Paul
Subject: Using Two data sources in the same scene together

Try this while you wait for a reply...

In the query in the "table" field replace %Jersey% with @thenameofthedummytextobject@, using the name you used in your project

------------------------------
Paul


Original Message:
Sent: 08-12-2023 15:33
From: Jordan Shew
Subject: Using Two data sources in the same scene together

OK, that was actually really helpful, but not for the problem I was trying to solve for...I see what you are doingand that would eliminate my excel document, which I like and I have that working, but what I am wanting to do is eliminate the need to update the jersey number manually at all as well. When the DakStats updates for the current batter, the variable noB_NUMBER is passing the current batter, and what I would like to do is use that number to return the batter information instead of my manually entered Jersey Number, so I would like to not use a DataLinq Key at all, but I'm not sure how to combine the game in progress information with the Master Roster Information...essentially two lookups into the same lookup...Does that make sense?

I tried creating a Text Field that is pulling noB_NUMBER, and it does output the correct number, but I'm not sure how to use that text field as part of the query?

Does that make sense? 

------------------------------
Jordan Shew


Original Message:
Sent: 08-10-2023 05:59
From: Simon Redmile
Subject: Using Two data sources in the same scene together

Hey, up that's the master summary database. 

OK in that case its laying it out like a table so what you can do is things like this. 

This is the home player table in dak master summery, there is G and S for Game and Season. 

This what you are used of I would imagine, so this would be linked to the first name on the first row in the home player table. 

In order to get the data you want based on a datalinqkey you'll need to use a query. 

SELECT [column you want] FROM [table you want] WHERE (column you want to search by] = value you want to use to search eg "11G"

The example below shows I am looking for first name from home player table where the datalinqkey called "Jersey" is whatever value you have entered and you'll see the letter G for game next to it, if I wanted season it would be an S there. 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom


Original Message:
Sent: 08-09-2023 15:31
From: Jordan Shew
Subject: Using Two data sources in the same scene together

I tried responding from the email notification that you responded, but not sure it went to the correct place, Basically, I did not set this up originally, but am seeing that it is named Master Database Summary, so I'm guessing it is that(see picture for confirmation)..

Also, I do not have any experience writing a query to pull data(I've only used the Datalinq Properties tabs to pull data) or even know where to do so, but I'd be willing to try anything if you can point me in the right direction.

Thanks,

Jordan

------------------------------
Jordan Shew


Original Message:
Sent: 08-09-2023 05:10
From: Simon Redmile
Subject: Using Two data sources in the same scene together

Yes there is, are you using the master summary database or are you using xml's from the dak? 

Do you know how to write queries to get data? 

------------------------------
Simon Redmile
Senior Graphic Programmer & Designer
Ross Video
Bristol United Kingdom