project BLF > class BUser > business logic query UsrByIdLoginIsActNameLng
Description
a query that returns all fields
Parameters
| iiUsrId | integer | User ID |
| icUsrLogin | character | User Login |
| ilUsrIsActive | logical | indicates if the user is active or not |
| icUsrName | character | Name of the user |
| iiLngId | integer | Language ID |
query condition
each Usr where
Usr.Usr_ID = iiUsrId AND
Usr.UsrLogin matches icUsrLogin AND
Usr.UsrIsActive = ilUsrIsActive AND
Usr.UsrName matches icUsrName AND
Usr.DefaultLng_ID = iiLngId
first Lng (inner-join) where
Lng.Lng_ID = Usr.DefaultLng_ID AND
query sort order
Usr.Usr_ID (ascending)
query resultset tqUsrByIdLoginIsActNameLng
| field name | data type | db field | description |
|---|
| tcLngCode | character | Lng.LngCode | Language Code |
| tiDefaultLng_ID | integer | Usr.DefaultLng_ID | Default Language |
| tcUsrInitials | character | Usr.UsrInitials | UsrInitials |
| tlUsrIsActive | logical | Usr.UsrIsActive | Active |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrName | character | Usr.UsrName | User Name |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
Internal usage
BLF
QadFinancials