Production Issue search enhancement

Issue history: 

added username to all custom search api’s queries. We must ignore username from search results.

Changes done on common file’s method which all custom search api’s being used.

Issue raised: some custom search api’s missed out with out adding username.

Impact: required values also missed from search results of the custom search apis which doesn’t have username.

Severity: High

Priority: Top

Solution Approach:

While adding username to query keep alias name to the username.

SELECT ‘LOGGED_USERNAME’ PROD_USER, …..FROM … WHERE…. 

Changes were required in common file.While ignoring the username from the results checking the username included or not [resultSetMetaData.getColumName(i) ==’PROD_USER_ID’]. If not included keep the old code which populating search result. If included customize the search by ignoring username from the results.