ValueChangeEvent's getNewValue() returning null when making changes to db query string

[Tariq Ahsan]

I am running into an error condition on the Alfresco based application's UI web page with the error message -
javax.faces.el.EvaluationException: Exception while invoking expression #{mycode.changeDisplayResults}
at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:156)


....

Caused by: java.lang.NullPointerException
at org.alfresco.web.bean.mycode.changeDisplayResultsEra(mycode.java:779)


This would happen if I make the changes in the SavedSearchResultDataMgr class which does the jdbc database query. The changes are –

From -

private static final String CODE_LIST_TABLE = " select code_name, code_value, code_description " +
                                                                                " from code_list_table " +
                                                                                " where code_name = ? " +
                                                                                " order by order_index ";

To -


private static final String CODE_LIST_TABLE = " select code_name, code_value, code_description " +
                                                                                " from code_list_table " +
                                                                                " where code_name = ? " +
                                                                                " and newcol= 'ABC'" +
                                                                                " order by order_index ";

By the way, I added a new column in the CODE_LIST_TABLE table – NEWCOL differentiate between code lists to be displayed on the dropdown based on certain business logic.

In my investigation I found that, in the method –

public void changeDisplayResultsEra(final ValueChangeEvent event) {

...

String newValue = event.getNewValue().toString(); <- is returning NULL instead of desired value

If I change back the query string back to it's original state without " and newcol= 'ABC'" +
the drop-down for Reason field on the screen will display all the required rows including the new values I added to the table.

ValueChangeEvent object - event is not null altogether as ValueChangeEvent.getOldValue() returning value.
Here's the part of the jsp page -

<td>
  <h:selectOneMenu
	id="SelectOneMenuReleaseability"
	  	value="#{mycode.currentAssetDecision.releaseability}"
		style="font-weight:bold" 
		immediate="true" 
		onchange= "submit();"
		valueChangeListener="#{mycode.changeReleasabilityEra}" >						
		<f:selectItems id="Items" value="#{mycode.itemList}" />
   </h:selectOneMenu>  

</td>

Any idea about this problem?

Thanks