select attachment_number,delete_flag,filename,fi.ifs_filepath, file_size,f.CREATED from attachment a,files f, version_file_map vfm,version v, FILE_INFO fi where (f.id=vfm.file_id) and f.id=fi.file_id and (vfm.version_id=v.id) and (v.attach_id=a.id) and f.CREATED > to_date(’05-Mar-2019′,’DD-MON-YYYY’) and v.checkin_user in (‘110246201’) order by Read More
Recover Keystore for Agile 9.3.2 and 9.3.3
agileks.jks is the Keystore used by Agile based on Java JCEKS and AES algorithm. So all the AES related password in Agile are associated with agileks.jks. During Agile 9.3.2/9.3.3 installation, Read More
Create Pie Chart in Excel Using Java – POI JFreeChart – Example Program
In this post, we will provide XLSX example. We have a sample XLSX document with Pie Chart data source. We will read the data from the data source, create the Pie Chart and add it Read More
Create Files On Google Drive using PHP
In order to create a file in google drive, foremost we need to create a project in Google developer console. Follow the below steps to work with Google Drive APIs Prerequisites Read More
Removing Orphan Files in Agile PLM
All the attachments in the file folders which are not referenced by any object in PLM, are considered as orphan files. When you are using Agile PLM as your tool Read More
Enovation Of PLM
One of the topics that people often ask is what is the difference between PDM and PLM. The question is almost rhetoric, since the number of explanation is +1 from Read More