Custom package API procedure usage in IAL

Hi ​@MMcK,

Even in IFS Cloud version you have to use &AO.. prefix when using any object in IFSAPP schema in the IAL view.

Can you login to the DB as IFSINFO user and try to execute the same IAL view and see whether it returns data?
How about using the IAL in “live data” mode? Does that work for you?

BR,

Subash   

Hi Subash

Many thanks for your reply.  We got round the problem using more complex SQL to replace the custom API calls.

TBH, I’m not sure how I can log in to the DB as IFSINFO.  We don’t have a documented password and there’s no option to set it in IFS.

Best regards,

MMcK

​@MMcK the IFSINFO password should be in your ifscloud-values.yaml
Custom values yaml example - Technical Documentation For IFS Cloud

The other issue outside of ​@subashfestus suggestion of using `&AO..` and `&IAL..`

could have been access issue for IFSINFO

Row Level Security can cause it not to have access to views. If that is a requirement, you can add IFSINFO to the company and site.

This is because all views use `...WHERE EXISTS (SELECT 1 FROM user_allowed_site_pub...`