Need Help on RUle Language

mfauzi

Hi all, I created the following object.

customer - has column segment
segment - has relation with customer object
regular user
user-customer - bridge object to show one user can be assign multiple customer
user-segment - bridge object to show user and customer segment

My quesiton is:

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

mfauzi wrote
Hi all, I created the following object.

customer - has column segment

segment - has relation with customer object

regular user

user-customer - bridge object to show one user can be assign multiple customer

user-segment - bridge object to show user and customer segment

My quesiton is:

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.

customer object can own only one segment
segment can own more than 1 customer
user - segment can own 1 segment
user - segment can own 1 user.
user - customer can own 1 customer
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