Solved

Navigation for lobby element/data source based on IAL

  • 7 April 2020
  • 3 replies
  • 893 views
I
Rank
Userlevel 3
Badge +7

Dear all,

I created a lobby element based on an IAL. 

The navigation from the counter to the target-window does not transfer the result even if I use the option “Use data source condition”. 

Instead the target window is populating all data. For “non-IAL” data sources the target-page gets the right values.

 

Is there a trick how to make that work for IALs?

 

Thanks a lot in advance!

 

Best

Fabian

icon

Best answer by anmise 10 June 2020, 07:56

View original

3 replies

J
Rank
Badge +2

I presume that your WHERE part of query is within the IAL - that should be the reason.

When you use “Use data source condition”, the navigation uses conditions set in data source to filter data in form/table you’re sent to. 

You can try doing your data aggregation within IAL and moving WHERE to data source (shouldn’t be an issue if your IAL is set for ‘Live Data’).

If you were to use different Lobby Elements you can also make use of ‘Column values’:

 

I
Rank
Userlevel 3
Badge +7

Hi Jack,

I made this setup:

IAL:

select 
a.project_id, 
a.order_no, 
a.state,
a.customer_po_no, 
a.CF$_C_CONTRACT_REF, 
a.REGION_CODE, 
a.DELIVERY_TERMS, 
a.PAY_TERM_ID, 
b.vendor_no,
from 
ifsapp.customer_order_cfv a LEFT OUTER JOIN (select * from ifsapp.customer_order_line where line_item_no <> '-1') b
ON a.order_no = b.order_no

 

data source:

lobby element: 

 

But unfortunately it is not working when I click on the lobby element:

 

I assume the problem is the JOIN in the IAL or did I miss something?

 

Perhaps you have an idea.

 

 

Thank you! 

 

Best

Mattis

A
Rank
Userlevel 7

Hi Jack,

I made this setup:

IAL:

select 
a.project_id, 
a.order_no, 
a.state,
a.customer_po_no, 
a.CF$_C_CONTRACT_REF, 
a.REGION_CODE, 
a.DELIVERY_TERMS, 
a.PAY_TERM_ID, 
b.vendor_no,
from 
ifsapp.customer_order_cfv a LEFT OUTER JOIN (select * from ifsapp.customer_order_line where line_item_no <> '-1') b
ON a.order_no = b.order_no

 

data source:

lobby element: 

 

But unfortunately it is not working when I click on the lobby element:

 

I assume the problem is the JOIN in the IAL or did I miss something?

 

Perhaps you have an idea.

 

 

Thank you! 

 

Best

Mattis

Change the target column from distinct(ORDER_NO) to just ORDER_NO, and it should work.

Reply


Terms & ConditionsCookie settings