how do I update multiple value allowed attribute via process

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

how do I update multiple value allowed attribute via process

Post by swiftinitpvtltd »

I have one attribute called owners which I need as distinct from current set of items(which I was able to get) but now how do I dump these unique owners into BO.Owners field via rule?
I can get distinct contacts by
Contacts WHERE(EXISTS MyBo WHERE (MyBo IN MyMaster AND Contacts=MyBo.Contacts ))
but how do I put these now in BO.Owners. When I assign
BO.Owners=Contacts it updates but only with 1 one value and I know there are 3 contacts. If I call a process after getting Contacts how do I do
BO.Owners=BO.Owners+Contacts so that it will finally put
BO.Owners=contact1;contact2;contact3

I do see 3 Display messages(if there are 3 contacts meaning distinct technique works!) when I call a process and put test message so I just need to know how do I con-cat
BO.Owners=BO.Owners+Contact


Also I can not use any aware BO Out of box references for this need as I need to first extract unique owners from transactions and then dump them into transaction-owners BO attribute in master BO for some further calculations.

Master BO
Transaction BO- 10 transactions can have 3 or 4 or 5 unique owners(created by)
and then in Master BO-BO.Owners i need Unique 3 or 4 or 5 owners based on 50 or 100 transactions done by these owners. I am almost close but I am not sure how to do contact- BO.Owners=BO.Owners+Contact- this gives math error
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: how do I update multiple value allowed attribute via pro

Post by swiftinitpvtltd »

I found an answer suggested by Mark B. Thanks Mark!

http://awareim.com/forum/viewtopic.php? ... 5e8#p45873

So you just use
INSERT Contacts IN MasterBO.om_CurrentOwners in the process call and it works!
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Re: how do I update multiple value allowed attribute via pro

Post by ddumas »

I do this by calling a stored proc, which creates a single string, essentially unpivoting the rows. If I find myself having do to too much in rules, as it pertains to setting special columns, a stored proc works great.
Post Reply