The content inside the Autogenerated Section ...

[RickyLam]

Hi all,

I am assigned to edit a QS app, whose data load editor contains, among other sections, a section called "Autogenerated section". This Autogenerated section contains most loading codes repeated in other sections, plus an "[AutoCalendar]"

I don't know how come there is an "Autogenerated" section; but we maintain our Oracle database connections and SQL statements and other loading scripts in separate sections. At times when we edit these sections we found that we also need to modify the corresponding statements in the "Autogenerted" section, which is of course, very irritating. 

So is it possible to remove most of the overlapping script statements in the Autogenerated section, leaving the "autocalendar" statement behind without affecting the script loading? Please advise. 

[daturpin]

The autogenerated section is tied to the Data Manager.  If, for example, you connect to Databricks and load a bunch of tables, then link them by shared columns, all that gets written in code on the Autogenerated Section.

Autocalendar should generate if and only if some data is in the form of dates/times.

Now, if you have other things loading data, like Vizlib, the code MIGHT look similar, but it is activated differently. The Autogenerated Section runs when you reload the app or click 'Load Data', whereas the other sections are tied to a specific object, like a Vizlib writeback table, etc, and are called when you execute those objects.

In other words, the script might be a subset of the overall load script, or different. You still need to autogenerated section, however, to set up associations that your app can use.