Skip to main content

Posts

Showing posts from January, 2022

If Else clause or decode or Case in Where clause

 If Else clause or decode or case in Where clause We are not going to check here if else or decode or case but i am going to tell u an alternate......... Suppose we need workorder's with status =APPR  else I need WAPPR but i have to give preference to APPR solution select * from maximo.workorder where status in (APPR,WAPPR) order by status desc Now suppose we have 2 records one is appr and one is wappr Then modify this query like  Select * from maximo.workorder where workorderid in ( select workorderid  from maximo.wokrorder where workorderid in (select workorderid from maximo.workorder where status in (APPR,WAPPR) order by status desc )  where rownum<2) So we are using here rownum to display approve before wappr ............ If we have only wappr records then our subquery will return wappr records only and with  rownum<2  we will get only one record.................... This you can use in relationship of maximo where u have to find 1 record only...

how to use sqlformat in automation script

  status=mbo.getString("status")  siteid=mbo.getString("siteid")    assetSet=mbo.getMboSet("ASSET")   sqlFormat = SqlFormat(assetSet.getUserInfo(), "siteid = :2 and status=:1 ")   sqlFormat.setObject(1, "ASSET", "STATUS", status)   sqlFormat.setObject(2, "ASSET", "SITEID", siteid)   assetSet.setWhere(sqlFormat.format())

Books and Blogs on Maximo

 1. Maximo Functional Consultant :- get it from Amazon/Google Bookstore.. 2. IBM Redbooks (User Guide, Certification Guide, Performance Guide, Workflow Guide , Multisite Implementation, Application designer Guide) 3. Bruno's blog 4. Maximoconcepts blog 5. MaximoTimes blog 6. Ourmaximoblotspot

cannot find symbol DateTimeFormatter

 java 11 cannot find symbol DateTimeFormatter This error occur due to import statements are missing.. import java.time.*; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.LocalTime; import java.time.Month; import java.time.format.DateTimeFormatter; import java.util.Date; public class DateTimeAPI  { public static void main(String[] args) {  LocalDate date2 = LocalDate.of(2020, Month.NOVEMBER, 10);         LocalTime time2 = LocalTime.of(19, 23);         LocalDateTime dt2 = LocalDateTime.of(date2, time2); System.out.println(date2.format(DateTimeFormatter.ISO_LOCAL_DATE));         System.out.println(time2.format(DateTimeFormatter.ISO_LOCAL_TIME));         System.out.println(dt2.format(DateTimeFormatter.ISO_LOCAL_DATE_TIME)); var formatter2 = DateTimeFormatter.ofPattern("MM/dd/yyyy hh:mm:ss");     ...

Java Secure coding guidlines

 Java Secure coding guidelines 1. Use Security Api's. 2. Always Close open resources use Try with Resources. 3. Use Class Loaders and Policy's for fine grain access 4. Always validate input format and input data . 5. Never grant unnecessary permission to third party code. 6. Never ignore exceptions   7. Avoid duplications. 8. Document Security Information  9. Encapsulate your changes. 10. Write Clear Code. 11. Do not log config information of your app. 12. Do not serialize security Codes. 13. Always do negative Testing against your code. 14. Use known and tested libraries 15. Always use prepared statements to handle SQL parameters. 16. Don't reveal implementation via complete error messages example userid failed or password failed. 17. Keep security releases up to date. 18. Look for dependency vulnerabilities. 19  Monitor and log user activity for brute force attack and denial of service.

Need to load millions\lacks of records in Maximo

Need to load millions\lacks of records in Maximo    Their might be chance you need to load millions of records in existing maximo records but since ur system might have already so many records uploading using dataloader or any csv will be difficult another option you can use  iface tables in another schema that in Maximo and then configure baches in Maximo. You can monitor these batches.

How to clear Java developer 11 Certification 819

 How to clear Java developer 11 Certification 819 (6 Months for fresher... 2-4 Months for Experience developer assuming avg. 3years experience) 1. Study Durgasoft Core java lectures and videos 2. Study Durgasoft Java 9 Features  3. Study Durgasoft Java 11 Features 4. Study OCP by Jeanne Boyarsky or kt siera.. 5. Enroll  couple of for practice test of udemy's /ethuware/wh...labs.. 6. Work on Dumps of Youtube 7. Write code on notepad only and pay attention to command prompts. 8. Do lot of code, code ... code and code...  9. Oracle.com docs... Solve mock test every 2 weeks (3 Months === 10 Mock Tests Minimum likewise ) If you fail with low score than again study resources...  Divide your time to complete.. Speed up your study if required. Partition your study in these category like I did and mark it checked :-  Topics Theory Videos Practice Programs Made Dumps JPMS   ...