SQL CLASS NODE SYNTAX

Question

Question

I HAVE A NEW SQL CLASS THAT DISPLAYS ENTRIES BASED ON THE FIRST 2 NODES OF A GLOBAL. I FOUND OUT THAT THE CLASS ALLOWS FOR AN ADDITIONAL NODE(s) TO BE INSERTED IN THE "User Specification Node:" along the delimiter and the Piece in the NewStorage Map1 for "ModifyDDDD" shown below. it is not working.

^GBL("AA","SSSSSS")="1:1:1:1:"

^GBL("AA,"MD",1,1)="1:"

^GBL("AA,"MD","A",1)="0:"

I HAVE USED THIS:

<Data name="ModifyDDDD">
<Delimiter>":"</Delimiter>
<Node>"3,4"</Node>
<Piece>1</Piece>
</Data>

WHILE IT COMPILES IT DISPLAY NOTHING. MY QUESTION IS WHAT IS THE RIGHT SYNTAX AND PUNTUATION FOR THIS, PLEASE?

HOW DO I TYPE IN THE <Node> tag the proper formated data? <Node>"MD","A",1</Node> ??????

Since the class is build on the first 2 nodes, should it be <Node>"A",1</Node>

I tried many different combinations to no avail.

Product version: Caché 2013.1

Discussion (5)2

Log in or sign up to continue

score 0 · Answer 1 · 2024-11-15T06:13:45-05:00

The data in your sample globals is kind of terse :-)

Can you please clarify what you expect the SQL projection to yield as rows and columns?

Please also see Brendan's excellent series of articles about custom storage mappings: https://community.intersystems.com/post/art-mapping-globals-classes-1-3

score 0 · Answer 2 · 2024-11-15T08:15:15-05:00

my class is build on the global with two nodes. but one of my columns should reference the data in the global entry that has 4 nodes. I want to capture the value from ^OPG("AC","MD",1,3) and get the "1:" using the "Use Specifications: " option shown below without having to create a "Calculated SqlComputeCode" function in the code

score 0 · Answer 3 · 2024-11-15T08:32:14-05:00

But what represents your master map and row level? is that are these 14 entries all corresponding to one and the same row, presumably with some sort of IDKEY consisting of "AC" and "MD"? We cannot say much meaningful without understanding that broader picture.

score 0 · Answer 4 · 2024-11-15T08:40:30-05:00

each entry in the global is unique. i only need to be able to access only one entry. say, ^OPG("AC","MD",1,3). that's it.

score 0 · Answer 5 · 2024-11-15T08:54:14-05:00

Then you'd need to define those four subscript levels as part of your IDKEY and have your data map look like this:

<Data name="ModifyDDDD">
<Delimiter>":"</Delimiter>
<Piece>1</Piece>
</Data>

Please see the examples attached to the series of articles I referenced earlier