The following functions are available in rules:
| Function | Input | Description |
|---|---|---|
| ASF_GETALLOWEDACCESSSUBJECTS | Returns cursor: get list of ACCESSSUBJECTS who have access to a particular AccessObjects and Permisssion. Such as all groups,roles,users who have access to an Activity | |
| ASF_GETALLOWEDACCESSSUBJECTSI | returns table: same as above but a wrapper. Select * from TABLE(ASF_...I(A01, permission, domain). TALK TO SK for example | |
| ASF_GETALLOWEDAOBYLIST | filters list of AccessObjects by AccessSubjects and Permissions. Get a list of all Activites that the combination of AccessSubjects can EXECUTE | |
| ASF_GETALLOWEDAOBYLISTI | wrapper for above | |
| ASF_GETALLOWEDAOFORLOGIN | same a 2.3 but uses login as the input instead of ACCESSUBJECTS | |
| ASF_GETALLOWEDAOFORLOGINI | wrapper for above | |
| ASF_GETALLOWEDASSI | same as 2.1 but returns integer ID instead of Code. For perofmance issues | |
| ASF_GETUSERASBYLOGIN | retruns cursor of ACCESSUBJECTS by login | |
| ASF_GETUSERASBYLOGINI | ||
| ASF_ISAUTHORIZED | accepts PermissionCode and AccessObject and CSV of Subjects and returns 0/1 for allowed/denied | |
| ASF_ISAUTHORIZEDI | ||
| ASF_SPLIT | accepts separted string and returns a table of values. Max 8000 characters | |
| ASF_SPLITCLOB | ASF_SPLIT but no restriciton on size. Lower performance. Input/output are clobs | |
| ASF_SPLITCLOB2 | ||
| DATEDIFF | difference between two dates |