Berto2002 Posted February 24 Share Posted February 24 I am trying to look-up attributes of a User Profile in reference to the 'person' who made an Activity update on a Request. So I wanted to do a table JOIN between the h_actor of h_buz_activities and the h_userid of h_sys_user_profiles but the former has "urn:sys:user:" prefix. What do I do to strip that out in my table join statement in the reports please? Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now