Need Help on RUle Language

[mfauzi]

Hi all, I created the following object.
1. customer - has column segment
2. segment - has relation with customer object
3. regular user
4. user-customer - bridge object to show one user can be assign multiple customer
5. user-segment - bridge object to show user and customer segment

My quesiton is:
1. when a record is created in user-segment, I want to populate the user-customer with customer instance which meet the customer segment register for the user.

[customaware]

Hi all, I created the following object.
1. customer - has column segment
2. segment - has relation with customer object
3. regular user
4. user-customer - bridge object to show one user can be assign multiple customer
5. user-segment - bridge object to show user and customer segment

My quesiton is:
1. when a record is created in user-segment, I want to populate the user-customer with customer instance which meet the customer segment register for the user.

Hi Fauzi,

I have read this a number of times and still cannot clearly understand what you are trying to do.

It would really assist us to help you if you clearly explained what you have.

For example.

How many Business Objects do you have. I count 3 but I suspect you are trying to create intermediate BOs as well for
M:M relationships with User-Customer and User-Segment.

Please say it like.

I have a Customer that can Own Many Segments
I have a RegularUser that can Own Many Customers


etc etc...

Or... better still draw a diagram with the relationships.

This will give us a clear picture and will be able to assist much better.

[mfauzi]

Thanks for the reply. below is I hope more clearer picture.
1. customer object can own only one segment
2. segment can own more than 1 customer
3. user - segment can own 1 segment
4. user - segment can own 1 user.
5. user - customer can own 1 customer
6. user - customer can own 1 user.

Example:
customer AA ,BB,CC,DD has segment Retail

If a user add one user-segment record with user1 and segment retail, , system will automatically add user1 and customer AA,BB,CC,DD into object user-customer.

I've created this bridge object, in order to make it easier to limit query for the user

[hpl123]

mfauzi,
Sorry, still difficult to understand what you are trying to do. Please write out the use case (s) instead if possible or explain in more detail.

Thanks

[customaware]

Henrik,

I sent Fauzi a PM to try and get a better understanding. Will advise if I get a reply.

[customaware]

Mfauzi,

I have sent you two more PMs.. Please respond.

[mfauzi]

Hi I already responded your PM