Graphics

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.



------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

No this won't work. Give me a minute to try something. 

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

Original Message:
Sent: 03-01-2022 12:30
From: Josh Udvig
Subject: Json Filters in dataling

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

From the 2nd column from the batting order node in the pic.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

Original Message:
Sent: 03-01-2022 12:38
From: Simon Redmile
Subject: Json Filters in dataling

No this won't work. Give me a minute to try something. 

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

Original Message:
Sent: 03-01-2022 12:30
From: Josh Udvig
Subject: Json Filters in dataling

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

One way is to have a datalinq tied to the number filed you want and preappend the data with ID

The you can use a macro to complete the other datalinqs like this.
So my text object that has the innitatial datalinq is called Name 1 but you just put whatever the text object name is between the @@ but I am not sure if that's tidier than what you are doing with the visual logic.

I'll try some other things as well. ​

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

Original Message:
Sent: 03-01-2022 12:46
From: Josh Udvig
Subject: Json Filters in dataling

From the 2nd column from the batting order node in the pic.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 03-01-2022 12:38
From: Simon Redmile
Subject: Json Filters in dataling

No this won't work. Give me a minute to try something. 

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

Original Message:
Sent: 03-01-2022 12:30
From: Josh Udvig
Subject: Json Filters in dataling

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

Hey I continued to do some digging and you can search xml's, here's some examples. 

team<vh=%vh%>\player<oncourt=Y<1>>

 

Coach<job=Manager> 

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

Original Message:
Sent: 03-01-2022 12:46
From: Josh Udvig
Subject: Json Filters in dataling

From the 2nd column from the batting order node in the pic.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 03-01-2022 12:38
From: Simon Redmile
Subject: Json Filters in dataling

No this won't work. Give me a minute to try something. 

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

Original Message:
Sent: 03-01-2022 12:30
From: Josh Udvig
Subject: Json Filters in dataling

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

How would I search a node if all the child nodes are a different name?   I have done this before with <player."Child Name"=1B>  but all the child nodes are a different ID

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

Original Message:
Sent: 03-03-2022 06:02
From: Simon Redmile
Subject: Json Filters in dataling

Hey I continued to do some digging and you can search xml's, here's some examples. 

team<vh=%vh%>\player<oncourt=Y<1>>

 

Coach<job=Manager> 

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

Original Message:
Sent: 03-01-2022 12:46
From: Josh Udvig
Subject: Json Filters in dataling

From the 2nd column from the batting order node in the pic.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 03-01-2022 12:38
From: Simon Redmile
Subject: Json Filters in dataling

No this won't work. Give me a minute to try something. 

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

Original Message:
Sent: 03-01-2022 12:30
From: Josh Udvig
Subject: Json Filters in dataling

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

The child name will have to be a variable you fill out some otherway, I suggest a macro.

Do you have away of knowing the child node name, perhaps you can pull that with a query on the data first to find this out? 

Then you would end up with something like <player.@BATTER ID@=1B>

BATTER ID would be a text box somewhere in the project linked to a query to find that batter id number to complete the path.

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

Original Message:
Sent: 03-23-2022 11:33
From: Josh Udvig
Subject: Json Filters in dataling

How would I search a node if all the child nodes are a different name?   I have done this before with <player."Child Name"=1B>  but all the child nodes are a different ID

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 03-03-2022 06:02
From: Simon Redmile
Subject: Json Filters in dataling

Hey I continued to do some digging and you can search xml's, here's some examples. 

team<vh=%vh%>\player<oncourt=Y<1>>

 

Coach<job=Manager> 

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

Original Message:
Sent: 03-01-2022 12:46
From: Josh Udvig
Subject: Json Filters in dataling

From the 2nd column from the batting order node in the pic.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 03-01-2022 12:38
From: Simon Redmile
Subject: Json Filters in dataling

No this won't work. Give me a minute to try something. 

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

Original Message:
Sent: 03-01-2022 12:30
From: Josh Udvig
Subject: Json Filters in dataling

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

I can get that info, however I need to search like 20 child nodes in one query to find the 1B.  Is there a way to do that?
Could I do something like <player.@playerID1@;@playerID2@=1B> 

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------

Original Message:
Sent: 03-23-2022 11:38
From: Simon Redmile
Subject: Json Filters in dataling

The child name will have to be a variable you fill out some otherway, I suggest a macro.

Do you have away of knowing the child node name, perhaps you can pull that with a query on the data first to find this out? 

Then you would end up with something like <player.@BATTER ID@=1B>

BATTER ID would be a text box somewhere in the project linked to a query to find that batter id number to complete the path.

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

Original Message:
Sent: 03-23-2022 11:33
From: Josh Udvig
Subject: Json Filters in dataling

How would I search a node if all the child nodes are a different name?   I have done this before with <player."Child Name"=1B>  but all the child nodes are a different ID

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 03-03-2022 06:02
From: Simon Redmile
Subject: Json Filters in dataling

Hey I continued to do some digging and you can search xml's, here's some examples. 

team<vh=%vh%>\player<oncourt=Y<1>>

 

Coach<job=Manager> 

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

Original Message:
Sent: 03-01-2022 12:46
From: Josh Udvig
Subject: Json Filters in dataling

From the 2nd column from the batting order node in the pic.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 03-01-2022 12:38
From: Simon Redmile
Subject: Json Filters in dataling

No this won't work. Give me a minute to try something. 

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

Original Message:
Sent: 03-01-2022 12:30
From: Josh Udvig
Subject: Json Filters in dataling

So would it look like this
teams\home\players\"ID"+<battingOrder>
I put a pic in t make sure I am explaining things right.

I need to pull the batting order value in and append "ID" for the node above that.

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS

Original Message:
Sent: 02-28-2022 15:01
From: Simon Redmile
Subject: Json Filters in dataling

Have you tried just writing ID in the query before the number?

In this example you have "the ID number gores Here" in quotes, try putting the words you require eg ID and your ID number all within quotes so XPression knows its a string. 

team\home\players\"ID + wherever you are getting the ID number from"\person

This kind of thing works for SQL queries but I don't know enough about JSON to know if it will for sure. 

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

Original Message:
Sent: 02-24-2022 15:30
From: Josh Udvig
Subject: Json Filters in dataling

I have a data source that is giving me a ordered list of ID numbers.  I am trying to use the ID numbers to find other data in the file using the filter proses..
e.g.( team\home\players\"the ID number gores Here"\person )

However the child node i need to get to has a "ID" (string text) before the ID number i get from the ordered list.
e.g. (ID#######) 

I have a work around using text objects and adding the "ID" in Visual Logic, but this seems like an inefficient way to do this.  Is there a way to add the "ID" string to the ID number from the ordered list in the child node name.

Please let my know if more info is needed.

thanks!

------------------------------
Josh Udvig
CTN STUDIOS - COON RAPIDS
------------------------------