Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

  • Blama
    replied
    Hi Isomorphic,

    why am I getting the tablecode / columncode in the result anyway?
    I never use autoDeriveSchema in my .ds.xml (v9.1p_2014-08-11, Oracle database).
    I don't think I need them and they increase the uncompressed size of the result from 230kb to 280kb.

    Is there some setting that enables autoDeriveSchema by default?

    Best regards,
    Blama

    Leave a comment:


  • Blama
    replied
    Hi aprajita,

    it can and it does automatically. Please see this result for one DS of my call to /DataSourceLoader?dataSource=... (in recent 4.1p).

    Code:
    [U]isc.DataSource.create({
        allowAdvancedCriteria:true,
        operationBindings:[
            {
                operationType:"update"
            },
            {
                operationType:"add"
            },
            {
                operationType:"remove"
            }
        ],
        serverType:"sql",
        tableCode:"660e6a52e29a8fc1a48d84c7fa2ee3e2",
        ID:"MY_ID_FROM_THE_DS_XML",
        fields:[
            {
                hidden:true,
                columnCode:"3854361464b9a2c3832c47bd39cddf54",
                name:"TENANT_ID",
                type:"integer"
            },
            {
                hidden:true,
                columnCode:"8f635513ba0e5d43d77836ba57c23dad",
                name:"LEAD_ID",
                type:"integer"
            },
            {
                title:"Reseller",
                displayField:"RESELLER_NAME",
                columnCode:"753f5ffa2e1542d0f28d4eb4bcab25e8",
                name:"RESELLER_ID",
                type:"integer"
            },
            {
                hidden:true,
                columnCode:"2582ec59e97c6010032089b939c5ba6b",
                name:"RESELLER_NAME",
                length:30,
                escapeHTML:true,
                type:"text"
            },
            {
                columnCode:"a74ec9c5b6882f79e32a8fbd8da90c1b",
                name:"DISTANCE",
                type:"float"
            }
        ]
    })
    If you don't name Datasource ID the same as the database table, the client will never know the table name. Same for the fieldname/columnname.
    See docs/serverds/DataSource.tableCode.

    @Isomorphic: There is no docs/serverds/DataSourceField.columnCode in the docs, while it is clearly used.

    Best regards,
    Blama

    Leave a comment:

Working...
X