User guide

The view model editor
74 Data Integration with Sybase Avaki Studio
• column: the column whose data you want. You can specify the column either using
a 1-based integer index or a string containing its name.
Note The names of the result set variables are the incoming operator’s name
with “RS” appended. For example, the result set object for an incoming operator
named “Join1” would be named Join1RS.
The result set accessor functions are:
• getSmallIntValue(resultSet, column)
• getIntValue(resultSet, column)
• getBigIntValue(resultSet, column)
• getRealValue(resultSet, column)
• getDoubleValue(resultSet, column)
• getBooleanValue(resultSet, column)
• getBigDecimalValue(resultSet, column)
Current user methods
Studio also provides two functions that can be used to check (and therefore apply con-
ditional logic based on) the identity of the user running the data service deployed from
your model. You can either check whether the user is a particular individual or whether
the user belongs to a particular group. You can use these, for example, to limit access
to certain rows of data based on the user’s membership in a certain group. The func-
tions both take the Avaki domain name, authorization service name, and authorization
service type where you wish to authenticate the user. The is function also takes the
username you wish to check for, and the isMemberOf function takes the name of the
group you wish to check against.
• CurrentUser.is(domain, authSvc, authSvcType, username)
• CurrentUser.isMemberOf(domain, authSvc, authSvcType, group)