Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » Show additional column in a LIST1 transaction pattern (a column not part of a parent table)
Show additional column in a LIST1 transaction pattern (a column not part of a parent table) [message #5437] Thu, 17 March 2016 07:33 Go to next message
jjtoranzo2004 is currently offline  jjtoranzo2004
Messages: 261
Registered: September 2012
Senior Member
Tony I have the following problem. I want to show an additional column in a LIST1 transaction pattern that does not belong to the main table or any of its parent tables. The column is part of a "grandparent" table.

In order to retrieve the data from the database I followed these steps:

1 - Amend the component script to change the proper $sql_ variables. The $sql_select and the $sql_from variables.

2 - I edited the class file and changed the _cm_changeConfig function to add additional entries to the $fieldarray array.

3 - Change the screen file to include the fields and set their width.

The problem is that the title of the column is shown but not the corresponding data.

Can you point me in the right direction? I am sure I am forgetting something obvious.
Re: Show additional column in a LIST1 transaction pattern (a column not part of a parent table) [message #5439 is a reply to message #5437] Fri, 18 March 2016 05:45 Go to previous message
AJM is currently offline  AJM
Messages: 2246
Registered: April 2006
Location: Surrey, UK
Senior Member
You do not need to make any changes to the $fieldspec array in _cm_changeConfig unless you want the data validated before a WRITE operation, or formatted for display.

You need to chack that the new column is actually included in the data which is returned from the call to _dml_getData and added to the XML document. If you look at http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq51 you will see some debugging options that may be usefull.


Previous Topic: Open a new window from RADICORE
Next Topic: List sibling records given a child record
Goto Forum:
  


Current Time: Sat Jun 12 07:51:55 EDT 2021

Total time taken to generate the page: 0.01524 seconds