Skip to main content
Solved

navigate to window in lobby for element which is based on IAL-data-source

  • January 16, 2021
  • 7 replies
  • 501 views

Forum|alt.badge.img+7

 

Hi all,

I have my data source based on an IAL. As I learned the where-statement should be made in the data source when I want to navigate form the element to a window:

 

My element looks like this:

 

 

But clicking on the element within the lobby does not show the data:

 

 

 

Any tipps and tricks how to solve that?

 

Thanks a lot for your input!

 

Mattis

Best answer by samuelandlopes

IFSmattis wrote:

 

Hi all,

I have my data source based on an IAL. As I learned the where-statement should be made in the data source when I want to navigate form the element to a window:

 

My element looks like this:

 

 

But clicking on the element within the lobby does not show the data:

 

 

 

Any tipps and tricks how to solve that?

 

Thanks a lot for your input!

 

Mattis

Hi,

I do like this and works well for me.

You can already count in the column

Hope it helps You.

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

7 replies

  • Superhero (Employee)
  • 1426 replies
  • January 17, 2021
IFSmattis wrote:

 

Hi all,

I have my data source based on an IAL. As I learned the where-statement should be made in the data source when I want to navigate form the element to a window:

 

My element looks like this:

 

 

But clicking on the element within the lobby does not show the data:

 

 

 

Any tipps and tricks how to solve that?

 

Thanks a lot for your input!

 

Mattis

What does your IAL look like? You need the project IDs in your IAL to navigate to the page showing the related projects.
Instead of doing the count in the IAL, setup your IAL to include all rows that you want to count and then in the lobby data source, set the columns to be project_id and count(xyz) (group by project id). 


Forum|alt.badge.img+7
  • Author
  • Sidekick
  • 19 replies
  • January 25, 2021

Thanks, anmise!

The IAL: 

My updated data-source:

 

 

 

My lobby element: 

 

 

What am I missing? Any ideas?

Thanks a lot in advance!


  • Superhero (Employee)
  • 1426 replies
  • January 25, 2021
IFSmattis wrote:

Thanks, anmise!

The IAL: 

My updated data-source:

 

 

 

My lobby element: 

 

 

What am I missing? Any ideas?

Thanks a lot in advance!

Can you set the column to your count i.e. countactivity_seq and the aggregate to None? 

 

 


Forum|alt.badge.img+7
  • Author
  • Sidekick
  • 19 replies
  • January 30, 2021

@anmise : thanks for your input! I still get a result for the element, but the navigation still does not work. I have the feeling with this setup it is not working or do we have any other options?

 


  • Superhero (Employee)
  • 1426 replies
  • January 30, 2021
IFSmattis wrote:

@anmise : thanks for your input! I still get a result for the element, but the navigation still does not work. I have the feeling with this setup it is not working or do we have any other options?

 

I’m have a vague memory that navigation might not work with IALs and counters. Can you do a list element instead? Or can you maybe use the project_base view with an exists condition e.g. exists (select 1 from ifsapp.activity_ext_without_access act where   project_base.project_id=act.project_id and act.description=’END OF WARRANTY’)


EntNadeeL
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • 181 replies
  • February 2, 2021

Hi @IFSmattis ,

As I understand, it’s better to go with a list element since it gives you to map IAL column outputs to the view you are navigating. 

Because condition doesn't work unless the page you are navigating to is based on that view (In this case it is an IAL).

Or if you could tell me what you expect to do using this element then I could suggest some other solution depending on your requirement.

Thanks,

Kind Regards,


samuelandlopes
Hero (Former Employee)
Forum|alt.badge.img+10
  • Hero (Former Employee)
  • 75 replies
  • Answer
  • April 27, 2021
IFSmattis wrote:

 

Hi all,

I have my data source based on an IAL. As I learned the where-statement should be made in the data source when I want to navigate form the element to a window:

 

My element looks like this:

 

 

But clicking on the element within the lobby does not show the data:

 

 

 

Any tipps and tricks how to solve that?

 

Thanks a lot for your input!

 

Mattis

Hi,

I do like this and works well for me.

You can already count in the column

Hope it helps You.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings