https://wiki.netyce.com/ 2026-04-15T03:53:00+00:00 https://wiki.netyce.com/ https://wiki.netyce.com/lib/exe/fetch.php?media=wiki:logo.png text/html 2024-07-03T12:31:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.netyce.com/doku.php?id=guides:reference:relations:relations&rev=1720009873&do=diff Relations Relations allows the user to extend the standard node 'context' with information relevant to his design or use-case by means of SQL queries. Relations are in essence MySQL queries that allows the builder to create temporary datasets based on NetYCE database tables and conditions. These datasets are generated on the fly during Template or Job execution where their data can be used as variables. text/html 2024-07-03T12:31:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.netyce.com/doku.php?id=guides:reference:relations:transform&rev=1720009873&do=diff Transformed columns Relations (and custom reports too) can use in the query a NetYCE specific extension to the SQL syntax named “TRANSFORM”. This command will convert the values of a named column into its own column. When creating a relation (or 'named context') the SQL definition of the relation can be modified to automatically create additional columns based on the values found in the SQL results.