Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
Clear All
new posts
Previous template Next
    #1

    trouble saving form data with a valuesManager

    Using: SmartClient_v111p_2017-10-31_PowerEdition

    I'm not getting saves to work as I imagined with a set of forms bound to a valuesManager. I have saveOnEnter:"true" on all of the forms and on the valuesManager. Pressing enter in the forms does not trigger a save though. Instead I get:

    ISC_Core.js?isc_version=v11.1p_2017-10-31.js:1750 [Violation] 'setTimeout' handler took 65ms

    I also have a button on the page. If I bind click: to call saveData() on a member form, that form will save. When instead I have click: bound to call saveData() on the valuesManager no save happens.

    So I wonder if this is a mistake in my code or a bug in SC.

    Thanks
    RP.

    The VM and forms, including the button with click: bound to saveData for one of the forms.


    isc.ValuesManager.create({
    ID:"personalInfo",
    saveOnEnter:"true",
    canEdit:"true",
    dataSource:"people"
    });

    isc.DynamicForm.create({
    ID:"personalDetailsName",
    autoDraw:false,
    dataSource:"people",
    numCols:6,
    canEdit:"true",
    valuesManager:"personalInfo",
    saveOnEnter:"true",
    fields:[
    {
    name:"nameLast",
    title:"Last",
    saveOnEnter:"true",
    _constructor:"TextItem"
    },
    {
    name:"nameFirst",
    title:"First",
    _constructor:"TextItem"
    },
    {
    name:"nameMiddle",
    title:"Middle",
    _constructor:"TextItem"
    },
    {
    name:"namePreferred",
    title:"Preferred",
    _constructor:"TextItem"
    },
    {
    name:"nameInitials",
    title:"Initials",
    _constructor:"TextItem"
    },
    // {
    // name:"spouseName",
    // title:"Spouse name - Was used for faculty - probably not necessary",
    // _constructor:"TextItem"
    // },
    // {
    // name:"dateOfBirth",
    // title:"Date of birth",
    // _constructor:"DateItem"
    // },
    {
    name:"gender",
    title:"Gender",
    _constructor:"TextItem"
    },
    {
    name:"includeInDirectory",
    title:"Include in Directory",
    defaultValue:"true",
    _constructor:"CheckboxItem"
    },
    {
    name:"isGroupPI",
    title:"Is PI",
    defaultValue:"false",
    _constructor:"CheckboxItem"
    },
    {
    name:"directoryType",
    title:"Group",
    valueMap:[
    "All",
    "01-Faculty",
    "02-Auxiliary Faculty",
    "03-Office, Shop & Teaching Staff",
    "04-Research Staff & Postdocs",
    "05-Graduate Students",
    "06-E-mail Lists",
    "07-Miscellaneous",
    "08-Student Help",
    "09-Teaching Assistants"
    ],
    _constructor:"FormItem"
    },
    {
    name:"directoryTitle1",
    title:"Title1",
    _constructor:"TextItem"
    },
    {
    name:"directoryTitle2",
    title:"Title2",
    _constructor:"TextItem"
    },
    {
    name:"directoryTitle3",
    title:"Title3",
    _constructor:"TextItem"
    },
    {
    name:"emailAddress",
    title:"Email Address",
    _constructor:"TextItem"
    },
    {
    name:"personNotes",
    title:"Notes",
    _constructor:"TextAreaItem"
    },
    {
    name:"id_People",
    title:"UID",
    _constructor:"TextItem"
    }
    ]
    });


    
    ​ ID:"personalDetailsID",
    autoDraw:false,
    dataSource:"people",
    numCols:6,
    valuesManager:"personalInfo",
    canEdit:"true",
    saveOnEnter:"true",
    fields:[
    {
    name:"hrsPersonID",
    title:"EMPLID",
    _constructor:"TextItem"
    },
    {
    name:"uwPVI",
    title:"UW PVI",
    _constructor:"TextItem"
    },
    {
    name:"isisEmplID",
    title:"ISIS EMLPID",
    _constructor:"TextItem"
    },
    {
    name:"isisCampusID",
    title:"ISIS Campus ID",
    _constructor:"TextItem"
    },
    {
    name:"uwPhotoID",
    title:"WiscCard #",
    _constructor:"TextItem"
    },
    {
    name:"uwNetID",
    title:"UW netid",
    _constructor:"TextItem"
    }
    // {
    // name:"caeUserName",
    // title:"CAE username",
    // _constructor:"TextItem"
    // }
    ]
    });

    isc.DynamicForm.create({
    ID:"personalDetailsEmerg",
    autoDraw:false,
    dataSource:"people",
    numCols:4,
    valuesManager:"personalInfo",
    canEdit:"true",
    saveOnEnter:"true",
    fields:[
    {
    name:"emergencyContactName",
    title:"Name",
    _constructor:"TextItem"
    },
    {
    name:"emergencyContactPhone",
    title:"Phone",
    _constructor:"TextItem"
    },
    {
    name:"emergencyContactAddress1",
    title:"Address 1",
    _constructor:"TextItem"
    },
    {
    name:"emergencyContactAddress2",
    title:"Address 2",
    _constructor:"TextItem"
    },
    {
    name:"emergencyContactCity",
    title:"City",
    _constructor:"TextItem"
    },
    {
    name:"emergencyContactState",
    title:"State",
    _constructor:"TextItem"
    },
    {
    name:"emergencyContactPostalCode",
    title:"Postal code",
    _constructor:"TextItem"
    },
    {
    name:"emergencyContactCountry",
    title:"Country",
    _constructor:"TextItem"
    }
    ]
    });

    isc.DynamicForm.create({
    ID:"personalDetailsForward",
    autoDraw:false,
    dataSource:"people",
    numCols:4,
    valuesManager:"personalInfo",
    canEdit:"true",
    saveOnEnter:"true",
    fields:[
    {
    name:"forwardingName",
    title:"Name",
    _constructor:"TextItem"
    },
    {
    name:"forwardingPhone",
    title:"Phone",
    _constructor:"TextItem"
    },
    {
    name:"forwardingAddress1",
    title:"Address 1",
    _constructor:"TextItem"
    },
    {
    name:"forwardingAddress2",
    title:"Address 2",
    _constructor:"TextItem"
    },
    {
    name:"forwardingCity",
    title:"City",
    _constructor:"TextItem"
    },
    {
    name:"forwardingState",
    title:"State",
    _constructor:"TextItem"
    },
    {
    name:"forwardingPostalCode",
    title:"Postal Code",
    _constructor:"TextItem"
    },
    {
    name:"forwardingCountry",
    title:"Country",
    _constructor:"TextItem"
    }
    ]
    });

    isc.Button.create({
    ID:"personalInfoSaveButton",
    title:"Save",
    click: function() {personalDetailsName.saveData()}
    });


    The datasource:

    <DataSource ID="people" dataFormat="iscServer" serverType="sql" dataSourceVersion="1" dbName="personnel" tableName="people" quoteTableName="false" tableCode="12a032ce9179c32a6c7ab397b9d871fa" allowAdvancedCriteria="true" generatedBy="v11.0p_2017-05-15/PowerEdition Deployment 2017-05-15">
    <fields canEdit="true">
    <field name="id_People" type="sequence" title="5-digit unique ID number" primaryKey="true" columnCode="b80bb7740288fda1f201890375a60c8f" canEdit="true">
    <validators>
    <Validator>
    <type>isInteger</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="creationName" type="creator" length="30" title="Username at creation" columnCode="e42c0aa75dbb35ad2830509e06adb3ad" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="creationTimestamp" type="creatorTimestamp" title="Date/time at creation" columnCode="4f61ac2b5fa45842b5f63e744658ced7" canEdit="true">
    <validators>
    <Validator>
    <type>isDate</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="modificationName" type="modifier" length="30" title="Username at last modification" columnCode="2d04811245bab95ecd83512debbe645d" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="modificationTimestamp" type="modifierTimestamp" title="Date/time at last modification" columnCode="d47dcb3d1813a63b358e2483c6fab435" canEdit="true">
    <validators>
    <Validator>
    <type>isDate</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="nameLast" type="text" length="40" title="Last name" columnCode="1b4eddfd113273c5daf1bc74e50a5cc8" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="nameFirst" type="text" length="40" title="First name" columnCode="e2af3968e57cc418dc3356831a570c70" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="nameMiddle" type="text" length="40" title="Middle name or initial" columnCode="9d783fc820471aca06f7f26aa68cd363" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="namePreferred" type="text" length="40" title="Preferred first name" columnCode="4ddd5cd155a7611bd270fa46ace5a649" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="nameInitials" type="text" length="4" title="Initials - Used mainly for PIs" columnCode="52168b1712bec4032e33fcf105964d4b" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="spouseName" type="text" length="40" title="Spouse name - Was used for faculty - probably not necessary" columnCode="3004265049b288debfe099dfda9ba828" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="startDate" type="date" title="Start date with department - Default to earliest date in HRS" columnCode="4e30b6d6aa33492da947b4c6ab31c7ca" canEdit="true">
    <validators>
    <Validator>
    <type>isDate</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="startDateOverride" type="integer" title="1 to override HRS start date" columnCode="1fc9ce688d5ed8adad43f0c6f5fe3c9f" canEdit="true">
    <validators>
    <Validator>
    <type>isInteger</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="endDate" type="date" title="End date with department - Default to latest end date in HRS - NULL if still in department" columnCode="e0a186d8a0d8f936632fd1bf39991398" canEdit="true">
    <validators>
    <Validator>
    <type>isDate</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="endDateOverride" type="integer" title="1 to override HRS end date" columnCode="158d258010aed8b837ee6e16089fc47a" canEdit="true">
    <validators>
    <Validator>
    <type>isInteger</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="dateOfBirth" type="date" title="Date of birth" columnCode="0d155167f498c4d66bbfedda7c17bedc" canEdit="true">
    <validators>
    <Validator>
    <type>isDate</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="gender" type="text" length="1" title="Gender (M/F)" columnCode="cc90f1913b83d255b95be0e0fea6d576" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="hrsPersonID" type="text" length="8" title="Person ID in HRS" columnCode="63e57407f6ef6cc5622ce4dae01295f4" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    <Validator>
    <type>isUnique</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="uwPVI" type="text" length="9" title="Publicly Visible Identifier" columnCode="5ec28c133fdd720ac4812f05a9815746" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    <Validator>
    <type>isUnique</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="isisEmplID" type="text" length="10" title="Empl ID in ISIS" columnCode="20db8c61285e08ebc257727723382078" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="isisCampusID" type="text" length="10" title="Campus ID in ISIS" columnCode="14d7f3e657edbd70773654759c5a4061" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="uwPhotoID" type="text" length="11" title="WiscCard ID" columnCode="8526e8a3b9e6b1e6531ac03224e42dba" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="uwNetID" type="text" length="20" title="UW-Madison netid" columnCode="afb5c4c1cd02d30e3891b0834a44c2cc" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="caeUserName" type="text" length="20" title="CAE username" columnCode="dea2075512c72c54c0b92fc04179e64f" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="payrollNotes" type="text" length="65535" title="Freeform notes regarding employment" columnCode="f9aaa572e7572e5ec64a37327cab77b0" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="isActive" type="boolean" title="1 if active in department" columnCode="445e6b938b0faf72dadef09820420a37" canEdit="true">
    <validators>
    <Validator>
    <type>isBoolean</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="includeInDirectory" type="boolean" sqlStorageStrategy="integer" title="1 to include in printed directory" columnCode="2b44213ac9304d275296fe865a2d2248" canEdit="true">
    <validators>
    <Validator>
    <type>isBoolean</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="isGroupPI" type="boolean" sqlStorageStrategy="integer" title="1 if person is a PI" columnCode="88bfca23245f78fc1a67d103a51aba1d" canEdit="true">
    <validators>
    <Validator>
    <type>isBoolean</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="directoryType" type="text" length="40" title="Person type (faculty, staff, grad, etc.)" columnCode="58a10c6386a4126abf8dac2bccde2ea2" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    <defaultErrorMessage>"Choose a Person Type"</defaultErrorMessage>
    </Validator>
    </validators>
    </field>
    <field name="directoryTitle1" type="text" length="40" title="Primary title" columnCode="c44a12a5a7ca51493644109e6bb86606" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="directoryTitle2" type="text" length="40" title="Secondary title (if any)" columnCode="08933b7b649f24133772b4e09fc02b9d" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="directoryTitle3" type="text" length="40" title="Tertiary title (if any)" columnCode="d0f6331341b1ea67daac1b09a63b0ee5" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="personalCode" type="text" length="4" title="Unique 4-digit code - basis for copier code" columnCode="4735e95d740cfa05cba801dc7e30048b" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    <Validator>
    <type>isUnique</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emailAddress" type="text" length="40" title="Primary email address" columnCode="cc4e2bfd157f839a82896454a5feb80d" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="homeStreet" type="text" length="40" title="Local address - Street address" columnCode="0352896ae255fb386c024385212ab15e" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="homeCity" type="text" length="40" title="Local address - City" columnCode="e4d2da46163b0a407a0eb0e8f0ead09d" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="homeState" type="text" length="10" title="Local address - State" columnCode="36b186add41971c6a871120083626036" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="homeZipCode" type="text" length="10" title="Local address - Zip Code" columnCode="359418349abec7a6118c44dcb1d8ccf1" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="homePhone" type="text" length="20" title="Local phone number" columnCode="0ee82c3db32f042b9c93f3e247bdc442" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="homeAddressOmit" type="integer" title="1 to omit home address from public directory" columnCode="5a45d98b525b56f2f4d7f6a7a9598a52" canEdit="true">
    <validators>
    <Validator>
    <type>isInteger</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactName" type="text" length="40" title="Emergency contact - Name" columnCode="dc2ca15a2e5c0232e9b755bd9e89b189" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactAddress1" type="text" length="40" title="Emergency contact - Address 1" columnCode="3d5d071846f0ae4604e3fb8bb8afe227" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactAddress2" type="text" length="40" title="Emergency contact - Address 2" columnCode="b5dbc76ac7c13464c8e2c407435c7596" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactCity" type="text" length="40" title="Emergency contact - City" columnCode="206826831bec979036927a233c575625" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactState" type="text" length="10" title="Emergency contact - State" columnCode="89b4e608719295a9354b268711c1c272" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactPostalCode" type="text" length="10" title="Emergency contact - Postal code" columnCode="45b4099d23fe6661012c7debd5a9bd0e" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactCountry" type="text" length="20" title="Emergency contact - Country" columnCode="9af9047938d29f3799d34500d49d4387" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="emergencyContactPhone" type="text" length="20" title="Emergency contact - Phone" columnCode="b1fe864219ce53352f2eeed55e20b58d" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingName" type="text" length="40" title="Forwarding information - no longer with department" columnCode="c2eedf8d93151cb05fde834a3d54121f" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingAddress1" type="text" length="40" title="Forwarding address - Address 1" columnCode="1b1f1453c06aa226e8cdd9759aaacb55" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingAddress2" type="text" length="40" title="Forwarding address - Address 2" columnCode="b6db2655f50ffdb08a6ef260be78dc5e" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingCity" type="text" length="40" title="Forwarding address - City" columnCode="8045ea0337d94e859560826c9c5568b9" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingState" type="text" length="10" title="Forwarding address - State" columnCode="21d623f16753924d98a92b59e060628b" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingPostalCode" type="text" length="10" title="Forwarding address - Postal Code" columnCode="0bec0a13ac070fb4d9a52295ef8ca417" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingCountry" type="text" length="20" title="Forwarding address - Country" columnCode="7ba92dc118012e1fa5b73e3d6835e885" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingPhone" type="text" length="20" title="Forwarding phone number" columnCode="c70957d94d0bb38f0c50858f2b325389" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingModificationDate" type="date" title="Forwarding information last modification date" columnCode="34994e47aea07f59936eb954cb0c34e5" canEdit="true">
    <validators>
    <Validator>
    <type>isDate</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="forwardingModificationName" type="text" length="20" title="Forwarding information last modification username" columnCode="f572a8f3b129b0f29bbcf4d3c6728713" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="personNotes" type="text" length="65535" title="Free-form notes" columnCode="9bf3b7d974ce8182f352c3460fadf876" canEdit="true">
    <validators>
    <Validator>
    <type>isString</type>
    <stopIfFalse>true</stopIfFalse>
    <typeCastValidator>true</typeCastValidator>
    </Validator>
    </validators>
    </field>
    <field name="lastFirst" type="text" length="82" title="Last, First" canEdit="true">
    <customSelectExpression>concat(people.nameLast,', ',people.nameFirst)</customSelectExpression>
    </field>
    </fields>
    <operationBindings>
    <!--
    <operationBinding operationType="fetch" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelViewers"></operationBinding>
    <operationBinding operationType="add" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelEditAll"></operationBinding>
    <operationBinding operationType="update" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelEditAll"></operationBinding>
    <operationBinding operationType="remove" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelEditAll"></operationBinding>
    -->
    <operationBinding operationType="fetch" operationId="directoryTypes" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelViewers">
    <groupBy>directoryType</groupBy>
    </operationBinding>
    </operationBindings>
    <sequenceMode>jdbcDriver</sequenceMode>
    </DataSource>
    Last edited by rpoyner; 21 Nov 2017, 10:11. Reason: Fixed datasource formatting
    Tags: None
    #2
    You are setting Boolean properties such as saveOnEnter to Strings - instead of "true" you want just true without quotes.

    There are odd problems in your DataSource too - repeatedly declarations of "typeCastValidators". These need not be declared as they are implicit.

    Try correcting the above and then creating a simple test case using one of the built-in sample DataSources, and if the problem still persists there, after testing against the latest patched version, we can take a look.

    Comment

      #3
      Using: SmartClient_v111p_2017-11-27_PowerEdition and the builtin SDK.

      Created an example as you suggested using the builtin Hibernate database and it works. A very similar example using MySQL and the datasource posted above fails. The forms load and are filled with data from the record loaded in the example, but saving either by pressing enter or clicking the button does nothing. What's worse is that both the browser console log and the server log are completely silent when I hit enter or click on the save button. Since the Hibernate example works I would have to conclude that the problem is MySQL related somehow.

      The working example as a jsp file

      <%@ page contentType="text/html; charset=UTF-8"%>
      <%@ taglib uri="/WEB-INF/iscTaglib.xml" prefix="isomorphic" %>
      <HTML><HEAD><TITLE>dmTest</TITLE>
      <isomorphic:loadISC skin="Enterprise" includeModules="Drawing,Analytics,DocViewer,VisualBuilder"/>
      </HEAD><BODY>
      <SCRIPT>
      isc.Page.setAppImgDir("../graphics/");
      <isomorphic:XML>

      <DataSource loadParents="true">
      <loadID>countryds</loadID>
      </DataSource>
      </isomorphic:XML></SCRIPT>

      <SCRIPT type="text/javascript" language="JavaScript">

      isc.ValuesManager.create({
      ID:"countrySample",
      dataSource:"countryds"
      });

      isc.DynamicForm.create({
      ID:"DynamicForm1",
      autoDraw:false,
      valuesManager:"countrySample",
      dataSource:"countryds",
      canEdit:true,
      saveOnEnter:true,
      fields:[
      {
      name:"PK",
      _constructor:"TextItem"
      },
      {
      name:"COUNTRYCODE",
      _constructor:"TextItem"
      },
      {
      name:"COUNTRYNAME",
      _constructor:"TextItem"
      },
      {
      name:"CAPITAL",
      _constructor:"TextItem"
      },
      {
      name:"GOVERNMENT",
      _constructor:"TextAreaItem"
      }
      ]
      })

      isc.DynamicForm.create({
      ID:"DynamicForm0",
      autoDraw:false,
      valuesManager:"countrySample",
      canEdit:true,
      saveOnEnter:true,
      dataSource:"countryds",
      fields:[
      {
      name:"PK",
      _constructor:"TextItem"
      },
      {
      name:"MEMBER_G8",
      _constructor:"TextItem"
      },
      {
      name:"CONTINENT",
      _constructor:"TextItem"
      },
      {
      name:"INDEPENDENCE",
      _constructor:"DateItem"
      },
      {
      name:"AREA",
      _constructor:"FloatItem"
      },
      {
      name:"POPULATION",
      _constructor:"TextItem"
      },
      {
      name:"GDP",
      _constructor:"FloatItem"
      },
      {
      name:"ARTICLE",
      _constructor:"TextItem"
      }
      ]
      })

      isc.DataView.create({
      ID:"DataView0",
      autoDraw:true,
      height:"100%",
      overflow:"hidden",
      width:"100%",
      members:[
      DynamicForm1,
      DynamicForm0
      ],
      minMemberSize:"18"
      })

      isc.Button.create({
      ID:"dmSaveButton",
      title:"dmSave",
      click: function() {countrySample.saveData()}
      })

      countrySample.fetchData({PK:1});

      </SCRIPT>

      </BODY></HTML>


      I'll skip the ds.xml file for now on this one. I just generated a datasource in visual builder for the builtin country table used in the samples and as mentioned everything seems to work in the example.

      The non-working example as a jsp file:


      <%@ page contentType="text/html; charset=UTF-8"%>
      <%@ taglib uri="/WEB-INF/iscTaglib.xml" prefix="isomorphic" %>
      <HTML><HEAD><TITLE>dmTest</TITLE>
      <isomorphic:loadISC skin="Enterprise" includeModules="Drawing,Analytics,DocViewer,VisualBuilder"/>
      </HEAD><BODY>
      <SCRIPT>
      isc.Page.setAppImgDir("../graphics/");
      <isomorphic:XML>

      <DataSource loadParents="true">
      <loadID>peopleTest</loadID>
      </DataSource>
      </isomorphic:XML></SCRIPT>

      <SCRIPT type="text/javascript" language="JavaScript">

      isc.ValuesManager.create({
      ID:"peopleSample",
      dataSource:"people"
      });

      isc.DynamicForm.create({
      ID:"DynamicForm1",
      autoDraw:false,
      valuesManager:"peopleSample",
      dataSource:"people",
      canEdit:true,
      saveOnEnter:true,
      fields:[
      {
      name:"gender",
      title:"Gender",
      _constructor:"TextItem"
      },
      {
      name:"directoryType",
      title:"Group",
      valueMap:[
      "All",
      "01-Faculty",
      "02-Auxiliary Faculty",
      "03-Office, Shop & Teaching Staff",
      "04-Research Staff & Postdocs",
      "05-Graduate Students",
      "06-E-mail Lists",
      "07-Miscellaneous",
      "08-Student Help",
      "09-Teaching Assistants"
      ],
      _constructor:"FormItem"
      },
      {
      name:"directoryTitle1",
      title:"Title1",
      _constructor:"TextItem"
      },
      {
      name:"directoryTitle2",
      title:"Title2",
      _constructor:"TextItem"
      },
      {
      name:"directoryTitle3",
      title:"Title3",
      _constructor:"TextItem"
      },
      {
      name:"emailAddress",
      title:"Email Address",
      _constructor:"TextItem"
      }
      ]
      })

      isc.DynamicForm.create({
      ID:"DynamicForm0",
      autoDraw:false,
      valuesManager:"peopleSample",
      canEdit:true,
      saveOnEnter:true,
      dataSource:"people",
      fields:[
      {
      name:"nameLast",
      title:"Last",
      _constructor:"TextItem"
      },
      {
      name:"nameFirst",
      title:"First",
      _constructor:"TextItem"
      },
      {
      name:"nameMiddle",
      title:"Middle",
      _constructor:"TextItem"
      },
      {
      name:"namePreferred",
      title:"Preferred",
      _constructor:"TextItem"
      },
      {
      name:"nameInitials",
      title:"Initials",
      _constructor:"TextItem"
      }
      ]
      })


      isc.DataView.create({
      ID:"DataView0",
      autoDraw:true,
      height:"100%",
      overflow:"hidden",
      width:"100%",
      members:[
      DynamicForm1,
      DynamicForm0
      ],
      minMemberSize:"18"
      })

      isc.Button.create({
      ID:"dmSaveButton",
      title:"dmSave",
      click: function() {peopleSample.saveData()}
      })

      peopleSample.fetchData({id_People:10063});

      </SCRIPT>
      </BODY></HTML>

      I'm using: mysql-connector-java-5.1.35-bin.jar for the mysql odbc driver it seems to work in all the other areas of my application.


      I get the same failure either with the following cleaned up version of the people data source, or with a freshly generated datasource from visual builder:

      <DataSource ID="people" dataFormat="iscServer" serverType="sql" dataSourceVersion="1" dbName="personnel" tableName="people" quoteTableName="false" tableCode="12a032ce9179c32a6c7ab397b9d871fa" allowAdvancedCriteria="true" generatedBy="v11.0p_2017-05-15/PowerEdition Deployment 2017-05-15">
      <fields >
      <field name="id_People" type="sequence" title="5-digit unique ID number" primaryKey="true" columnCode="b80bb7740288fda1f201890375a60c8f" >
      <validators>
      <Validator>
      <type>isInteger</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="creationName" type="creator" length="30" title="Username at creation" columnCode="e42c0aa75dbb35ad2830509e06adb3ad" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="creationTimestamp" type="creatorTimestamp" title="Date/time at creation" columnCode="4f61ac2b5fa45842b5f63e744658ced7" >
      <validators>
      <Validator>
      <type>isDate</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="modificationName" type="modifier" length="30" title="Username at last modification" columnCode="2d04811245bab95ecd83512debbe645d" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="modificationTimestamp" type="modifierTimestamp" title="Date/time at last modification" columnCode="d47dcb3d1813a63b358e2483c6fab435" >
      <validators>
      <Validator>
      <type>isDate</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="nameLast" type="text" length="40" title="Last name" columnCode="1b4eddfd113273c5daf1bc74e50a5cc8" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="nameFirst" type="text" length="40" title="First name" columnCode="e2af3968e57cc418dc3356831a570c70" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="nameMiddle" type="text" length="40" title="Middle name or initial" columnCode="9d783fc820471aca06f7f26aa68cd363" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="namePreferred" type="text" length="40" title="Preferred first name" columnCode="4ddd5cd155a7611bd270fa46ace5a649" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="nameInitials" type="text" length="4" title="Initials - Used mainly for PIs" columnCode="52168b1712bec4032e33fcf105964d4b" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="spouseName" type="text" length="40" title="Spouse name - Was used for faculty - probably not necessary" columnCode="3004265049b288debfe099dfda9ba828" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="startDate" type="date" title="Start date with department - Default to earliest date in HRS" columnCode="4e30b6d6aa33492da947b4c6ab31c7ca" >
      <validators>
      <Validator>
      <type>isDate</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="startDateOverride" type="integer" title="1 to override HRS start date" columnCode="1fc9ce688d5ed8adad43f0c6f5fe3c9f" >
      <validators>
      <Validator>
      <type>isInteger</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="endDate" type="date" title="End date with department - Default to latest end date in HRS - NULL if still in department" columnCode="e0a186d8a0d8f936632fd1bf39991398" >
      <validators>
      <Validator>
      <type>isDate</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="endDateOverride" type="integer" title="1 to override HRS end date" columnCode="158d258010aed8b837ee6e16089fc47a" >
      <validators>
      <Validator>
      <type>isInteger</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="dateOfBirth" type="date" title="Date of birth" columnCode="0d155167f498c4d66bbfedda7c17bedc" >
      <validators>
      <Validator>
      <type>isDate</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="gender" type="text" length="1" title="Gender (M/F)" columnCode="cc90f1913b83d255b95be0e0fea6d576" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="hrsPersonID" type="text" length="8" title="Person ID in HRS" columnCode="63e57407f6ef6cc5622ce4dae01295f4" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      <Validator>
      <type>isUnique</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="uwPVI" type="text" length="9" title="Publicly Visible Identifier" columnCode="5ec28c133fdd720ac4812f05a9815746" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      <Validator>
      <type>isUnique</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="isisEmplID" type="text" length="10" title="Empl ID in ISIS" columnCode="20db8c61285e08ebc257727723382078" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="isisCampusID" type="text" length="10" title="Campus ID in ISIS" columnCode="14d7f3e657edbd70773654759c5a4061" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="uwPhotoID" type="text" length="11" title="WiscCard ID" columnCode="8526e8a3b9e6b1e6531ac03224e42dba" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="uwNetID" type="text" length="20" title="UW-Madison netid" columnCode="afb5c4c1cd02d30e3891b0834a44c2cc" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="caeUserName" type="text" length="20" title="CAE username" columnCode="dea2075512c72c54c0b92fc04179e64f" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="payrollNotes" type="text" length="65535" title="Freeform notes regarding employment" columnCode="f9aaa572e7572e5ec64a37327cab77b0" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="isActive" type="boolean" title="1 if active in department" columnCode="445e6b938b0faf72dadef09820420a37" >
      <validators>
      <Validator>
      <type>isBoolean</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="includeInDirectory" type="boolean" sqlStorageStrategy="integer" title="1 to include in printed directory" columnCode="2b44213ac9304d275296fe865a2d2248" >
      <validators>
      <Validator>
      <type>isBoolean</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="isGroupPI" type="boolean" sqlStorageStrategy="integer" title="1 if person is a PI" columnCode="88bfca23245f78fc1a67d103a51aba1d" >
      <validators>
      <Validator>
      <type>isBoolean</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="directoryType" type="text" length="40" title="Person type (faculty, staff, grad, etc.)" columnCode="58a10c6386a4126abf8dac2bccde2ea2" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      <defaultErrorMessage>"Choose a Person Type"</defaultErrorMessage>
      </Validator>
      </validators>
      </field>
      <field name="directoryTitle1" type="text" length="40" title="Primary title" columnCode="c44a12a5a7ca51493644109e6bb86606" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="directoryTitle2" type="text" length="40" title="Secondary title (if any)" columnCode="08933b7b649f24133772b4e09fc02b9d" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="directoryTitle3" type="text" length="40" title="Tertiary title (if any)" columnCode="d0f6331341b1ea67daac1b09a63b0ee5" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="personalCode" type="text" length="4" title="Unique 4-digit code - basis for copier code" columnCode="4735e95d740cfa05cba801dc7e30048b" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      <Validator>
      <type>isUnique</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emailAddress" type="text" length="40" title="Primary email address" columnCode="cc4e2bfd157f839a82896454a5feb80d" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="homeStreet" type="text" length="40" title="Local address - Street address" columnCode="0352896ae255fb386c024385212ab15e" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="homeCity" type="text" length="40" title="Local address - City" columnCode="e4d2da46163b0a407a0eb0e8f0ead09d" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="homeState" type="text" length="10" title="Local address - State" columnCode="36b186add41971c6a871120083626036" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="homeZipCode" type="text" length="10" title="Local address - Zip Code" columnCode="359418349abec7a6118c44dcb1d8ccf1" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="homePhone" type="text" length="20" title="Local phone number" columnCode="0ee82c3db32f042b9c93f3e247bdc442" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="homeAddressOmit" type="integer" title="1 to omit home address from public directory" columnCode="5a45d98b525b56f2f4d7f6a7a9598a52" >
      <validators>
      <Validator>
      <type>isInteger</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactName" type="text" length="40" title="Emergency contact - Name" columnCode="dc2ca15a2e5c0232e9b755bd9e89b189" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactAddress1" type="text" length="40" title="Emergency contact - Address 1" columnCode="3d5d071846f0ae4604e3fb8bb8afe227" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactAddress2" type="text" length="40" title="Emergency contact - Address 2" columnCode="b5dbc76ac7c13464c8e2c407435c7596" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactCity" type="text" length="40" title="Emergency contact - City" columnCode="206826831bec979036927a233c575625" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactState" type="text" length="10" title="Emergency contact - State" columnCode="89b4e608719295a9354b268711c1c272" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactPostalCode" type="text" length="10" title="Emergency contact - Postal code" columnCode="45b4099d23fe6661012c7debd5a9bd0e" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactCountry" type="text" length="20" title="Emergency contact - Country" columnCode="9af9047938d29f3799d34500d49d4387" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="emergencyContactPhone" type="text" length="20" title="Emergency contact - Phone" columnCode="b1fe864219ce53352f2eeed55e20b58d" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingName" type="text" length="40" title="Forwarding information - no longer with department" columnCode="c2eedf8d93151cb05fde834a3d54121f" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingAddress1" type="text" length="40" title="Forwarding address - Address 1" columnCode="1b1f1453c06aa226e8cdd9759aaacb55" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingAddress2" type="text" length="40" title="Forwarding address - Address 2" columnCode="b6db2655f50ffdb08a6ef260be78dc5e" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingCity" type="text" length="40" title="Forwarding address - City" columnCode="8045ea0337d94e859560826c9c5568b9" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingState" type="text" length="10" title="Forwarding address - State" columnCode="21d623f16753924d98a92b59e060628b" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingPostalCode" type="text" length="10" title="Forwarding address - Postal Code" columnCode="0bec0a13ac070fb4d9a52295ef8ca417" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingCountry" type="text" length="20" title="Forwarding address - Country" columnCode="7ba92dc118012e1fa5b73e3d6835e885" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingPhone" type="text" length="20" title="Forwarding phone number" columnCode="c70957d94d0bb38f0c50858f2b325389" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingModificationDate" type="date" title="Forwarding information last modification date" columnCode="34994e47aea07f59936eb954cb0c34e5" >
      <validators>
      <Validator>
      <type>isDate</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="forwardingModificationName" type="text" length="20" title="Forwarding information last modification username" columnCode="f572a8f3b129b0f29bbcf4d3c6728713" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="personNotes" type="text" length="65535" title="Free-form notes" columnCode="9bf3b7d974ce8182f352c3460fadf876" >
      <validators>
      <Validator>
      <type>isString</type>
      <stopIfFalse>true</stopIfFalse>
      </Validator>
      </validators>
      </field>
      <field name="lastFirst" type="text" length="82" title="Last, First" >
      <customSelectExpression>concat(people.nameLast,', ',people.nameFirst)</customSelectExpression>
      </field>
      </fields>
      <operationBindings>
      <!--
      <operationBinding operationType="fetch" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelViewers"></operationBinding>
      <operationBinding operationType="add" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelEditAll"></operationBinding>
      <operationBinding operationType="update" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelEditAll"></operationBinding>
      <operationBinding operationType="remove" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelEditAll"></operationBinding>
      -->
      <operationBinding operationType="fetch" operationId="directoryTypes" requiresAuthentication="true" requiresRole="uw:org:cbe:personnelViewers">
      <groupBy>directoryType</groupBy>
      </operationBinding>
      </operationBindings>
      <sequenceMode>jdbcDriver</sequenceMode>
      </DataSource>


      Comment

        #4
        Server-side DataSource type cannot influence client-side behavior, so, you should actually be looking for a subtle client-side issue. First thing to do (every time) is check the Developer Console for errors and warnings.

        Also, the DataSource is posted is still full of the same redundant and invalid definitions we noted before.

        Do let us know if you find clear evidence of a bug in the framework.

        Comment

          #5
          Using the developer console helped. The problem was validation errors with several boolean fields that are stored as tinyints in mysql. With those corrected saves now work.

          Thank you.

          Comment

          Previous template Next
          Working...
          X