Solved

Lobby Data source view table alias

  • 7 September 2021
  • 6 replies
  • 514 views
Ozgun BAL
Rank
Userlevel 4
Badge +8

Hello all,

I am trying to save my lobby data source but i have and error when I hit the save button like “Please enter a one view name”

 

But I can preview my query and it works fine.

What i need to to is just save may data source but i can’t.

Any hep would be appreciated.

 

icon

Best answer by Tomas Ruderfelt 8 September 2021, 10:48

View original
This topic has been closed for comments

6 replies

william.klotz
Rank
Userlevel 7
Badge +21

Hi @Ozgun BAL ,

 

I believe if you remove the b from the field where you’ve entered the view name and change your inline query to include the b after the view name you’ll be able to successful save your data source.   

 

Regards,

William Klotz

Ozgun BAL
Rank
Userlevel 4
Badge +8

Hi @Ozgun BAL ,

 

I believe if you remove the b from the field where you’ve entered the view name and change your inline query to include the b after the view name you’ll be able to successful save your data source.   

 

Regards,

William Klotz

Hello @william.klotz  ,

 

Thanks for your answer,

 

If I remove the alias names from the query, result will be incorrect.

I actually need to give a name to the view table. If i dont give an alias,  query result won’t be correct.

 

Isn’t there any way to give an alias name to view table in this situtation?

 

The query preview works fine but IFS doesen’t let me save my lobby data source element.

 

Thanks in advence.

 

Regards 

Ozgun BAL

 

 

servetsc
Rank
Userlevel 2
Badge +5

Hello Ozgun,

Why you need to use Alias? If you query one view and not join two or more views/tables, you dont have to use alias. But if you cant do it you can create a view or an IAL instead. 

Regards.

Servet

Ozgun BAL
Rank
Userlevel 4
Badge +8

Hello Servet, thanks for reply.

 

My aim is to calculate running total value of SUM(AMOUNT) cloumn.

So I added a new column with using subquery which sums running total values.

 

Please inspect following screenshots;

And If I remove alias result is like that;

 

Maybe someone can help me about other ways to calculate the running total value?

My logic to calculate running value of SUM(AMOUNT) may be wrong but query results seems correct.

 

What I only need is to save this data source design but IFS doesen’t allow.

 

Kind Regards

Ozgun BAL

 

 

T
Rank
Userlevel 7
Badge +19

Here is an example of how you can change a part of your sub-select:

FROM &AO.TRREP_SATIS_ANALIZ b WHERE b.PERIOD2 <= TRREP_SATIS_ANALIZ.PERIOD2

 

Or you could try to replace the sub-select with:

SUM(amount) OVER(ORDER BY period2 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

 

Ozgun BAL
Rank
Userlevel 4
Badge +8

Here is an example of how you can change a part of your sub-select:

FROM &AO.TRREP_SATIS_ANALIZ b WHERE b.PERIOD2 <= TRREP_SATIS_ANALIZ.PERIOD2

 

Or you could try to replace the sub-select with:

SUM(amount) OVER(ORDER BY period2 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

 

Hello @Tomas Ruderfelt ,

Thanks for your help!

First option solved my problem.

It helped a lot and I learnt something, thanks for that.

 

Kind Regards

Ozgun BAL

Terms & ConditionsCookie settings