Thanks Timothy Leavitt, that's exactly what I was looking for. In addition, I added the "TotalPhones" column as a Transient property of ZenTutorial.Contact class. 

Property TotalPhones As %Integer [ Transient ]; 

Ok, I *think* I have it now.

ClientMethod onSelectRow() [ Language = javascript ]{	var resultsPane=zenPage.getComponentById('resultsPaneId');	var isHidden=resultsPane.getHidden();	if (!isHidden)	{		var table=zenPage.getComponentById('workBioTable');		var dataRow=table.getRowData(table.selectedIndex);	if (dataRow)	{		var rowID = zenPage.GetSelectedRowId(dataRow.RequestDate,dataRow.Worksheet,dataRow.SpecId);		if (rowID)		{			this.populatePIDForm(dataRow);			var waittoend = zenPage.GetAuditLogs(rowID);			this.populateAuditEvents();		}	}} // end-if}

Note the variable 'waittoend' and the zenPage.GetAuditLogs(RowId) method. This process builds the global that the secondary tablePane is built from. Without the return value, it is possible for the table to refresh before the global is built for the newly selected row.

Testing this has been difficult because in the most cases, the table was displayed correctly but several dozen clicks later you gasp, "Did I just see that!?" when you notice that on this one occasion it did not update correctly.

Done! See update in description.

Thanks @alexander-koblov, your solution worked perfectly :)

Hi Marco,

I think your problem might be to do with having declared 'TotalMatrix' as a transient property, it does not exist in the 'Relations' table. In my example, I referenced a table class called 'ZenTutorial.PhoneNumber' but my SQL statement did NOT refer to a 'TotalPhones' column.

Consider this

colExpression="(select count(*) from ZenTutorial.PhoneNumber where Contact=ZenTutorial.Contact.ID)"

So the result of the SQL goes into my TotalPhones column on my tablePane but the ZenTutorial.PhoneNumber class does not recognise it as a SQL field. Transient properties are useful when opening %Persistent objects and dynamically setting the transient property at the %OnOpen() event based on a set of conditions. As TotalPhones is marked as transient, it is not stored in the Global Mapping for %Library.CacheStorage. You cannot reference it in your SQL statement.

What if you tried something like

SELECT COUNT(*) AS TotalMatrix FROM Relations

You will need all those relationships in there though for it to work. If you have a <column> section defined in your tablePane be sure to set colName="TotalMatrix"

I hope that helps.

1.  Good question but I'm not fully sure I understand the design-time and runtime concepts so I'll try to explain it in different terms. If you open two Caché  objects in memory using something like ##class(MyProjectName.MyClass1).%OpenId(id1) and ##class(MyProjectName.MyClass2).%OpenId(id2) can you create an arbitrary parent-child relationship object that links the two open objects within the executing ClassMethod? The implication is that if you were then to delete the parent object, you would also delete it's children.

2. Exporting individual classes from one server to another and getting compile errors due to missing dependencies and child dependencies. The classes have been provided by another programmer but the relationships are not necessary for what I am doing. I would question why so many relationships were created but I suspect the programmer was trying to ensure that all the data and all the levels of a single global were mapped to a class property.

3. I'll initially try to keep this high-level and theoretical rather than immediately delve into working code examples. I can tell you that the classes have been created from a Global using a CacheSQLStorage strategy.

Sadly, the %CSP.REST class does not exist in Caché 2013.1.6 and the Class Explorer UML tool only works in Caché 2014.1 or later. We really struggle to keep pace with upgrades to Caché as there is always a fear that something will break after an upgrade is applied. Testing to confirm everything is working as expected is a huge undertaking and requires a lot of organisation. The next opportunity to upgrade Caché will probably be around Sept-Oct 2017.

Thanks Tom, we have implemented something very similar using the $System.License object.

The I+3 is a hard-coded expression. At first it appears arbitrary or random. I have just taken +3 as an example. We have real-world examples of expressions like 

When some condition is met 
S LINE(I-8)="some value"
When another condition is met
S LINE(I-17)="some value"

The hard-coded offset does not come from a variable. A lack of comments in the code makes it very difficult to understand and debug.

What about using more complex subcommand prefixes such as

ZZMYCOMMAND /MYSWITCH:OPT1:"some_param"

Could you code that using %ZLANG ?

There have been times when I have been asked to provide a 'proof-of-concept' or a 'working example' demonstrating a problem or some unexpected behaviour.  With code snippets, it is easy to embed code in a post; however, for more complex examples,  it is beneficial  to download a working example to test the behaviour out for yourself.

Here are some references to posts where I used the 'file upload' feature.

ZEN tablePane always selects the bottom row. Why?                 

The Art of Mapping Globals to Classes  (2 of 3)

There is currently provision for pdf, zip, tar, gz, png and jpg file types with files up to 256 MB in size.