Capture value in "Multi Selector" attribute

Gerji

Hi,
I'm new to Awareim and currently working on my first project.
I have a relation attribute that is a "Multi Selector" type, and it works fine on forms, but can anyone kindly show me how to capture the values in this attribute and show then into queries and reports ?
Thanks

customaware

FIND MyRecords WHERE MyRecords IN SomeOtherBO.pm_MyMultiSelector

Gerji

Hi Mark ,
Thanks a lot for your response.
Other than not being able to apply the query code to my case ( sorry but I'm still trying to find my way around :roll: ) , but my need also changed now . Now I need to capture the the values in the "multi-selector" attribute to another text attribute , so as I can export this attribute and use the exported Excel file with another database later.
Please see attached captures of my BOs, Forms and Relations, what I'm exactly trying to do is :

The Attribute (EmpActivityCap) to capture all the values entered in multi-selector Attribute ( EmpActivity) on the same BO (EmployeesTbl).
I have tried this code in an update rule " EmployeesTbl.EmpActivityCap = EmployeesTbl.EmpActivity.ActivityName" , but it only captures the first value entered in the multi-selector field.

I hope there will be a way of getting this done.

Thanks again and regards,
Ammar

idpSteve

Here's what I would do:

Create a process (call it Proc1 for this example). It should have inputs of EmployeesTbl AND ActivitiesTbl and have a rule saying :

EmployeesTbl.EmpActivityCap=EmployeesTbl.EmpActivityCap+' '+ActivitiesTbl.ActivityName

After that, add this as an Update Rule for EmployeeTbl:

IF ActivitiesTbl WAS ADDED TO EmployeeTbl.EmpActivities THEN
EmployeeTbl.EmpActivityCap=UNDEFINED
FIND ActivitiesTbl WHERE ActivitiesTbl IN EmployeeTbl.EmpActivity
Proc1

That should work I think...

PS. You could probably rather do this in the update rules, which would update the text field if an item is added OR removed from your multi selector list:

IF EmployeeTbl.EmpActivities WAS CHANGED THEN
EmployeeTbl.EmpActivityCap=UNDEFINED
FIND ActivitiesTbl WHERE ActivitiesTbl IN EmployeeTbl.EmpActivity
Proc1

Gerji

Having the second code in the updated rule worked just fine ! Thanks a lot Mark for your great support.
Regards