customSelectExpression and tableAlias

[antipich]

I have ds like

<DataSource
schema="public"
serverType="sql"
dbName="DemoDatabase"
ID="test"
tableName="test"
>
<fields>
      <field name="id" type="integer" hidden="true" primaryKey="true"></field>
      <field name="f" type="integer" hidden="true"></field>
      <field name="name" customSelectExpression="case when f = 1 then 5 else 6 end" length="2147483647" type="text"></field>
</fields>
</DataSource>

And i want to use this DS in other DS with fields:

<field name="test1_id" foreignKey="test.id"></field>
<field name="test2_id" foreignKey="test.id"></field>
<field name="test1_name" includeFrom="test.name" includeVia="test1_id"></field>
<field name="test2_name" includeFrom="test.name" includeVia="test2_id"></field>

But then SQL is incorrect, i must to add table alias to customSelectExpression, like "case when t1.f = 1 then 5 else 6 end" How I can now table alias in customSelectExpression with velocity? I try to use
${dataSources.test.getTableName()} but it give me real table name 'test', not it alias in query. How I can do this? Thanks

[Blama]

See relatedTableAlias for a developer defined constant table alias. Define it on fields with foreignKey.

Best regards
Blama

[antipich]

It won't help
I can set relatedTableAlias in both fields test1_id and test2_id, but customSelectExpression in other DS, and it can't now alias. I don't want to add same customSelectExpression in second DS.
I see https://forums.smartclient.com/forum...blename-needed with same problem
But ${dataSources.test.getTableName()} returns me real table name, not it's alias.

[Blama]

Adding the customSelectExpression twice like you suggested in #3 will solve the issue and is a good workaround IMHO.
I'm the OP in the other thread, but did not test the new API, as I'm still on 11.1.

Best regards
Blama

[antipich]

Admins? What about new API?

[antipich]

up