Showing posts with label maximo. Show all posts
Showing posts with label maximo. Show all posts

Thursday, June 28, 2018

Scheduled publishing of integration data

---------------------------------------------------------------------------- All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.
----------------------------------------------------------------------------------------------------------------------


Below solution can be helpful when business want to send the data out of maximo on scheduled intervals.

Below are the steps to be followed

1.       Use an existing object structure like MXASSET etc












2.       Add this object structure to a publish channel












3.       Add the publish channel to an external system (ex:EXTSYS1)

4.       Create a cron task and new cron instance with below mandatory information
   Class : custom.integration.cron.RunPublishChannelCrontask
   Access Level : Full



5.       Place  RunPublishChannelCrontask.class file in to the folder \SMP\maximo\applications\maximo\businessobjects\classes\custom\integration\cron.
6.       Build the ear, redeploy it and restart the servers.
7.       Reload the cron which is created earlier, data would be processed and kept in the MIF folder.


Please follow the below blog from Bruno for the class file and better solution

http://maximodev.blogspot.com/2012/04/mif-schedule-file-export.html 

Wednesday, July 12, 2017

How do I change background color of a field in list screen in Maximo


1.       Here I am taking an example of asset application in which I want to make my asset to be in Green background color when it satisfies some condition.
2.       Navigate to a list screen from application designer, select the field which needs to be highlighted.







3.   Click on ‘Configure Conditional Properties’ and add below information like
·         Security Group : MAXEVERYONE
·         Conditional property : KKS_CLR
·         Property : cssclass : bggreen




Similar trick can be followed to other colors like (bgred, bgyellow ) etc.

----------------------------------------------------------------------------
All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, September 26, 2016

IBM Maximo : Calling a report from a push button in Maximo

Idea here is to launch a report from a push button on any screen. In this way business can run a specific report by clicking a button in the screen itself.

1.       Find the report which you want to run (ex: woprint.rptdesign) and hit the database to find the report number and execute below query

select reportnum,reportname,appname from report where reportname='woprint.rptdesign' and APPNAME='WOTRACK';



2.       From Report Library file (REPLIBRARY) and search for reportnum="351" , note the id related to it (highlighted)






id="reportd351"
label="Request Page" mboname="WORKORDER" reportnum="351" reporttype="BIRT" width="550">

3.       Navigate to application designer, search for WOTRACK and a new button with details like
Event : reportd351 and save it



4.       From Work Order Tracking application , you can see a Print Report button, when you click it shows report page like below




And on Submit, it generates the report.




----------------------------------------------------------------------------
 All the messages
below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, September 20, 2016

Maximo Environment refresh- Naming environments

-- Below are the scripts which can be executed after production refreshes to make sure every environment is named from login screen etc.
Below is a example where we are trying to set values in a system as Development Environment


------ Messages on the Login Screen -----

--Login Button ---
update maximo.maxmessages set value = 'Sign In to Development' where msgkey = 'loginbutton' and msggroup = 'login';

-- Welcome Message ---
update maximo.maxmessages set value = 'You are in Development' where msgkey = 'welcome' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development' where msgkey = 'welcomemaximomessage' and msggroup = 'login';

update maximo.maxmessages set value = 'Welcome to Development, {0}' where msgkey = 'welcomeusername' and msggroup = 'login';

-- Maximo Log Out Messages ----
update maximo.maxmessages set value = 'All users will be logged out of Development Environment in {0} minutes. Save your work.' where msgkey = 'AdminLogoutSubject';

update maximo.maxmessages set value = 'Maximo configuration in progress on Development Environment' where msgkey = 'AdminLogoutMessage';

--- Maximo Application ----

update maximo.maxapps set description = 'DEV - ' || description;

commit;



----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, September 13, 2016

Maximo Automation Script : To make field value to remove special characters and to make it in upper case

Below script is used to remove the special characters and make values in the field to uppercase

Script
------
Name : ASSET-DESCRIPTION-REMOVE-SPLCASE
Language : jython

Launch Points
-------------
Name : ATT-REMOVE-SPLCASE
Active : 1
Object : Asset
Attribute : DESCRIPTION

Autoscript
----------

from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from psdi.util import MXApplicationException

