Need LiveReport that will work on Oracle

[markorjj]

I used the following LiveReport on SQL Server without fail to produce a listing of users who have had their login disabled:

select userprivileges, * from kuaf
where deleted in (0,1) and
floor(kuaf.userprivileges / Power (2, 0)) %2 = 0

Unfortuanately, I am now on Oracle, and the LiveReport fails with the following error:

Livelink Error: Error processing request.
[ORA-00936: missing expression - select userprivileges, * from kuaf where deleted in (0,1 ) and floor(kuaf.userprivileges / Power (2, 0)) ? = 0]

Any suggestions as to what needs to change?

 

[appnair]

Here is a query generic for oracle that I used to use

select a.name,a.id,a.userprivileges,a.type,a.deleted,
decode(bitand(a.userprivileges,15),15,'Login')"Login",
decode(bitand(a.userprivileges,2062),2062,'Public Access')"Public Access",
decode(bitand(a.userprivileges,46),46,'CCMU')"CCMU",
decode(bitand(a.userprivileges,78),78,'CCMG')"CCMG",
decode(bitand(a.userprivileges,30),30,'UA')"UA",
decode(bitand(a.userprivileges,270),270,'SA')"SA"
from kuaf a where a.type=0 and a.deleted=0

No Privs 14
Login 15
Public Access 2062
CCMU 46
CCMG 78
UA 30
SA 270

See if that helps

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer and probably certfiable,Livelink ECM Champion 2008

http://www.linkedin.com/in/appunair

 

[markorjj]

Thanks - worked like a charm!