I have into a problem with one of the Appian created rules. The rule is APN_dis

helmuta over 10 years ago

I have into a problem with one of the Appian created rules. The rule is APN_distinct, I am using this rule to try and retrieve a set of distinct userids from a database view. The view contains multiple instances of a user but I want to display a set of unique users names based on the userids. has anyone else run into this problem? Any thoughts on what I might do differently?

Here is the section of the SAIL code:

local!resourceList: rule!APN_distinct(rule!TT_getResourcesByPM(local!pmID))...

Discussion posts and replies are publicly visible

0 PhilB
A Score Level 1
over 10 years ago

Have you tried using apply() to cast the user array to and array of string and then calling the distinct function?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 10 years ago

No, I have not. The userids are actually integers. One possible solution that I am working with now is to use union. The only problem is that local!resourceList is a CDT that contains different types (user_id, role_id, user_name, etc.) which is what I think is causing the problem for the APN_distinct rule. I bet if I ask for a distinct local!resourceList.userid it would work. I might have to try it using that logic.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 10 years ago

APN_distinct just calls the union function anyway. You should be passing in the user_id element of the CDT as you say, if that doesn't work then cast the usernames to integers (or strings, it shouldn't really matter) before using APN_distinct.

The user object can often behave strangely with some functions; isnull(), for example, will not quite work properly (it often returns true even if the user is null) so it's sometimes safer to cast the user objects to a string.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 10 years ago

Thank you! I will give it a try.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel