Bug 142800 TVT3.2:TCT576: AR: BIRT: New Data Set Wizard
OS: Windows XP. Must Fix: YES. Blocking: No. Build Date: 0518 Component: BIRT - New Data Set Wizard. Language: AR Tester Name: Omar Bahy Scenario: 1- Right click on data set and choose "New Data Set". Click Finish 2- Inspect the SQL statement box. Problem: SQL statement box should be unmirrored to maintain readability. This article was reassigned from Category:''TVT/Testing''.
data/org.eclipse.birt.report.data.oda.jdbc.ui/src/org/eclipse/birt/report/data/oda/jdbc/ui/editors/SQLDataSetEditorPage.java
/**
	 * return the query text. If the query text is empty then return the pre-defined pattern
	 * 
	 * @return
	 */
	private String getQueryText( )
	{
		String queryText = this.getDataSetDesign( ).getQueryText( );
		if ( queryText != null && queryText.trim( ).length( ) > 0 )
			return queryText;
		return getQueryPresetTextString( );
	}
	
	/**
	 * Return pre-defined query text pattern with every element in a cell.
	 * 
	 * @return pre-defined query text
	 */
	private String getQueryPresetTextString( )
	{
		String[] lines = getQueryPresetTextArray( );
		String result = "";
		if ( lines != null && lines.length > 0 )
		{
			for ( int i = 0; i < lines.length; i++ )
			{
				result = result
						+ lines[i] + ( i == lines.length - 1 ? " " : " \n" );
			}
		}