Skip to main content
Solved

Lobby Data Source using table alias

  • October 12, 2022
  • 3 replies
  • 202 views

Forum|alt.badge.img+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

Best answer by Link

Hi @mlcscottonn 

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

3 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • Answer
  • October 12, 2022

Hi @mlcscottonn 

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


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • October 12, 2022

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

For example: ifsapp.Subval_Valuation.valuation_no


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 30 replies
  • October 12, 2022

Thank you :)