Lobby Data Source using table alias

Question

I have created an lobby element which shows me which sub contract valuations are certified but not paid. The issue I am having is it will not allow me to add an alias on the view and I am 99% sure you was able to do this.

For example, here is my definition and I want to add the alias ‘a’ so it knows in my select statement to use the sub_con_no and valuation_no from the subval_invoice_details view.

I am using ifs apps 10, update 15.

Thank you

Page 1 / 1

Hi @mlcscottonn

you can use it in sub queries (in the where condition) but not in the view field.

But you can write the table name instead of the alias.

For example: ifsapp.Subval_Valuation.valuation_no

Thank you :)

Reply

Link · Accepted Answer

Hi @mlcscottonnyou can use it in sub queries (in the where condition) but not in the view field.

Link · Answer

But you can write the table name instead of the alias.For example: ifsapp.Subval_Valuation.valuation_no

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded