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
how do I update multiple value allowed attribute via process
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: how do I update multiple value allowed attribute via pro
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!
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!
Re: how do I update multiple value allowed attribute via pro
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.