Assignment Manager Has No Values in Priority

Technote (FAQ)


Question

Is it possible to set values preferences in priority?

Answer

Yes you need to run the below scripts using a SQL tool. Create a back up of your database.

Steps to see the problem:

Go to Assignment Manager \Select Action \Set Preferences\Set Priority Preferences.

You will see empty drop down window.

Script to run:
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 0, 'NONE', 0, site.orgid, site.siteid, pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 0 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 1, 'PRIORITY', 1, site.orgid, site.siteid, pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 1 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 2, 'EQPRIORITY', 0, site.orgid, site.siteid, pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 2 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 3, 'PRIORITY + EQPRIORITY', 0, site.orgid, site.siteid,
pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 3 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 4, '2 * PRIORITY + EQPRIORITY', 0, site.orgid, site.siteid,
pricalcseq.nextval
from site
where not exists

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management IBM SmartCloud Control Desk
Systems and Asset Management Tivoli Asset Management for IT

Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Assets

Software version:

7.0, 7.1, 7.1.1, 7.5

Operating system(s):

AIX, AIX 64bit, Linux, Solaris, Windows

Reference #:

1619331

Modified date:

2013-10-30

Translate my page

Machine Translation

Content navigation