Search found 214 matches

by rennecke
19 Dec 2022, 13:26
Forum: Bug Report version 3.2
Topic: Input Numeric Field in Comments - does not average although it is set
Replies: 4
Views: 1324

Re: Input Numeric Field in Comments - does not average although it is set

OK, got it. Thanks.
I use

Code: Select all

SELECT COUNT(id) FROM app_comments WHERE app_comments.entities_id = 25 AND app_comments.items_id = [id]
by rennecke
19 Dec 2022, 11:48
Forum: Bug Report version 3.2
Topic: Input Numeric Field in Comments - does not average although it is set
Replies: 4
Views: 1324

Re: Input Numeric Field in Comments - does not average although it is set

Hello.
Many thanks for the feedback.
Do you have a hint, how to count the number of comments for a record?
Regards Eberhard
by rennecke
19 Dec 2022, 00:00
Forum: Bug Report version 3.2
Topic: Input Numeric Field in Comments - does not average although it is set
Replies: 4
Views: 1324

Input Numeric Field in Comments - does not average although it is set

Hello. I have set a field type "Input Numeric Field in Comments" and set "Calculate average value". My understanding is, that all values in the comments will be averaged. FieldConfig.png This is not working. It is summarizing the comments values. Screen.png Did I set up something...
by rennecke
01 Sep 2022, 10:29
Forum: Bug Report version 3.2
Topic: [solved] Setting up Import Template
Replies: 2
Views: 206

Re: Setting up Import Template

Works fine. Many thanks.
by rennecke
31 Aug 2022, 13:03
Forum: Bug Report version 3.2
Topic: [solved] Setting up Import Template
Replies: 2
Views: 206

[solved] Setting up Import Template

When setting up import template I get this warning when saving the template: "Warning: Undefined array key "multilevel_import" in /home/httpd/vhosts/rennecke.ch/hzi.rennecke.ch/eic/plugins/ext/modules/templates/actions/import_templates.php on line 20 Warning: Cannot modify header info...
by rennecke
03 Aug 2022, 18:07
Forum: Bug Report version 3.0
Topic: Pivot Table Pro
Replies: 6
Views: 1830

Re: Pivot Table Pro

You are right. It's working.
by rennecke
03 Aug 2022, 16:56
Forum: Bug Report version 3.0
Topic: Pivot Table Pro
Replies: 6
Views: 1830

Re: Pivot Table Pro

Thanks for the hint.
At least the MySQL-Formula is working. I get a value for all:
Fields_PivotPRO.png
But the field selection in Pivot Tables Pro is just saying COUNT:
List_with_0.png
by rennecke
03 Aug 2022, 12:48
Forum: Bug Report version 3.0
Topic: Pivot Table Pro
Replies: 6
Views: 1830

Re: Pivot Table Pro

Hello. I've a similar issue and can not find the failure: I have a function calculating the SUM of a numeric field [785]. function_10.png This function is than used in a MySQL-formula: MySQL-Formula.png As I thought, that maybe {10:841} gives NULL or empty string ("") back in case there is...
by rennecke
02 Aug 2022, 13:06
Forum: Discussion
Topic: Values from Related Records in SQL Query / Formula
Replies: 4
Views: 253

Re: Values from Related Records in SQL Query / Formula

Great, many thanks.
This was easier, than I thought. :D
by rennecke
02 Aug 2022, 10:29
Forum: Discussion
Topic: Values from Related Records in SQL Query / Formula
Replies: 4
Views: 253

Re: Values from Related Records in SQL Query / Formula

Thanks, I know.
But how to select only values from records linked as field type "Related Items"?