logger = MXLoggerFactory.getLogger("maximo.script");
logger.debug("==================== ATT-REMOVE-SPLCASE." + launchPoint + ": START =====================")

#This script reformats the Description field to only have alphanumeric uppercase characters
#Characters A-Z and 0-9 inclusive are permitted.

description = mbo.getString("DESCRIPTION")
description = ''.join(i for i in description if i.isalnum())
description = description.upper()
mbo.setValue("DESCRIPTION", str(description), 2)

logger.debug("==================== ATT-REMOVE-SPLCASE." + launchPoint + ": END =====================")
----------------------------------------------------------------------------
All the messages
below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Discardable MBOSET / MBO in IBM Maximo

·         These can be used on MBOSETS which are used for traversing forward only ie looping in
·         They should not be used while doing edit/save etc operations
·         Mboset will not cache the MBOs as it fetches from directly from database. This will minimise the JVM memory usage.
·         Discardable Mbo Sets are always read only.

Example below to make a MBOset discardable

MboSetRemote personSet = getMboSet("PERSON");
personSet.setFlag(MboConstants.DISCARDABLE, true);




----------------------------------------------------------------------------
All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, July 20, 2016

Maximo : Populating ownergroup with a person group a user belongs to

 Below script is used to populate a field (Owner Group) in work order application with logged in users person group.

Launch point 
------------------
Name : KS_OBJ_OWNERGROUP
Desc : Launch Point for User
Intialize = Y
Condition : 
Object : WORKORDER

Autoscript :
Name : KS_OWNERGROUP
Desc : Load person group

from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from psdi.server import MXServer


logger =  MXLoggerFactory.getLogger("maximo.script");
logger.debug("====================KS_OWNERGROUP." + launchPoint + ": START  =====================")
mboServer = mbo.getMboServer()
user1 = mbo.getUserInfo()
personGroupQuery = "persongroup in (select distinct a.persongroup from persongroup a, persongroupteam b  where b.RESPPARTYGROUP = '"+user+"' and rownum<2 div="">
personGroupMboSet = mboServer.getMboSet("persongroup",user1)
personGroupMboSet.setWhere(personGroupQuery)
personGroupMboSet.reset()
if not personGroupMboSet.isEmpty():
 personGroupMbo=personGroupMboSet.getMbo(0)
 mbo.setValue("OWNERGROUP",personGroupMbo.getString("persongroup"),MboConstants.NOACCESSCHECK|MboConstants.NOVALIDATION_AND_NOACTION)
logger.debug("====================YYZ_OBJ_USERGROUP." + launchPoint + ": END  =====================")




----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, July 11, 2016

Fetch PO's which have been receipts completed more than 90 days

Below query would fetch list of PO's record which have all the receipts closed before 90 days.

select ponum,REVISIONNUM,status from maximo.PO where
 status='APPR' and receipts='COMPLETE' and
 exists (select 1 from (select transdate from (
 select max(TRANSDATE) transdate from maximo.SERVRECTRANS
 where ponum=po.ponum group by ponum union select
 max(TRANSDATE) transdate from maximo.MATRECTRANS where
 ponum=po.ponum group by ponum ) order by transdate desc )
 where rownum <2 and="" p="" sysdate-transdate=""> >90)

using this query we can write an escalation which can change status of PO to COMPLETE or close etc

----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, April 26, 2016

using array in Maximo Automation script


from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants
from jarray import array

logger = MXLoggerFactory.getLogger("maximo.script");
logger.debug("==================== ATT_WO_WOPRIORITY." + launchPoint + ": START =====================")

# declaring as a set of double values
arrSubDiv = array([1,2,3,4,5,6],'d')

woPriority = mbo.getDouble("WOPRIORITY")

for i in arrSubDiv:
 if (i==woPriority):
   mbo.setFieldFlag("JUSTIFYPRIORITY",MboConstants.REQUIRED, True)
else:
   mbo.setFieldFlag("JUSTIFYPRIORITY",MboConstants.REQUIRED, False)


logger.debug("==================== ATT_WO_WOPRIORITY." + launchPoint + ": END =====================")





----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, April 19, 2016

