Exclude Columns from Date Shift

LabKey Support Forum (Inactive)
Exclude Columns from Date Shift balter  2016-09-25 16:56
Status: Closed
 
On this page

https://www.labkey.org/home/Documentation/wiki-page.view?name=studyPubPHI

it says that you can override specific date columns from getting shifted when publishing a study. Is there a way to configure this in the .query.xml file?
 
 
Steve responded:  2016-09-26 09:56
Hi:
Yes, you can do this in the XML directly. (In general whatever you can do with the field properties GUI, you can also do directly with XML.)

The XML would look something like this:

<tables xmlns="http://labkey.org/data/xml">
  <table tableName="Demographics" tableDbType="NOT_IN_DB">
    <columns>
      <column columnName="date">
        <excludeFromShifting>true</excludeFromShifting>
      </column>
    </columns>
  </table>
</tables>

Thanks, Steve
 
balter responded:  2016-09-26 21:11
Thanks!