ResourceQuery to extract Roles

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
CMNew
Basic Member Send Private Message
Posts: 16
Basic Member
When I use the ResourceQuery  to extract Roles, the Roles extracted do not have a delimiter. How do I separate them? Am I doing something wrong?
Tim Cochrane
Veteran Member Send Private Message
Posts: 154
Veteran Member
I've never had a need to extract roles...but I can see your dilema, as my query also returns all roles in a long string.
There has to be a way to get that data in a delimited format...maybe somebody that's figured this out already will pony up...otherwise i can think of a semi-ugly approach of doing some pattern matching against the RM query return, within a flow to see what roles somebody has.
Tim Cochrane - Principal LM/IPA Consultant
TBonney
Veteran Member Send Private Message
Posts: 281
Veteran Member
Depending on what you're doing with the information, you can always export to a simple text editor and manipulate it as necessary. We always use Notepad++, which (we feel) is a great tool, useful for all coding languages.
John Henley
Send Private Message
Posts: 3351
Posted By CMNew on 09/10/2015 3:23 PM
When I use the ResourceQuery  to extract Roles, the Roles extracted do not have a delimiter. How do I separate them? Am I doing something wrong?

What ProcessFlow version are you using? I have tested this in v9 and IPA / v1-- the roles are returned separated by CR/LF. 

Thanks for using the LawsonGuru.com forums!
John