This can be done by using Security Group data restrictions.
1) Create a condition as below:
Condition Name : TESTSTATUS
Condition expression is VALUE IN ('APPR','WAPPR','DRAFT') <Make sure there is no colon (:) in the expression and also no validation required>
2) Apply condition in Security group :
Select require security group and go to data restrictions tab.
Enter new row :
Object : SYNONYMDOMAIN
Application : <Application name>
Type : Qualified
Condition : TESTSTATUS
Reevaluate : Checked
Save the security group and signout & signin again.
Now you can able to see the only require statuses in List and Advanced Search Tab.
Note :
1. In condition, make sure there will be no COLON ':' in condition expression. No validation require at condition.
2. By applying condition to SYNONYMDOMAIN at security group data restrictions, it will be applicable all synonymdomains for that application. Usually for any application, synonym domains values (not maxvalue) will be unique.
1) Create a condition as below:
Condition Name : TESTSTATUS
Condition expression is VALUE IN ('APPR','WAPPR','DRAFT') <Make sure there is no colon (:) in the expression and also no validation required>
2) Apply condition in Security group :
Select require security group and go to data restrictions tab.
Enter new row :
Object : SYNONYMDOMAIN
Application : <Application name>
Type : Qualified
Condition : TESTSTATUS
Reevaluate : Checked
Save the security group and signout & signin again.
Now you can able to see the only require statuses in List and Advanced Search Tab.
Note :
1. In condition, make sure there will be no COLON ':' in condition expression. No validation require at condition.
2. By applying condition to SYNONYMDOMAIN at security group data restrictions, it will be applicable all synonymdomains for that application. Usually for any application, synonym domains values (not maxvalue) will be unique.
8 comments:
How does Maximo recognize that with "VALUE" we mean the "STATUS" field?
Because I want to block some information according to a value inside the LOCATIONS table. Thanks
Maximo will not recognize VALUE meant for STATUS synonym domain. Condition will applicable to all synonym domains of particular application mentioned in the security groups data restrictions.
And provided solution is applicable to only list tab.
If you want to block some information in lookups based on value inside the LOCATIONS table, you need to create a new condition and write your condition in expression builder and associate condition to particular domain value in Domains application. Don't forget to mention object name while associating condition to Domain. In your case object name is LOCATIONS.
How this logic works only for list tab and not for other tabs?
It works ok, at list tab a have the statuses that a defined at restriction.
But when I'm trying to add new location I get the error message BMXAA4017E (... is not qualified according to the data restriction of this user) using this.
I'm sure there is no COLON ':' in condition expression and no validation require at condition.
I have one more restriction to object locations it.
I've found solution. I forgot to add the domainid for the condition expression "domainid ='LOCASSETSTATUS'".
I tried this. But it restricted in main tab as well. i am not able to see those statuses in change status dialog
It's not the correct solution for filter list tab.
The better way is to use specific lookup with whereclause on value
for example :
dataattribute="value" whereclause=" value in ('TOTO', 'TATA', 'TITI')
Apply this lookup to the field in the application conceptor.
Erase the "advance control id" in "advance" tab.
sorry for bad english
Hello,I am trying to use conditional expressions in domains. For each value of the domain I set a condition.
If I put the field associated to the domain in a table, the lookup will filter values ok in the rows, but in the filter the values are not filtered by condition, and all values of the domain are shown. Do you know why?
Thanks
Post a Comment