Maximo Table domain over Aln domain
sometimes we have requirement to filter aln domain, a way of it can be to create a table domain over the aln domain and apply list where clause.
Technically this design is not incorrent....
* Now their is a catch with this ... what suppose we want to further filter this with automation script...... when maximo build this list where clause
domain type :- Table domain
ALN Domain :- Months
List where :- domainid='MYMONTHDOMAIN'
Automation script :- listwhere("month.startswith [J])
when we apply this to field that field might not respect your list where clause sometimes...so you might need reapply the domain in automation script on field..
so you in autoscript whereclause should be formed like
wherecaluse =domainid='monthdomain' and value in (value.statrtwith (J))
because maximo ignores what's coming with list where clause....
Comments
Post a Comment