Radicore Forum: Framework » Screen/Report

Home » RADICORE development » Framework » Screen/Report - calculated/concat fields

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Screen/Report - calculated/concat fields [message #5597]

Thu, 02 June 2016 11:55

htManager
Messages: 433
Registered: May 2014

Senior Member

Can I display two or more field values as 'calculated' fields like this in a report (and/or in a screen):

$structure['title'][] = array('text' => 'CONCAT(vereine_kuerzel, \' - \', mannschaften_id)',
'width' => 100,
'align' => 'left',
'x' => 45);

I tried it with the SQL_FROM statement with a LEFT JOIN in the script file too but with no success.

$sql_from = 'training_plan_kopf '
. 'LEFT JOIN orga_mannschaften ON ('
. 'training_plan_kopf.vereine_kuerzel = orga_mannschaften.vereine_kuerzel AND '
. 'training_plan_kopf.mannschaften_id = orga_mannschaften.mannschaften_id) '
. 'CONCAT(vereine_kuerzel, \' - \', mannschaften_id) AS verein_id ';

The SQL statement brings up an error. You see an ending ')' behind the WHERE clause but no beginning one.

Or is there a better way?

Report message to a moderator

Re: Screen/Report - calculated/concat fields [message #5598 is a reply to message #5597]

Fri, 03 June 2016 04:50

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

You can certainly use a function such as CONCAT() in a SELECT statement, but in your example you have placed it after the FROM clause instead of before, which produces an invalid query.

You could always combine two or more fields into a single field within your PHP code, such as in the _cm_post_getData() method.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Task ID/Script ID
Next Topic:	Convert date ccyy-mm-dd to dd.mm.ccyy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 21 05:16:47 EST 2024

Total time taken to generate the page: 0.01119 seconds