Constraints Doubt

[Former Member]

Hi,

I want to create one user with restricted access.

Suppose i hv 2 tables A & B.

For table A:

City State Country

C1----S1---Contr1

C2----S2---Contr2

C3----S3---Contr3

C4----S4---Contr4

For Table B with Country as lookup field:

Region Market Country

R1-----M1-----Contr1

R2-----M2-----Contr2

R3-----M3-----Contr3

R4-----M4-----Contr4

Now here i want restricted User to c only 2 countries..say contr1 and contr2.

So I did the constraints for Table A & Assigned the user only Contr1 & Contr2.

Now when i login in data Manager with This User,

In Table A he can see only 2 records......... in which country has value Contr1 & contr2

When i go to table B in Drop down of Country field i can see all countries.

But i want user to c only 2 countries.........Contr1 & Contr2 in the dropdown.

How can i achieve this.

Thanks,

Mahi

[Former Member]

Hi,

As Jitesh suggested u can use concept of masks.

However since masks are static use Named Searches Instead.(Static here means everytime u add a new record u will to add the manually in masks,however in Named search it is automatic)

Go to Data Manager slect current table as Named search.

Create New Named search say S1 for restricted user.

Now select table A as current table .Enter a search for country =Countr1 and Countr2.This result of search then add to Named Search S1.Do the same for table B

Go to console Add constraint to role of restricted user under Named search as S1.

Regards

Nisha

Edited by: Nisha L on Aug 20, 2008 3:34 PM

[Former Member]

Hi Maheshwari,

1. Go to MDM Console, In Roles table and select Tables and Fields Tab.

2. Select the lookup table Countries. Select Contr1 and Contr2 in the Constraints column.

This should list only two countries in the drop down.

Thanks and Regards,

Sagar Sonje

Mark Helpful Answers

[Former Member]

Hi Maheshwari,

Try to assign the constraint on Lookup table Country instead of assigning on Table A and Table B else you need to individually assign the constraint on all the tables.

Regards,

Jitesh Talreja

[Former Member]

Hi Jitesh,

Thanks.

But i dont Country as lookup field......... its a text field

N Whatever i hv given is just a simple example to understand my problem..... Actual tables n fields r diff

Thanks,

Mahi

[Former Member]

Hi Mahi,

Try to achieve the requirement with the help of Masks. Search the records containing Count1 and Count2 and add the result in the Mask. Now assign this mask to the role in the Console.

We cannot put constraints over text fields

Regards,

Jitesh Talreja