SOLVED - Values derived from List of records by MySql query Type is not saved in database

[amamyoj]

Hi,

Can anyone confirm or explain why the values derived from List of records by MySql query is not being saved in the database? In the entity Leading Indicators, I have a column there name "CCV - Managers Completed' and its type is 'List of records by MySql Query', when I checked the database, the value is not being saved in the database.

1st photo attached is the screenshot of the database
2nd photo is the column with the type List of Records by MySql Query
3rd photo is the supposed to be value of the column in the entity.

[Didou12]

No it’s not saved because it’s a MySQL query (dynamic).

https://docs.rukovoditel.net/index.php?p=101

What do you want to do with the count ? You have many options.

[amamyoj]

Thanks for replying. I have found a workaround for this. Instead getting the records from the Leading Indicators entity where the data is being combined from other entities. I wrote a query that will get those data from their original entities

[Didou12]

It’s perfect