User row restrictions

[sedom]

Is there a way to restrict a user from only choosing a specific value but being able to view the same value for all entries.

Example: Have a table that has seller state and customer state. If I create a query where the user chooses a seller state or a customer state, I want to restrict the user to choose only 1 state. But in the output I want to allow the user to view all states.

Restrict seller state = to Ohio or restrict customer state = to Ohio when using as a condition. On output if seller state is used as a condition, view all customer states that are applicable not just Ohio or vice versa.

Thanks for any assistance.

 

[blom0344]

Hello Sedom,

I expect that in your table you have a 1 to n or n to m relation between seller state and customer state.

If you deny the user the right (through supervisor) to edit the dataprovider you can simply force him to be able to select just one state by using a condition like:

Seller_state equal to <prompt>

This prompt does not accept more than one entry

If you fill in OHIO and there are 10 occurences in the table with OHIO as seller state you would get max of 10 rows returned.

However you want to let user choose between sellerstate and customerstate as input. If you set the OR operator between the 2 prompt conditions leaving the first prompt empty and using the second prompt with 1 entry you should get the result you want.. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[sedom]

Thanks but I guess I didn't explain it correctly.

Yes I do have a 1 to m relationship set on the table.

I don't want the user to have a choice to enter in anything but OHIO for seller or Customer.

If I do a row restriction for seller state = ohio then the user can only choose and VIEW seller state = to ohio. Same with customer state.

I don't want the user to have a choice when it comes to a condition that either they define via WebI or that I define and put out there as a corporate report.

But If they have seller in the condition and customer in the query, then I want them to see all of the customer state.

I am thinking this is impossible from what I remember in the business objects classes that I took.

We work off of Oracle 8i.

Thanks again for your answer. That may be the only way I will be able to do it is to force them to put an answer in.

Sedom!!

 

[blom0344]

Ahum,

Sorry for taking another shot at this, but do you mean you want to restrict user X to use any other input than OHIO and for instance user Y from using something else than ALABAMA?

Then check out the Supervisor module, Universe tab , properties --> rows and add an restriction for that specific user.
T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[sedom]

I have tried the row restriction in the supervisor module and that does restrict the user from choosing any value, but it also restricts the user from viewing all values of the specific restriction defined.

Again, I am almost positive there is no way for me to say you can only choose this value but can view all values.

I was wondering if doing the row restriction and in the where statement using the @Prompt would work...but I couldn't get that to work either.

Thanks for the input. If I figure it out I will post again.

Sedom