Announcement

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

    include all fields from a related datasource: is it possible?

    I've got two datasources A and B with a foreign key relationship between them, say that dataSource B contains:
    Code:
    <field name="fk" foreignKey="A.id" joinType="outer"/>
    So in dataSource B I can include fields from dataSource A:
    Code:
    <field name="includedField" includeFrom="A.field1" includeVia="fk"/>
    given that I need to include many (actually all) fields of dataSource A, is there a way to include them all, based on the fk relationship?

    the documentation for DataSource.inheritsFrom says:
    Code:
    ...
    This feature can be used for:
    ...
    - modeling relational database joins, and the equivalents in other systems
    so at first I thought I could use it, but it doesn't works this way.

    #2
    Another question about DataSourceField.includeFrom: I noticed that it excludes customSQL, so if I mark as customSQL="true" a field with includeFrom="...", it is included anyway.
    Is it a bug or intended behavior?
    Tested with:
    SmartClient Version: v9.1p_2014-06-04/PowerEdition Deployment (built 2014-06-04)

    Comment

    Working...
    X