mx.services

statusCode

Simply contains the list of the status codes

Method Summary

private   query getAllStatusCodes ()
remote   numeric getInactiveStatusID ()
remote   numeric getNotifiedStatusID ()
remote   query getStatusCodes ()

Method Details

getAllStatusCodes

private query getAllStatusCodes ()

Gets the list of status codes and names. Query returned has columns: STATUS_ID and STATUS_NAME

Parameters
a query with the status codes and names

getInactiveStatusID

remote numeric getInactiveStatusID ()

Gets the id of the status code 'INACTIVE'

Returns
the id of the inactive status code

getNotifiedStatusID

remote numeric getNotifiedStatusID ()

Gets the id of the status code 'Notified'

Returns
the id of the notified status code

getStatusCodes

remote query getStatusCodes ()

Gets the list of status codes and names except for inactive status code. Query returned has columns: STATUS_ID and STATUS_NAME

Returns
a query with the status codes and names