Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

Firstly lest assume that you have the following, or something like it in your defaults section in your client config:

Code Block
xml
xml
titleInitial client config defaults sectionxml
<defaults>
  <entity id="lyr_suburbs />
  <entity id="lyr_properties" isDefault="true">
    <search>aq_property_by_address_auth</search>
    <data>ar_property_address_auth</data>
  </entity>
  <entity id="lyr_parcels"/>
</defaults>

...

Then elsewhere in you config files you have a data definition and data configuration that look like this:

Code Block
xml
xml
titleData configuration ready to have it formatting changedxml
<data:datadefinition id="__dd__ar_properties_sde">
  <datasourcedataconnection datasource="ds_sde" table="PROPERTIES_ACTIVE_REGION" key="PROPERTY_NUMBER" prefix="DISTINCT">
    <parameter type="string" name="sp_propno" label="Parcel Number" column="PROPERTY_NUMBER" />
    <parameter type="string" name="sp_houseno" label="House Number" column="HOUSE_NUMBER" />
    <parameter type="string" name="sp_roadname" label="Road Name" column="STREET_NAME" />
    <parameter type="string" name="sp_pubprop" label="Public/State Property" column="PUBLIC_PROPERTIES" />
    <parameter type="list" name="lp_landclass" label="Council Land Classification" column="PUBLIC_LAND_IDENTIFIER" list="vl_props_active"/>
    <parameter type="string" name="sp_propdesc" label="Property Description" column="PROPERTY_NAME" />
  </datasourcedataconnection>
</data:datadefinition>
<data:data id="ar_properties_sde" label="GIS - Property Details" entity="lyr_properties" datadefinition="__dd__ar_properties_sde" />

...

To do this first you need to add a <data> section to the defaults (I'll add it to the end of the defaults section I quoted above), e.g .

Code Block
xml
xml
titleDefaults section with empty data configuration sectionxml
<defaults>
  <entity id="lyr_suburbs />
  <entity id="lyr_properties" isDefault="true">
    <search>aq_property_by_address_auth</search>
    <data>ar_property_address_auth</data>
  </entity>
  <entity id="lyr_parcels"/>

  <data>
    <!-- This is the new data section that I was referring to above, at the moment it doesn't do anything, I'm just showing where it goes, note that I've added it just inside of the defaults tag, and not within an entity tag -->
  </data>

</defaults>

...

So to do this we need to add yet another <data> tag inside of the one we just added, and give it an id that matched the grid we want to edit, which in our example will be ar_properties_sde', we can do this multiple times to change the display of multiple grids, but for now we'll just do it for one grid, like this:

Code Block
xml
xml
titleDefaults section with empty data configuration section for a single gridxml
<defaults>
  <entity id="lyr_suburbs />
  <entity id="lyr_properties" isDefault="true">
    <search>aq_property_by_address_auth</search>
    <data>ar_property_address_auth</data>
  </entity>
  <entity id="lyr_parcels"/>

  <data>
    <data id="ar_properties_sde">
      <!-- This is the new sub-data section that I was just referring to, it still doesn't do anything, I'm just showing where it goes, what we add inside of this will alter the ar_properties_sde data display -->
    </data>
  </data>

</defaults>

Ok, so now to change the individual column formatting options for each parameter we want to change we have to add a <column> tag to the <data> tag we just added, the one with the id attribute, not the one without the id attribute. In our example we're only changing 2 columns, sp_houseno and sp_propdesc, the rest of the parameters defined in _dd_ar_properties_sde when displayed using the ar_properties_sde grid will use the default values.

Code Block
xml
xml
titleDefaults section with a data configuration section to change to columnsxml
<defaults>
  <entity id="lyr_suburbs />
  <entity id="lyr_properties" isDefault="true">
    <search>aq_property_by_address_auth</search>
    <data>ar_property_address_auth</data>
  </entity>
  <entity id="lyr_parcels"/>

  <data>
    <data id="ar_properties_sde">
      <column id="sp_houseno" width="20" align="right"/>
      <column id="sp_propdesc" width="200"/>
    </data>
  </data>

</defaults>

...

If you wanted to change the parameter display for column in data definition other than the ar_properties_sde grid you would create a new <data> tag with the id of the data you want to change, for example if we have another data definition and a corresponding a <data> (this is the data t6ag related to the data definition, not the one we're adding here) tag with the id ar_conquest_council_building_details, so you could add a <data id="ar_conquest_council_building_details">...</data> tag to the top data tag we just added (the one without the id), like so:

Code Block
xml
xml
titleDefaults section with multiple data configuration section to alter multiple gridxml
<defaults>
  <entity id="lyr_suburbs />
  <entity id="lyr_properties" isDefault="true">
    <search>aq_property_by_address_auth</search>
    <data>ar_property_address_auth</data>
  </entity>
  <entity id="lyr_parcels"/>

  <data>
    <data id="ar_properties_sde">
      <column id="sp_houseno" width="20" align="right"/>
      <column id="sp_propdesc" width="200"/>
    </data>
    <data id="ar_conquest_council_building_details">
      <!-- you would add some column tags here like the one above, I haven't done this so this won't actually do anything, but you get idea -->
    </data>
  </data>

</defaults>

The final step you could take is if you have the same parameter used in multiple data definition and you want to change all of them at once. To do this you add a <column> tag at the same level as the <data> tags (the ones with the id's), for example, if you wanted to change all of the parameters named strnum and strname you would do the following:

Code Block
xml
xml
titleDefaults section with multiple data configuration section to alter multiple grid and globally altering some columnsxml
<defaults>
  <entity id="lyr_suburbs />
  <entity id="lyr_properties" isDefault="true">
    <search>aq_property_by_address_auth</search>
    <data>ar_property_address_auth</data>
  </entity>
  <entity id="lyr_parcels"/>

  <data>
    <data id="ar_properties_sde">
      <column id="sp_houseno" width="20" align="right"/>
      <column id="sp_propdesc" width="200"/>
    </data>
    <data id="ar_conquest_council_building_details">
      <!-- you would add some column tags here like the one above, I haven't done this so this won't actually do anything, but you get idea -->
    </data>
    <!-- this is where I'm changing the grid display for some parameter globally, every data definition that's displayed to the user with a parameter with these names will be formatted according to what we do here -->
    <column id="strnum" width="50" align="right"/>
    <column id="strname" width="100"/>
  </data>

</defaults>

...