Hi @WyrAndreM ,

Does the &IAL.WYR_CLOCKED_IN_REP view has any column with a name similar to the alias used in data source?

If so, please make sure to use a name that does not exist as a column name in the
view. Let us know whether it would work ..
 

Hello @WyrAndreM,

Check if there are any common names have been used for a column in &IAL.WYR_CLOCKED_IN_REP view and the alias that is used in data source. If so, please change the names.

Cheers!

Thank you for the replies I have swapped out the alias to be something that would not be used as per normal for a reference and refreshed Aurena cache but still have the same issue e.g. 

What user account are you using, IFSAPP?

@WyrAndreM 

I guess, if you just use company_id and emp_no only in data source, you will be able to see the element in Aurena? Did you give such a try?

Using my own account as opposed to IFSAPP and the code for the IAL is as follows - 

“

CREATE OR REPLACE VIEW &IAL_OWNER..&OBJECT._IAL AS
 SELECT distinct company_id,emp_no
         FROM   &AO..time_pers_diary_clocking_tab
         WHERE account_date BETWEEN TRUNC(sysdate + (NVL(1, 0) / 24) ) -1 AND TRUNC(sysdate + (NVL(1, 0) / 24) ) +1
         AND    proc_status   != 'B'
         AND    in_pers_class != 'F'
         AND    in_stamp BETWEEN (sysdate + (NVL(1, 0) / 24) ) -0.75 AND (sysdate + (NVL(1, 0) / 24) )
         AND    NVL(out_stamp, (sysdate + (NVL(1, 0) / 24) ) +1) > (sysdate + (NVL(1, 0) / 24) )

“ 

Thanks.

Can you run a select statement over the IAL - using the query tool or something else?

I have created a new datasource element and lobby element with 1 column but still get the same results, I can also view this in the SQL query tool. I have created a new IAL looking at company column from company.

EE Client - 

Aurena Client - 

Thanks.

As you are not using the IFSAPP account. It might be worth checking the permission set access (thats assigned to your account) for this Aurena Lobby. The Aurena Lobby has a separate object (from EE) that would need granting. 

@WyrAndreM 

Just give a try to change the &IAL.WYR_CLOCKED_IN_EMP to IFSINFO.WYR_CLOCKED_IN_EMP where you have to give the view name in Data Source Designer.

IAL Object Developer
 

IEE
 

Aurena
 

Hi @WyrAndreM,

Just to be sure on who is the user for the IAL owner, you can go through following and confirm it.. 
 

According to this, it is IFSINFO here.. likewise confirm it and amend the view name.

Thank you, I did try the INFSINFO schema prefix on the Datasource element which didn’t appear to work before i’m not too sure why, I have since retried which has corrected the problem thanks for you help.