Solved

Lobby Data Source using table alias

  • 12 October 2022
  • 3 replies
  • 120 views

Userlevel 4
Badge +9

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

icon

Best answer by Link 12 October 2022, 15:38

View original

3 replies

Userlevel 7
Badge +22

Hi @mlcscottonn 

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

Userlevel 7
Badge +22

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

For example: ifsapp.Subval_Valuation.valuation_no

Userlevel 4
Badge +9

Thank you :)

Reply