Question

Lobby display object not showing data App9.17


Badge +4

I am creating a Lobby element for end users but it is not behaving.

I have created a data element based on an IAL and I can preview it and I get data results as expected. When I try ro select Columns though, I have to manually type the names. They do not appear in the drop down to select, but manually typing does work

When I try to use the data elemend in a List display object, it refuses to show data. I just get a green cross and no data.
The user has access to the data. 

I have tried creating an IAL and a quick information and a view direct into the IFSAPP schema but the Display element still will not show any data and none of the methods will let me choose the field names from the Colums sectio.

Does anyone have an idea why Element willnot display results


7 replies

Userlevel 7
Badge +22

Dear @RogerB 

did you check the permission set?

You must grant the IAL in the permission set.

Do you use IFSINFO to access the IAL? → ifsinfo.your_IAL

Badge +4

Thanks for the reply.
Yes, the IAL is in the IFSINFO schema and is owned by the IFSINFO user.

The user I am testing with, has access to the data normally, just the Lobby element still refuses to give results
If I connect to the database as the test user, I can run SQL to select from the IAL and I get results, just not from the lobby.
 

Userlevel 7
Badge +22

Do you use any parameters?

Maybe you can post here your datasource with the IAL?

Badge +4

The IAL code is:-

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "IFSINFO"."PD_MY_SUPPLIER_INVOICES" ("INVOICE_NO", "USERID", "COMPANY", "IDENTITY", "PO_REF_NUMBER") AS 
  SELECT invoice_no, userid, company, identity, PO_REF_NUMBER
FROM IFSINFO.PD_MY_SUPPLIER_INVOICES_IAL;


  GRANT SELECT ON "IFSINFO"."PD_MY_SUPPLIER_INVOICES" TO "MCRO01";
  GRANT SELECT ON "IFSINFO"."PD_MY_SUPPLIER_INVOICES" TO "PD-PROC-ORDERS";
  GRANT SELECT ON "IFSINFO"."PD_MY_SUPPLIER_INVOICES" TO "IFSAPP" WITH GRANT OPTION;
  GRANT SELECT ON "IFSINFO"."PD_MY_SUPPLIER_INVOICES" TO "IFSSYS";

As an IAL/view, it works perfectly. Call it in SQL and the test user and I get one line returned

Data Element returns the one line
Display element just shows the cross

Can you spot what I have done wrong or is this just Lobby being a pain?

Thanks

Userlevel 7
Badge +22

Hi @RogerB 

can you move your cursor over the cross?

It shuld show you the error message.

 

Userlevel 7
Badge +22

Also check here if your IAL is granted to your permission set:

 

Badge +4

I didn’t know about the error message. Thanks for that tip.
 

It used to be in the permission set, but it’s no longer even showing up

I guess I broke than when trying all the variations.
Ok, I deleted the IAL and have recreated and it now shows and is enabled in the main permission set
 

Data Designer still returns lots of data, fairly quickly.
Display element takes a lot longer but still returns the cross with the above timed out error. For a short time it did show column names and no cross, but then it went back to the cross

At this stage it should return ALL the records as I have not filterered to the user yet.

How would I select only records for the logged on user. We were told to use USERID = ‘#PERSONID#’ where USERID is a field in the IAL, but I am beginning to doubt that as well..

Reply