Get a list of included/excluded/Non Persistent/Persistent fields used in a Integration Object in Maximo.

Below query fetches list of records which have been used in integration object in Maximo .Here i took the example of Integration Object = MXASSET

select * from (
select distinct i.intobjectname,m.objectname,m.attributename,   'INCLUDE' as intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i, maximo.MAXINTOBJDETAIL intobjdtl  where i.INTOBJECTNAME in ('MXASSET')
and intobjdtl.INTOBJECTNAME in ('MXASSET') and m.objectname=intobjdtl.objectname and m.attributename not in (select b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')) and m.persistent != 0
union
select distinct i.intobjectname, m.objectname,m.attributename, i.intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i where i.INTOBJECTNAME in ('MXASSET') and i.intobjfldtype='EXCLUDE'
and m.objectname=i.objectname and m.attributename in (select  b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')  and intobjfldtype in ('EXCLUDE')) and m.persistent != 0
union
select distinct i.intobjectname, m.objectname,m.attributename, i.intobjfldtype from maximo.maxattribute m,maximo.MAXINTOBJCOLS i where i.INTOBJECTNAME in ('MXASSET') and i.intobjfldtype='NONPERSISTENT'
and m.objectname=i.objectname and m.attributename in (select  b.name from maximo.MAXINTOBJCOLS b where b.INTOBJECTNAME in ('MXASSET')  and intobjfldtype='NONPERSISTENT')) order by objectname,attributename



----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, April 18, 2016

Fixing LocAncestor Data integrity In Maximo


·         Take a backup of existing database table using below query
o   create table locancestor_bkp as (select * from locancestor);

·         Create a new procedure like this below and execute it.
*******************************************************************
create or replace procedure BUILD_LOCANCESTOR as

  MODULE_NAME varchar2(50) := 'LOCATIONS';
  SCRIPT_NAME varchar2(50) := 'BUILD_LOCANCESTOR.sql';
  TABLE_NAME  varchar2(50) := 'LOCANCESTOR';
  ERROR_COUNT number := 0; --Track no of errors
  REC_COUNTER number := 0; --Track no of loaded records
  R           number := 200; --Number of records to commit

  V_MAX_ID number;

  cursor LOCATIONS_CUR is
    select L.LOCATION, L.ORGID, L.SITEID, L.SYSTEMID from LOCHIERARCHY L;

  FIX_LOCATION LOCATIONS.LOCATION%type;
  FIX_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the location
  for which we are building the hierarchy (the entries in LOCANCESTOR table)*/

  X_LOCATION LOCATIONS.LOCATION%type;
  X_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the current location in the loop*/

  X_ANCESTOR_LOCATION LOCATIONS.LOCATION%type;
  X_ANCESTOR_SITEID   LOCATIONS.SITEID%type;
  /*These two variables are to hold the LOCATION and SITEID of the ancestor
  of the current location in the loop*/

begin
 

  execute immediate ('TRUNCATE TABLE ' || TABLE_NAME);
  execute immediate ('ALTER TABLE ' || TABLE_NAME || ' NOLOGGING');

  --RESET_SEQUENCE(TABLE_NAME);

  for LC in LOCATIONS_CUR loop
    declare
      FIX_SYSTEMID LOCHIERARCHY.SYSTEMID%type;

    begin
      FIX_LOCATION := LC.LOCATION;
      FIX_SITEID   := LC.SITEID;
      --These two variables will be fixed all the inner loop

     

      FIX_SYSTEMID := LC.SYSTEMID;

      X_LOCATION := LC.LOCATION;
      X_SITEID   := LC.SITEID;
      --These two variables will be changed for each iteration of the inner loop

      loop
        --Inner loop to build all LOCANCESTOR entries for the current location (FIX_LOCATION, FIX_SITEID)
        REC_COUNTER := REC_COUNTER + 1;

    

        insert /*+ APPEND */
        into LOCANCESTOR
          (LOCATION, ANCESTOR, SYSTEMID, SITEID, ORGID, LOCANCESTORID)
        values
          (FIX_LOCATION, --LOCATION
           X_LOCATION, --ANCESTOR
           FIX_SYSTEMID, --SYSTEMID
           LC.SITEID, --SITEID
           LC.ORGID, --ORGID
           LOCANCESTORSEQ.NEXTVAL --LOCANCESTORID
           );

        select max(H.PARENT), max(H.SITEID)
          into X_ANCESTOR_LOCATION, X_ANCESTOR_SITEID
          from LOCHIERARCHY H
         where H.LOCATION = X_LOCATION
           and H.SITEID = X_SITEID
           and H.SYSTEMID = FIX_SYSTEMID;

        if (X_ANCESTOR_LOCATION is null) then
          /*If there is no parent of the current location,
          so it's the top level one and we have to exit the inner loop*/
          exit;
        else
          X_LOCATION := X_ANCESTOR_LOCATION;
          X_SITEID   := X_ANCESTOR_SITEID;
        end if;
      end loop; --End the inner loop

    exception
      WHEN DUP_VAL_ON_INDEX THEN
        null;
      when others then
        ERROR_COUNT := ERROR_COUNT + 1;
       
    end;

    commit;
  end loop;

  commit;

  execute immediate ('ANALYZE TABLE ' || TABLE_NAME ||
                    ' COMPUTE STATISTICS');
  execute immediate ('ALTER TABLE ' || TABLE_NAME || ' LOGGING');

  DBMS_OUTPUT.PUT_LINE(TABLE_NAME || ' errors = ' || ERROR_COUNT);

 
end BUILD_LOCANCESTOR;
/
************************************************************
---------------------------------------------------------------------------- 
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, April 11, 2016

Maximo automation script... Jython code similar to string Starts with


from psdi.util.logging import MXLogger
from psdi.util.logging import MXLoggerFactory
from psdi.mbo import MboConstants

logger = MXLoggerFactory.getLogger("maximo.script");
siteVar=str(mbo.getMboValue("SITEID"))
## Below line does action similar to starts with in string. It compares if site variable starts with KSK or not, if it doesnt start it alerts the user
if(siteVar[:len("KSK")] <> "KSK"):
 logger.debug("Site validation")
 errorgroup = "Site"
 errorkey ="Checksite"


ref : Reference Link


----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, February 24, 2016

Adding messages in processing rules of Enterprise services in Maximo

Below are the steps which are to be followed to make sure messages can be properly added in enterprise services à processing rules.

·         Create an entry in Messages from database configuration making sure that messagegroup value is ‘iface’  example below
o   Message Group :iface
o   Message Key : VALIDATIONALERT
o   Display Method : MSGBOX
o   Value : Alerting user

·         Now navigate to Enterprise services à Processing rules and select this value from lookup attached to Message Key.


----------------------------------------------------------------------------
 All the messages below are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Friday, February 19, 2016

Fetching last 6 months data in Maximo using SQL Server with output in a specific language

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database in a specific language.
here i am using Portugese as lanuage in which my output should be

Query is self explanatory


select CASE month
WHEN  'January' THEN 'Janeiro de'
WHEN  'February' THEN 'Fevereiro'
WHEN  'March' THEN 'Março de'
WHEN  'April' THEN 'Abril'
WHEN  'May' THEN 'Maio'
WHEN  'June' THEN 'Junho de'
WHEN  'July' THEN 'Julho'
WHEN  'August' THEN 'Agosto'
WHEN  'September' THEN 'Setembro de'
WHEN  'October' THEN 'Outubro'
WHEN  'November' THEN 'Novembro de'
  ELSE 'Dezembro de'
END month,countoftickets from ( SELECT DATENAME(MONTH,DATEADD(month, -5, GETDATE())) month,COUNT(*) AS countoftickets , 1 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -5, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -4, GETDATE())) month,COUNT(*) AS countoftickets , 2 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -4, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -3, GETDATE())) month,COUNT(*) AS countoftickets , 3 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -3, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -2, GETDATE())) month,COUNT(*) AS countoftickets , 4 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -2, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, -1, GETDATE())) month,COUNT(*) AS countoftickets , 5 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -1, GETDATE())) union  SELECT DATENAME(MONTH,DATEADD(month, 0, GETDATE())) month,COUNT(*) AS countoftickets , 6 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, 0, GETDATE()))  ) a1  order by fs

