topic Re: $Field and Derive Fields in App Development

$Field and Derive Fields

JGMDataAnalysis — Wed, 20 Oct 2021 16:32:46 GMT

Hi everyone!

Is there a way to list all derived fields from a particular table?

With the third set modifier I can ignore the selections made on any of the fields in the "ConsumosServicios" table, with the exception of derived fields, which unfortunately are not included in $Field.

Count( {< [Flag_Activo_TrxServicio] = {1} ,[Flag_SinConsumo_TrxServicio] = {1} ,$(='[' & Concat({1<$Table = {ConsumosServicios}>} $Field, '], [') & ']') >} Distinct [Número Línea] )

Re: $Field and Derive Fields

marcus_sommer — Thu, 21 Oct 2021 09:20:19 GMT

I don't know if there is a possibility to identify and fetch these derived fields. I'm not sure if there is a real benefit in the easiness to create them, their readability, their impact on the performance and the use within the UI - against regular created fields. Therefore I suggest to consider to adjust the approach.

- Marcus

Re: $Field and Derive Fields

JGMDataAnalysis — Thu, 21 Oct 2021 12:10:02 GMT

Thank you very much @marcus_sommer.