This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
The second version with just 'USER' will definitely not work. Try this:
Select:
select count(*) from sr
Where:
where siteid = (select defsite from maxuser where userid = :USER) and rspriority = 2 and rigsightrecordtype = 'RS'
The value for the priority shouldn't be in quotes.
IE1hbnkgdGhhbmtzIGZvciB0aGUgcmVzcG9uc2UuDQoNCiANCg0KLS0tSW4gTUFYSU1PQHlh
aG9vZ3JvdXBzLmNvbSwgPG1heGltb0B5YWhvb2dyb3Vwcy5jb20+IHdyb3RlOg0KDQogVGhl
IHNlY29uZCB2ZXJzaW9uIHdpdGgganVzdCAnVVNFUicgd2lsbCBkZWZpbml0ZWx5IG5vdCB3
b3JrLiBUcnkgdGhpczoNCiANCiBTZWxlY3Q6DQogc2VsZWN0IGNvdW50KCopIGZyb20gc3IN
CiANCiBXaGVyZToNCiB3aGVyZSBzaXRlaWQgPSAoc2VsZWN0IGRlZnNpdGUgZnJvbSBtYXh1
c2VyIHdoZXJlIHVzZXJpZCA9IDpVU0VSKSBhbmQgcnNwcmlvcml0eSA9IDIgYW5kIHJpZ3Np
Z2h0cmVjb3JkdHlwZSA9ICdSUycNCiANCiBUaGUgdmFsdWUgZm9yIHRoZSBwcmlvcml0eSBz
aG91bGRuJ3QgYmUgaW4gcXVvdGVzLg0KDQo=