Hi to all!
Is there a way to convert the return type of multiple column queries into my own referenced type?
Example, my query statement is "SELECT rfqItemId, itemNumber FROM RFQItems". the return type of each element data retrieved is Object, I want it to be RFQItems. Currently, I'm querying the entire table but this kinda makes the query slow. I would like to query at least just these two columns for a particular process.
By the way, I'm using Jboss SEAM framework. And below is one of the codes that I want to optimize...
query="SELECT c.rfqItemId,c.item FROM RFQItems c WHERE c.recordStatus=true"),