output:

month countoftickets
Setembro de 0
Outubro 0
Novembro de 0
Dezembro de 22
Janeiro de 57
Fevereiro 34






----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Thursday, February 18, 2016

Displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Below query can be used for displaying data ticket count with in SLA by priority in MAXIMO using SQL Server.

Data would be displayed like below

Priority          Count Status
1                 1        SLA OK
1                   2        SLA NOT OK
3                  15      SLA OK


Query :

select internalpriority,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" and="" by="" count="" from="" group="" internalpriority="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by internalpriority










----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Display Number of tickets solved with in SLA by person in Maximo .. SQL Server

Below query can be used for displaying data solved with in SLA by person in MAXIMO using SQL Server.

Data would be displayed like below

AffectedPerson Count Status
ABC                   1        SLA OK
ABC                   2        SLA NOT OK
XYZ                   15      SLA OK


Query :

select affectedperson,count(*) count, 'SLA NOT OK'  status  from TICKET where targetcontactdate is not null and actualcontactdate is not null and targetcontactdate - actualcontactdate <0 -="" actualcontactdate="" affectedperson="" and="" by="" count="" from="" group="" is="" nbsp="" not="" null="" ok="" select="" status="" targetcontactdate="" ticket="" union="" where="">=0 group by affectedperson







