Please share any images or screenshots, if relevant.
Share all details related to your problem, including any error messages you may have received.
Greetings, Experts I hope that everything is going well for everyone.
In the “spt_certification_item” table, I created a column named “lohith1” using the Alter command. I’ve been attempting to assign a value to the column using the “certification_item_customization” function (something like CertificationItem.setCustom1(),setExtended1() - Which could be done only for custom and extended attribute).Is there a comparable method I can use to add a value to my custom column called lohith1?
Hi Lolith,
Generaly in IIQ if you just extend database schema / table - it will have no impact to the data model available to the application. Reason behind that is that IIQ is using Hibernate as data access layer and actualy order of operations to extend schema is slightly different.
You have to modify respective HBM file to add additional attribute to the model
You generate update scripts via /$IIQ_HOME/WEB-INF/bin/iiq command
I’ve followed the entire process mentioned in document.I can see “lohithattribute1” is created & populated as well.But i don’t see the value injected into the db
What is the method you used to update the attribute in Certification Item table, the above mentioned article is written by myself and I implemented this personally.
Using the below method, you should be able to populate the value, assuming you have the CertificationItem Object already in certItemObj
Hi Lolith,
I see you execute item.setAttribute("lolithattribute1", "Value");
this will not save data to the database
you have to add after that this 2 lines
@iamksatish yes satish i’ve done mapping in my system config
@kjakubiak i tried adding
context.saveObject(item);
context.commitTransaction();
I’m facing below error
An unexpected error occurred: The application script threw an exception: sailpoint.tools.GeneralException: org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: sailpoint.object.CertificationEntity BSF info: Lohith Test CertificationItem Customisation-New at line: 0 column: columnNo
use item.setAttribute.(“attributename”, “value”); CertificationItem extended attributes should match Link extended attributes. This allows those extended Link attributes to be included in the detail records of certification access reviews. CertificationItem extended attributes which do not correspond to Link extended attributes will not be populated (unless done so manually through a rule) since there is no way to declare a source for those attributes other than through a Link extended attribute of the same name.
Hi there to all of you.I appreciate your assistance; the problem has been fixed. The value is being populated in extendedAttribute 4 rather than my custom attribute because of additional Account attributes, which is the reason for this. Everything went smoothly when I removed it.
