Shawn A

    Shawn A

    3 years ago
    I am using an
    alias
    to create a sub-query and then using that sub-query in a join. It looks like once you use an
    alias
    you can no longer reference the columns in the
    ResultRow
    by the original table's columns. Keys in the
    ResultRow
    from the alias look like
    org.jetbrains.exposed.sql.Alias.name
    . Is there any way to avoid this? I have common mapping code that assumes it can use the table class to reference columns. e.g (
    DataSourceTable.name
    ).
    tapac

    tapac

    3 years ago
    You may avoid using alias and join just with a query. Otherwise you have to use alias instance to get values from a ResultRow
    Shawn A

    Shawn A

    3 years ago
    @tapac Ok, thanks. I was having an issue creating a join with a sub-query without an alias. The query is something like
    select * from (sub-query) join other-table on ...