Compass Data Lake Query infor.* functions fail

InforNewBee

Hi all, I'm writing some data lake queries and some infor.* functions I can use and others I can't. Below is a query I'm running and the different results I get.

What are the 624 messages about (I found info about this message, but it was too generic)?

I can use _Action but I can't use _isCurrent? Are there special security settings down to the function level?

What's the differene between _isCurrent and infor.isCurrent()?

Thanks for any help in advance!

SELECT
Employee, -- and add one of the fields below gives different messages
infor.Created() -- Returns: INTERNAL ERROR 624 Error message: An internal error occurred.
infor.lastModified() -- Works.
infor.isCurrent() -- Returns: INTERNAL ERROR 624 Error message: An internal error occurred.
infor._isDeleted() -- Returns: INTERNAL ERROR 624 Error message: An internal error occurred.
infor.dataobjectid() -- Works.
infor.dataobjectseqid() -- Works.
_Action -- Works.
_isCurrent -- Process ERROR 401 Error message: Invalid property name reference(s) or you do not have permissions: 'HCM_EMPLOYEE._isCurrent'.
CreateStamp -- Works.
UpdateStamp -- Works.
FROM
HCM_EMPLOYEE
WHERE
EMPLOYEE = 123456

Kevin Heiman

Those do not look like Compass query functions. Check out the Compass SQL Reference section in documentation. and section on Infor functionality . You can also see/prompt these in the Compass editor in Data Fabric. Alway provide table name if more than one table is in scope.
Examples of some including archive

infor.compasstimestamp()
infor.allvariations()
infor.includedeleted()

infor.ShowArchived()