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.
Need Help on RUle Language
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Need Help on RUle Language
mfauzi wrote: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.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Object Diagram
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
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
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Already Responded
Hi I already responded your PM