BAQ epibinding

Kinetic ERP
,
1

Hello everyone,

Is there anyway to pull data into a BAQ when the DB field is not populated, just the EPI Binding? per screenshot

i.e… I want to see all users currently locked out but can’t find this record.field

image

2

Hi Peter,

I believe the table is Ice.UserLogOnStatus, which is not exposed via BAQ. Existence of a record in this table means the user is locked out. This is why it’s not a clickable field but you have to go to the Actions menu item to remove someone from Lock Out.

SELECT [UserID]
      ,[LockedOutOn]
      ,[LastLogOnFailedOn]
      ,[FailedAttempts]
      ,[SysRevID]
      ,[SysRowID]
  FROM [Ice].[UserLogOnStatus]
1 Like