Store Simple Calculated fields as plain text for reporting

Mahir Garibli shared this idea 9 months ago
Awaiting Reply

Currently when a simple calculated field is created it is stored in the DB as;

FIELD[60698]ARITHMETIC[+]FIELD[60656]

We would like us to also store the plain text version along side this so that it can be reported on and used to manage user created reports by administrators. The above would then be stored as;

Athlete ID + Athlete Age.

Comments (5)

photo
1

Hi Mahir,

The development team have been working on creating a formatter plugin here. We have run some tests on our end and we'd like you to take a look and let us know your thoughts please! The plugin should work on versions 8 and 9 so please download from this ticket and apply to your system for testing.

Kind regards,

Richard Convery

photo
1

Hi,

Thanks for update. Do you have any guide how to install this ?

photo
1

Simple java -jar package name is not working.

[root@app-server-01 ~]# /opt/jdk1.8.0_121/bin/java -jar CalcFieldSQLFormatter.jar 
no main manifest attribute, in CalcFieldSQLFormatter.jar
[root@app-server-01 ~]# 

photo
1

Hi Fariz,

To install the plugin, go to your Yellowfin install, then Administration -> Plug-in management. You should be able to install there.

I hope that helps!

Kind regards,

Chris

photo
1

Thanks for answer. I installed plugin. We will test it soon.

Thanks