----------------------------------------------------------------------------
All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Tuesday, February 16, 2016

Displaying tickets created from different sources in Maximo using Sql Server

Below query can be used to display number of tickets which are created from different sources(here external systems) as per months.

Output would be like below

Source  Month count
Email    Dec       10
Email     Jan        14
Phone    Jan         15
self Serv  Dec      05

Query:

select externalsystem,DATENAME(MONTH,DATEADD(month, 0, creationdate)) month ,count(*) count  from TICKET  group by externalsystem , DATENAME(MONTH,DATEADD(month, 0, creationdate))








---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Sunday, February 7, 2016

Fetching Last 6 months data in SQL Server for Maximo

Below is one of the best ways to find number of tickets created in last 6 months in Maximo using SQL Server database.

Query is self explanatory

select month,countoftickets from (
SELECT DATENAME(MONTH,DATEADD(month, -5, GETDATE())) month,COUNT(*) AS countoftickets , 1 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -5, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -4, GETDATE())) month,COUNT(*) AS countoftickets , 2 as fs FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -4, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -3, GETDATE())) month,COUNT(*) AS countoftickets , 3 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -3, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -2, GETDATE())) month,COUNT(*) AS countoftickets , 4 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -2, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, -1, GETDATE())) month,COUNT(*) AS countoftickets , 5 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, -1, GETDATE())) union
SELECT DATENAME(MONTH,DATEADD(month, 0, GETDATE())) month,COUNT(*) AS countoftickets , 6 as fs  FROM ticket WHERE MONTH(creationdate) = MONTH(DATEADD(month, 0, GETDATE()))  ) a1
order by fs

output:

Month   Countoftickets
October 10
November 12
December   5
January   17
February 20
March 15











---------------------------------------------------------------------------- All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Monday, January 18, 2016

Enable Workflow reassignments in Maximo based on security groups

1.       Simple way to enable workflow reassignments in application is through Signature options and security group.
2.       Navigate to any application in which you need Workflow reassignment option thorough application designer. In this case I am taking Requests and Defects (Oil) -- PLUSGDEF
3.       From select action add a sig option called ‘MAXWFRA’ with a  simple desc and save the record.



4.       Now navigate to the security group for which this access  has to be enabled and check the sigoption under the application (PLUSGDEF).

5.       After signing out and signing in as a user from that security group ,When you navigate to Requests and Defects (Oil) application and select a record with an active workflow . Observe that Reassignments icon is visible.









----------------------------------------------------------------------------
 All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.

Wednesday, January 6, 2016

How to wrap attributes in Birt based on space.


In the attribute which you want to wrap add the following code which wraps after every space to next line

if(dataSetRow["description"]!=null){
  dataSetRow["description "].replace(/ /g,"\n")
 }


/ /g à means white space anywhere in the string

----------------------------------------------------------------------------

All the messagesbelow are just forwarded messages if some one feels hurt about it please add your comments we will remove the post.Host/author is not responsible for these posts.