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

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

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

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