<commit_before>
package edu.wustl.query.util.global;

import java.awt.Color;

/**
 * 
 * @author baljeet_dhindhwal
 * @version 1.0
 *
 */
public class Constants extends edu.wustl.common.util.global.Constants
{

	//Shopping cart related
	/**  Constant for QUERY_SHOPPING_CART  */
	public static final String QUERY_SHOPPING_CART = "queryShoppingCart";
	/**  Constant for  */
	public static final String CHECK_ALL_ACROSS_ALL_PAGES = "isCheckAllAcrossAllChecked";
	/**  Constant for  */
	public static final String CHECK_ALL_PAGES = "checkAllPages";
	/**  Constant for  */
	public static final String SELECTED_COLUMN_META_DATA = "selectedColumnMetaData";
	/**  Constant for  */
	public static final String DELETE = "delete";
	/**  Constant for  */
	public static final String VALIDATION_MESSAGE_FOR_ORDERING = "validationMessageForOrdering";
	/**  Constant for  */
	public static final String PAGEOF_QUERY_MODULE = "pageOfQueryModule";
	/**  Constant for  */
	public static final String IS_LIST_EMPTY = "isListEmpty";
	/**  Constant for  */
	public static final String SHOPPING_CART_DELETE = "shoppingCartDelete";
	/**  Constant for  */
	public static final String SHOPPING_CART_ADD = "shoppingCartAdd";
	/**  Constant for  */
	public static final String PAGINATION_DATA_LIST = "paginationDataList";
	/**  Constant for  */
	public static final String LABEL_TREE_NODE = "Label";
	/**  Constant for  */
	public static final String HAS_CONDITION_ON_IDENTIFIED_FIELD = "hasConditionOnIdentifiedField";
	/**  Constant for  */
	public static final String NODE_SEPARATOR = "::";
	/**  Constant for  */
	public static final String UNDERSCORE = "_";
	/**  Constant for  */
	public static final String ADD_TO_ORDER_LIST = "addToOrderList";
	/**  Constant for  */
	public static final String REQUEST_TO_ORDER = "requestToOrder";
	/**  Constant for  */
	public static final String BULK_TRANSFERS = "bulkTransfers";
	/**  Constant for  */
	public static final String BULK_DISPOSALS = "bulkDisposals";
	/**  Constant for  */
	public static final String OUTPUT_TERMS_COLUMNS = "outputTermsColumns";
	/**  Constant for  */
	public static final String SUCCESS = "success";
	/**  Constant for  */
	public static final String ENTITY_SEPARATOR = ";";
	/**  Constant for  */
	public static final String ATTRIBUTE_SEPARATOR = "|";
	/**  Constant for  */
	public static final String KEY_SEPARATOR = "*&*";
	/**  Constant for  */
	public static final String KEY_CODE = "key";
	/**  Constant for  */
	public static final String EXPORT_DATA_LIST = "exportDataList";
	/**  Constant for  */
	public static final String ENTITY_IDS_MAP = "entityIdsMap";
	/**  Constant for  */
	public static final String FINISH = "finish";
	/**  Constant for  */
	public static final String QUERY_REASUL_OBJECT_DATA_MAP = "queryReasultObjectDataMap";
	/**  Constant for  */
	public static final String DEFINE_VIEW_QUERY_REASULT_OBJECT_DATA_MAP = "defineViewQueryReasultObjectDataMap";
	/**  Constant for  */
	public static final String CONTAINTMENT_ASSOCIATION = "CONTAINTMENT";
	/**  Constant for  */
	public static final String MAIN_ENTITY_MAP = "mainEntityMap";
	/**  Constant for  */
	public static final String SPECIMENT_VIEW_ATTRIBUTE = "defaultViewAttribute";
	/**  Constant for  */
	public static final String PAGEOF_SPECIMEN_COLLECTION_REQUIREMENT_GROUP = "pageOfSpecimenCollectionRequirementGroup";
	/**  Constant for  */
	public static final String NO_MAIN_OBJECT_IN_QUERY = "noMainObjectInQuery";
	/**  Constant for  */
	public static final String QUERY_ALREADY_DELETED = "queryAlreadyDeleted";
	/**  Constant for  */
	public static final String BACK = "back";
	/**  Constant for  */
	public static final String RESTORE = "restore";
	/**  Constant for  */
	public static final String SELECTED_COLUMN_NAME_VALUE_BEAN_LIST = "selectedColumnNameValueBeanList";
	/**  Constant for  */
	public static final String TREE_DATA = "treeData";
	/**  Constant for  */
	public static final String ID_NODES_MAP = "idNodesMap";
	/**  Constant for  */
	public static final String DEFINE_RESULTS_VIEW = "DefineResultsView";
	/**  Constant for  */
	public static final String CURRENT_PAGE = "currentPage";
	/**  Constant for  */
	public static final String ADD_LIMITS = "AddLimits";
	/**  Constant for  */
	public static final int QUERY_INTERFACE_BIZLOGIC_ID = 67;
	/**  Constant for  */
	public static final String SQL = "SQL";
	/**  Constant for  */
	public static final String ID_COLUMN_ID = "ID_COLUMN_ID";
	/**  Constant for  */
	public static final String ID = "id";
	/**  Constant for  */
	public static final String SAVE_TREE_NODE_LIST = "rootOutputTreeNodeList";
	/**  Constant for  */
	public static final String ATTRIBUTE_COLUMN_NAME_MAP = "attributeColumnNameMap";
	/**  Constant for  */
	public static final String IS_SAVED_QUERY = "isSavedQuery";
	/**  Constant for  */
	public static final String TREE_ROOTS = "treeRoots";
	/**  Constant for  */
	public static final String NO_OF_TREES = "noOfTrees";
	/**  Constant for  */
	public static final String TREE_NODE_LIMIT_EXCEEDED_RECORDS = "treeNodeLimitExceededRecords";
	/**  Constant for  */
	public static final String VIEW_LIMITED_RECORDS = "viewLimitedRecords";
	/**  Constant for  */
	public static final String SAVE_GENERATED_SQL = "sql";
	/**  Constant for  */
	public static final String TREENO_ZERO = "zero";
	/**  Constant for  */
	public static final String COLUMN_NAMES = "columnNames";
	/**  Constant for  */
	public static final String INDEX = "index";
	/**  Constant for  */
	public static final String[] ATTRIBUTE_NAMES_FOR_TREENODE_LABEL = {"firstName", "lastName",
			"title", "name", "label", "shorttitle"};
	/**  Constant for  */
	public static final String COLUMN_NAME = "Column";
	/**  Constant for  */
	public static final String ON = " ON ";
	/**  Constant for  */
	public static final String OFF = "off";
	/**  Constant for  */
	public static final String PAGE_OF_QUERY_MODULE = "pageOfQueryModule";
	/**  Constant for  */
	public static final String RANDOM_NUMBER = "randomNumber";
	/**  Constant for  */
	public static final String IS_NOT_NULL = "is not null";
	/**  Constant for  */
	public static final String IS_NULL = "is null";
	/**  Constant for  */
	public static final String IN = "in";
	/**  Constant for  */
	public static final String Not_In = "Not In";
	/**  Constant for  */
	public static final String Equals = "Equals";
	/**  Constant for  */
	public static final String Not_Equals = "Not Equals";
	/**  Constant for  */
	public static final String Between = "Between";
	/**  Constant for  */
	public static final String Less_Than = "Less than";
	/**  Constant for  */
	public static final String Less_Than_Or_Equals = "Less than or Equal to";
	/**  Constant for  */
	public static final String Greater_Than = "Greater than";
	/**  Constant for  */
	public static final String Greater_Than_Or_Equals = "Greater than or Equal to";
	/**  Constant for  */
	public static final String Contains = "Contains";
	/**  Constant for  */
	public static final String STRATS_WITH = "Starts With";
	/**  Constant for  */
	public static final String ENDS_WITH = "Ends With";
	/**  Constant for  */
	public static final String NOT_BETWEEN = "Not Between";
	/**  Constant for  */
	public static final String INVALID_CONDITION_VALUES = "InvalidValues";
	/**  Constant for  */
	public static final String SAVE_QUERY_PAGE = "Save Query Page";
	/**  Constant for  */
	public static final String EXECUTE_QUERY_PAGE = "Execute Query Page";
	/**  Constant for  */
	public static final String FETCH_QUERY_ACTION = "FetchQuery.do";
	/**  Constant for  */
	public static final String EXECUTE_QUERY_ACTION = "ExecuteQueryAction.do";
	/**  Constant for  */
	public static final String EXECUTE_QUERY = "executeQuery";
	/**  Constant for  */
	public static final String SHOPPING_CART_FILE_NAME = "MyList.csv";
	/**  Constant for  */
	public static final String APPLICATION_DOWNLOAD = "application/download";
	/**  Constant for  */
	public static final String DOT_CSV = ".csv";
	/**  Constant for  */
	public static final String HTML_CONTENTS = "HTMLContents";
	/**  Constant for  */
	public static final String INPUT_APPLET_DATA = "inputAppletData";
	/**  Constant for  */
	public static final String SHOW_ALL = "showall";
	/**  Constant for  */
	public static final String SHOW_ALL_ATTRIBUTE = "Show all attributes";
	/**  Constant for  */
	public static final String SHOW_SELECTED_ATTRIBUTE = "Show selected attributes";
	/**  Constant for  */
	public static final String ADD_EDIT_PAGE = "Add Edit Page";
	/**  Constant for  */
	public static final String IS_QUERY_SAVED = "isQuerySaved";
	/**  Constant for  */
	public static final String CONDITIONLIST = "conditionList";
	/**  Constant for  */
	public static final String QUERY_SAVED = "querySaved";
	/**  Constant for  */
	public static final String DISPLAY_NAME_FOR_CONDITION = "_displayName";
	/**  Constant for  */
	public static final String SHOW_ALL_LINK = "showAllLink";
	/**  Constant for  */
	public static final String VIEW_ALL_RECORDS = "viewAllRecords";
	/**  Constant for  */
	public static final String POPUP_MESSAGE = "popupMessage";
	/**  Constant for  */
	public static final String ID_COLUMNS_MAP = "idColumnsMap";
	/**  Constant for  */
	public static final String TREE_NODE_ID = "nodeId";
	/**  Constant for  */
	public static final String HASHED_NODE_ID = "-1";
	/**  Constant for  */
	public static final String BUTTON_CLICKED = "buttonClicked";
	/**  Constant for  */
	public static final String UPDATE_SESSION_DATA = "updateSessionData";
	/**  Constant for  */
	public static final String EVENT_PARAMETERS_LIST = "eventParametersList";
	/**  Constant for  */
	public static final String VIEW = "view";
	/**  Constant for  */
	public static final String APPLET_SERVER_URL_PARAM_NAME = "serverURL";
	/**  Constant for  */
	public static final String TEMP_OUPUT_TREE_TABLE_NAME = "TEMP_OUTPUTTREE";
	/**  Constant for  */
	public static final String CREATE_TABLE = "Create table ";
	/**  Constant for  */
	public static final String AS = "as";
	/**  Constant for  */
	public static final String TREE_NODE_FONT = "<font color='#FF9BFF' face='Verdana'><i>";
	/**  Constant for  */
	public static final String TREE_NODE_FONT_CLOSE = "</i></font>";
	/**  Constant for  */
	public static final String ZERO_ID = "0";
	/**  Constant for  */
	public static final String NULL_ID = "NULL";
	/**  Constant for  */
	public static final String UNIQUE_ID_SEPARATOR = "UQ";
	/**  Constant for  */
	public static final String SELECT_DISTINCT = "select distinct ";
	/**  Constant for  */
	public static final String SELECT = "SELECT ";
	/**  Constant for  */
	public static final String FILE_TYPE = "file";
	/**  Constant for  */
	public static final String FROM = " from ";
	/**  Constant for  */
	public static final String WHERE = " where ";
	/**  Constant for  */
	public static final String LIKE = " LIKE ";
	/**  Constant for  */
	public static final String LEFT_JOIN = " LEFT JOIN ";
	/**  Constant for  */
	public static final String INNER_JOIN = " INNER JOIN ";
	/**  Constant for  */
	public static final String HASHED_OUT = "####";
	/**  Constant for  */
	public static final String DYNAMIC_UI_XML = "dynamicUI.xml";
	/**  Constant for  */
	public static final String DATE = "date";
	/**  Constant for  */
	public static final String DATE_FORMAT = "MM-dd-yyyy";
	/**  Constant for  */
	public static final String DEFINE_SEARCH_RULES = "Define Limits For";
	/**  Constant for  */
	public static final String CLASSES_PRESENT_IN_QUERY = "Objects Present In Query";
	/**  Constant for  */
	public static final String CLASS = "class";
	/**  Constant for  */
	public static final String ATTRIBUTE = "attribute";
	/**  Constant for  */
	public static final String FILE = "file";
	/**  Constant for  */
	public static final String MISSING_TWO_VALUES = "missingTwoValues";
	/**  Constant for  */
	public static final String METHOD_NAME = "method";
	/**  Constant for  */
	public static final String categorySearchForm = "categorySearchForm";
	/**  Constant for  */
	public static final int ADVANCE_QUERY_TABLES = 2;
	/**  Constant for  */
	public static final String DATE_TYPE = "Date";
	/**  Constant for  */
	public static final String INTEGER_TYPE = "Integer";
	/**  Constant for  */
	public static final String FLOAT_TYPE = "Float";
	/**  Constant for  */
	public static final String DOUBLE_TYPE = "Double";
	/**  Constant for  */
	public static final String LONG_TYPE = "Long";
	/**  Constant for  */
	public static final String SHORT_TYPE = "Short";
	/**  Constant for  */
	public static final String FIRST_NODE_ATTRIBUTES = "firstDropDown";
	/**  Constant for  */
	public static final String ARITHMETIC_OPERATORS = "secondDropDown";
	/**  Constant for  */
	public static final String SECOND_NODE_ATTRIBUTES = "thirdDropDown";
	/**  Constant for  */
	public static final String RELATIONAL_OPERATORS = "fourthDropDown";
	/**  Constant for  */
	public static final String TIME_INTERVALS_LIST = "timeIntervals";
	/**  Constant for  */
	public static final String ENTITY_LABEL_LIST = "entityList";

	/**  Constant for  */
	public static final String DefineSearchResultsViewAction = "/DefineSearchResultsView.do";

	/**  Constant for  */
	public static final Color BG_COLOR = new Color(0xf4f4f5);

	// Dagviewapplet constants
	/**  Constant for  */
	public static final String QUERY_OBJECT = "queryObject";
	/**  Constant for  */
	public static final String SESSION_ID = "session_id";
	/**  Constant for  */
	public static final String STR_TO_CREATE_QUERY_OBJ = "strToCreateQueryObject";
	/**  Constant for  */
	public static final String ENTITY_NAME = "entityName";
	/**  Constant for  */
	public static final String INIT_DATA = "initData";
	/**  Constant for  */
	public static final String ATTRIBUTES = "Attributes";
	/**  Constant for  */
	public static final String ATTRIBUTE_OPERATORS = "AttributeOperators";
	/**  Constant for  */
	public static final String FIRST_ATTR_VALUES = "FirstAttributeValues";
	/**  Constant for  */
	public static final String SECOND_ATTR_VALUES = "SecondAttributeValues";
	/**  Constant for  */
	public static final String SHOW_ENTITY_INFO = "showEntityInformation";
	/**  Constant for  */
	public static final String SRC_ENTITY = "srcEntity";
	/**  Constant for  */
	public static final String PATHS = "paths";
	/**  Constant for  */
	public static final String DEST_ENTITY = "destEntity";
	/**  Constant for  */
	public static final String ERROR_MESSAGE = "errorMessage";
	/**  Constant for  */
	public static final String SHOW_VALIDATION_MESSAGES = "showValidationMessages";
	/**  Constant for  */
	public static final String SHOW_RESULTS_PAGE = "showViewSearchResultsJsp";
	/**  Constant for  */
	public static final String ATTR_VALUES = "AttributeValues";
	/**  Constant for  */
	public static final String SHOW_ERROR_PAGE = "showErrorPage";
	/**  Constant for  */
	public static final String GET_DATA = "getData";
	/**  Constant for  */
	public static final String SET_DATA = "setData";
	/**  Constant for  */
	public static final String EMPTY_LIMIT_ERROR_MESSAGE = "<li><font color='red'>Please enter at least one condition to add a limit to limit set.</font></li>";
	/**  Constant for  */
	public static final String EMPTY_DAG_ERROR_MESSAGE = "<li><font color='red'>Limit set should contain at least one limit.</font></li>";
	/**  Constant for  */
	public static final String MULTIPLE_ROOTS_EXCEPTION = "<li><font color='red'>Expression graph should be a connected graph.</font></li>";
	/**  Constant for  */
	public static final String EDIT_LIMITS = "<li><font color='blue'>Limit succesfully edited.</font></li>";
	/**  Constant for  */
	public static final String DELETE_LIMITS = "<li><font color='blue'>Limit succesfully deleted.</font></li>";

	/**  Constant for  */
	public static final String MAXIMUM_TREE_NODE_LIMIT = "resultView.maximumTreeNodeLimit";
	//public static final String ATTRIBUTES = "Attributes";
	/**  Constant for  */
	public static final String SESSION_EXPIRY_WARNING_ADVANCE_TIME = "session.expiry.warning.advanceTime";

	/**  Constant for  */
	public static final String SearchCategory = "SearchCategory.do";
	/**  Constant for  */
	public static final String DefineSearchResultsViewJSPAction = "ViewSearchResultsJSPAction.do";
	/**  Constant for  */
	public static final String NAME = "name";
	/**  Constant for  */
	public static final String TREE_VIEW_FRAME = "treeViewFrame";
	/**  Constant for  */
	public static final String QUERY_TREE_VIEW_ACTION = "QueryTreeView.do";
	/**  Constant for  */
	public static final String QUERY_GRID_VIEW_ACTION = "QueryGridView.do";
	/**  Constant for  */
	public static final String GRID_DATA_VIEW_FRAME = "gridFrame";
	/**  Constant for  */
	public static final String PAGE_NUMBER = "pageNum";
	/**  Constant for  */
	public static final String TOTAL_RESULTS = "totalResults";
	/**  Constant for  */
	public static final String RESULTS_PER_PAGE = "numResultsPerPage";
	/**  Constant for  */
	public static final String SPREADSHEET_COLUMN_LIST = "spreadsheetColumnList";
	/**  Constant for  */
	public static final String PAGE_OF = "pageOf";

	/**  Constant for  */
	public static final String SPREADSHEET_EXPORT_ACTION = "SpreadsheetExport.do";
	/**  Constant for  */
	public static final int[] RESULT_PERPAGE_OPTIONS = {10, 50, 100, 500, 1000};
	/**  Constant for  */
	public static final String PAGE_OF_PARTICIPANT_CP_QUERY = "pageOfParticipantCPQuery";
	/**  Constant for  */
	public static final String CONFIGURE_GRID_VIEW_ACTION = "ConfigureGridView.do";
	/**  Constant for  */
	public static final String SAVE_QUERY_ACTION = "SaveQueryAction.do";

	/**  Constant for  */
	public static final int CHARACTERS_IN_ONE_LINE = 110;
	/**  Constant for  */
	public static final String SINGLE_QUOTE_ESCAPE_SEQUENCE = "&#096;";
	/**  Constant for  */
	public static final String ViewSearchResultsAction = "ViewSearchResultsAction.do";

	/**  Constant for  */
	public static final String QUERY_IDENTIFIER_NOT_VALID = "Query identifier is not valid.";
	/**  Constant for  */
	public static final String NO_RESULT_FOUND = "No result found.";
	/**  Constant for  */
	public static final String QUERY_ID = "queryId";
	/**  Constant for  */
	public static final String QUERY_COLUMN_NAME = "Column";

	/**  Constant for  */
	public static final String QUERY_OPENING_PARENTHESIS = "(";
	/**  Constant for  */
	public static final String QUERY_CLOSING_PARENTHESIS = ")";
	/**  Constant for  */
	public static final String QUERY_DOT = ".";
	/**  Constant for  */
	public static final String QUERY_UNDERSCORE = "_";
	/**  Constant for  */
	public static final String QUERY_COMMA = " ,";
	/**  Constant for  */
	public static final String QUERY_EQUALS = " = ";
	/**  Constant for  */
	public static final String QUERY_FILE = "file";
	/**  Constant for  */
	public static final String STR_TO_DATE = "STR_TO_DATE";

	/**  Constant for  */
	public static final String QUERY_FROM_XMLTABLE = " from xmltable";
	/**  Constant for  */
	public static final String QUERY_FOR = " for ";
	/**  Constant for  */
	public static final String QUERY_LET = " let ";
	/**  Constant for  */
	public static final String QUERY_ORDER_BY = " order by ";
	/**  Constant for  */
	public static final String QUERY_RETURN = " return ";

	/**  Constant for  */
	public static final char QUERY_DOLLAR = '$';
	/**  Constant for  */
	public static final String QUERY_XMLCOLUMN = "db2-fn:xmlcolumn";
	/**  Constant for  */
	public static final String QUERY_XMLDATA = "XMLDATA";
	/**  Constant for  */
	public static final String QUERY_AND = " and ";

	/**  Constant for  */
	public static final String TRUE = "true";
	/**  Constant for  */
	public static final String FALSE = "false";
	/**  Constant for  */
	public static final String Is_PAGING = "isPaging";
	/**  Constant for  */
	public static final String CONTENT_TYPE_TEXT = "text/html";

	/**
	 * 
	 * @param s
	 * @return
	 */
	public static final String getOracleTermString(String s)
	{
		return "extract(day from " + s + ")*86400 + extract(hour from " + s
				+ ")*3600 + extract(minute from " + s + ")*60 + extract(second from " + s + ")";
	}
	
	public static final String VERSION = "VERSION";

	//Constants related to Export functionality
	/**  Constant for  */
	public static final String SEARCH_RESULT = "SearchResult.csv";
	/**  Constant for  */
	public static final String ZIP_FILE_EXTENTION = ".zip";
	/**  Constant for  */
	public static final String CSV_FILE_EXTENTION = ".csv";
	/**  Constant for  */
	public static final String EXPORT_ZIP_NAME = "SearchResult.zip";
	/**  Constant for  */
	public static final String PRIMARY_KEY_TAG_NAME = "PRIMARY_KEY";
	/**  Constant for  */
	public static final String ID_COLUMN_NAME = "ID_COLUMN_NAME";
	/**  Constant for  */
	public static final String PRIMARY_KEY_ATTRIBUTE_SEPARATOR = "!~!~!";

	//Taraben Khoiwala
	/**  Constant for  */
	public static final Object PERMISSIBLEVALUEFILTER = "PV_FILTER";
	/**  Constant for  */
	public static final int ADVANCE_QUERY_INTERFACE_ID = 24;
	/**  Constant for  */
	public static final String PUBLIC_QUERY_PROTECTION_GROUP = "Public_Query_Protection_Group";
	/**  Constant for  */
	public static final String MY_QUERIES = "MyQueries";

	/**  Constant for  */
	public static final String[] NUMBER = {"long", "double", "short", "integer", "float"};
	/**  Constant for  */
	public static final String NEWLINE = "\n";
	/**  Constant for  */
	public static final String DATATYPE_BOOLEAN = "boolean";
	/**  Constant for  */
	public static final String DATATYPE_NUMBER = "number";
	/**  Constant for  */
	public static final int MAX_PV_SIZE = 500;
	/**  Constant for  */
	public static final int MAX_SIZE = 500;

	/**  Constant for  */
	public static final int WORKFLOW_BIZLOGIC_ID = 101;
	/**  Constant for  */
	public static final String MY_QUERIES_FOR_WORKFLOW = "myQueriesForWorkFlow";
	/**  Constant for  */
	public static final String PUBLIC_QUERIES_FOR_WORKFLOW = "publicQueryForWorkFlow";
	/**  Constant for  */
	public static final String DISPLAY_QUERIES_IN_POPUP = "displayQueriesInPopup";
	/**  Constant for  */
	public static final String PAGE_OF_MY_QUERIES = "MyQueries";

	/**  Constant for  */
	public static final int WORKFLOW_FORM_ID = 101;

	/**  Constant for  */
	public static final String ELEMENT_ENTITY_GROUP = "entity-group";
	/**  Constant for  */
	public static final String ELEMENT_ENTITY = "entity";
	/**  Constant for  */
	public static final String ELEMENT_NAME = "name";
	/**  Constant for  */
	public static final String ELEMENT_ATTRIBUTE = "attribute";
	/**  Constant for  */
	public static final String ELEMENT_TAG = "tag";
	/**  Constant for  */
	public static final String ELEMENT_TAG_NAME = "tag-name";
	/**  Constant for  */
	public static final String ELEMENT_TAG_VALUE = "tag-value";
	/**  Constant for  */
	public static final String TAGGED_VALUE_NOT_SEARCHABLE = "NOT_SEARCHABLE";
	/**  Constant for  */
	public static final String TAGGED_VALUE_NOT_VIEWABLE = "NOT_VIEWABLE";
	/**  Constant for  */
	public static final String VI_IGNORE_PREDICATE = "VI_IGNORE_PREDICATE";
	/**  Constant for  */
	public static final String TAGGED_VALUE_PRIMARY_KEY = "PRIMARY_KEY";
	/**  Constant for  */
	public static final String TAGGED_VALUE_PV_FILTER = "PV_FILTER";
	/**  Constant for  */
	public static final String TAGGED_VALUE_VI_HIDDEN = "VI_HIDDEN";
	/**  Constant for  */
	public static final String CONTAINMENT_OBJECTS_MAP = "containmentObjectMap";
	/**  Constant for  */
	public static final String ENTITY_EXPRESSION_ID_MAP = "entityExpressionIdMap";

	//added by amit_doshi
	/**  Constant for  */
	public static final String PV_TREE_VECTOR = "PermissibleValueTreeVector";

	/**  Constant for  */
	public static final String PROPERTIESFILENAME = "vocab.properties";
	/**  Constant for  */
	public static final int SEARCH_PV_FROM_VOCAB_BILOGIC_ID = 12;
	/**  Constant for  */
	public static final String ATTRIBUTE_INTERFACE = "AttributeInterface";
	/**  Constant for  */
	public static final String ENTITY_INTERFACE = "EntityInterface";
	/**  Constant for  */
	public static final String VOCABULIRES = "Vocabulries";
	/**  Constant for  */
	public static final String ENUMRATED_ATTRIBUTE = "EnumratedAttribute";
	/**  Constant for  */
	public static final String COMPONENT_ID = "componentId";
	/**  Constant for  */
	public static final String NO_RESULT = "No results found";
	/**  Constant for  */
	public static final String MED_PV_HTML = "MEDPVHTML";

	/**  Constant for  */
	public static final String DEFINE_VIEW_MSG = "DefineView";
	/**  Constant for  */
	public static final String ENTITY_NOT_PRESENT = "not present";
	/**  Constant for  */
	public static final String ENTITY_PRESENT = "present";
	/**  Constant for  */
	public static final String MAIN_ENTITY_MSG = "Main Entity";
	/**  Constant for  */
	public static final String NOT_PRESENT_MSG = " Is Not Present In DAG";
	/**  Constant for  */
	public static final String MAIN_ENTITY_LIST = "mainEntityList";
	/**  Constant for  */
	public static final String SELECTED_CONCEPT_LIST = "SELECTED_CONCEPT_LIST";
	/**  Constant for  */
	public static final String TAGGED_VALUE_MAIN_ENTIY = "MAIN_ENTITY";
	public static final String BASE_MAIN_ENTITY = "BASE_MAIN_ENTITY";
	/**  Constant for  */
	public static final String ENTITY_LIST = "entityList";
	/**  Constant for  */
	public static final String MAIN_ENTITY_EXPRESSIONS_MAP = "mainEntityExpressionsMap";
	/**  Constant for  */
	public static final String MAIN_EXPRESSION_TO_ADD_CONTAINMENTS = "expressionsToAddContainments";
	/**  Constant for  */
	public static final String ALL_ADD_LIMIT_EXPRESSIONS = "allLimitExpressionIds";
	/**  Constant for  */
	public static final String MAIN_EXPRESSIONS_ENTITY_EXP_ID_MAP = "mainExpEntityExpressionIdMap";
    <commit_msg>*** empty log message ***<commit_after>
package edu.wustl.query.util.global;

import java.awt.Color;

/**
 * 
 * @author baljeet_dhindhwal
 * @version 1.0
 *
 */
public class Constants extends edu.wustl.common.util.global.Constants
{

	//Shopping cart related
	/**  Constant for QUERY_SHOPPING_CART  */
	public static final String QUERY_SHOPPING_CART = "queryShoppingCart";
	/**  Constant for  */
	public static final String CHECK_ALL_ACROSS_ALL_PAGES = "isCheckAllAcrossAllChecked";
	/**  Constant for  */
	public static final String CHECK_ALL_PAGES = "checkAllPages";
	/**  Constant for  */
	public static final String SELECTED_COLUMN_META_DATA = "selectedColumnMetaData";
	/**  Constant for  */
	public static final String DELETE = "delete";
	/**  Constant for  */
	public static final String VALIDATION_MESSAGE_FOR_ORDERING = "validationMessageForOrdering";
	/**  Constant for  */
	public static final String PAGEOF_QUERY_MODULE = "pageOfQueryModule";
	/**  Constant for  */
	public static final String IS_LIST_EMPTY = "isListEmpty";
	/**  Constant for  */
	public static final String SHOPPING_CART_DELETE = "shoppingCartDelete";
	/**  Constant for  */
	public static final String SHOPPING_CART_ADD = "shoppingCartAdd";
	/**  Constant for  */
	public static final String PAGINATION_DATA_LIST = "paginationDataList";
	/**  Constant for  */
	public static final String LABEL_TREE_NODE = "Label";
	/**  Constant for  */
	public static final String HAS_CONDITION_ON_IDENTIFIED_FIELD = "hasConditionOnIdentifiedField";
	/**  Constant for  */
	public static final String NODE_SEPARATOR = "::";
	/**  Constant for  */
	public static final String UNDERSCORE = "_";
	/**  Constant for  */
	public static final String ADD_TO_ORDER_LIST = "addToOrderList";
	/**  Constant for  */
	public static final String REQUEST_TO_ORDER = "requestToOrder";
	/**  Constant for  */
	public static final String BULK_TRANSFERS = "bulkTransfers";
	/**  Constant for  */
	public static final String BULK_DISPOSALS = "bulkDisposals";
	/**  Constant for  */
	public static final String OUTPUT_TERMS_COLUMNS = "outputTermsColumns";
	/**  Constant for  */
	public static final String SUCCESS = "success";
	/**  Constant for  */
	public static final String ENTITY_SEPARATOR = ";";
	/**  Constant for  */
	public static final String ATTRIBUTE_SEPARATOR = "|";
	/**  Constant for  */
	public static final String KEY_SEPARATOR = "*&*";
	/**  Constant for  */
	public static final String KEY_CODE = "key";
	/**  Constant for  */
	public static final String EXPORT_DATA_LIST = "exportDataList";
	/**  Constant for  */
	public static final String ENTITY_IDS_MAP = "entityIdsMap";
	/**  Constant for  */
	public static final String FINISH = "finish";
	/**  Constant for  */
	public static final String QUERY_REASUL_OBJECT_DATA_MAP = "queryReasultObjectDataMap";
	/**  Constant for  */
	public static final String DEFINE_VIEW_QUERY_REASULT_OBJECT_DATA_MAP = "defineViewQueryReasultObjectDataMap";
	/**  Constant for  */
	public static final String CONTAINTMENT_ASSOCIATION = "CONTAINTMENT";
	/**  Constant for  */
	public static final String MAIN_ENTITY_MAP = "mainEntityMap";
	/**  Constant for  */
	public static final String SPECIMENT_VIEW_ATTRIBUTE = "defaultViewAttribute";
	/**  Constant for  */
	public static final String PAGEOF_SPECIMEN_COLLECTION_REQUIREMENT_GROUP = "pageOfSpecimenCollectionRequirementGroup";
	/**  Constant for  */
	public static final String NO_MAIN_OBJECT_IN_QUERY = "noMainObjectInQuery";
	/**  Constant for  */
	public static final String QUERY_ALREADY_DELETED = "queryAlreadyDeleted";
	/**  Constant for  */
	public static final String BACK = "back";
	/**  Constant for  */
	public static final String RESTORE = "restore";
	/**  Constant for  */
	public static final String SELECTED_COLUMN_NAME_VALUE_BEAN_LIST = "selectedColumnNameValueBeanList";
	/**  Constant for  */
	public static final String TREE_DATA = "treeData";
	/**  Constant for  */
	public static final String ID_NODES_MAP = "idNodesMap";
	/**  Constant for  */
	public static final String DEFINE_RESULTS_VIEW = "DefineResultsView";
	/**  Constant for  */
	public static final String CURRENT_PAGE = "currentPage";
	/**  Constant for  */
	public static final String ADD_LIMITS = "AddLimits";
	/**  Constant for  */
	public static final int QUERY_INTERFACE_BIZLOGIC_ID = 67;
	/**  Constant for  */
	public static final String SQL = "SQL";
	/**  Constant for  */
	public static final String ID_COLUMN_ID = "ID_COLUMN_ID";
	/**  Constant for  */
	public static final String ID = "id";
	/**  Constant for  */
	public static final String SAVE_TREE_NODE_LIST = "rootOutputTreeNodeList";
	/**  Constant for  */
	public static final String ATTRIBUTE_COLUMN_NAME_MAP = "attributeColumnNameMap";
	/**  Constant for  */
	public static final String IS_SAVED_QUERY = "isSavedQuery";
	/**  Constant for  */
	public static final String TREE_ROOTS = "treeRoots";
	/**  Constant for  */
	public static final String NO_OF_TREES = "noOfTrees";
	/**  Constant for  */
	public static final String TREE_NODE_LIMIT_EXCEEDED_RECORDS = "treeNodeLimitExceededRecords";
	/**  Constant for  */
	public static final String VIEW_LIMITED_RECORDS = "viewLimitedRecords";
	/**  Constant for  */
	public static final String SAVE_GENERATED_SQL = "sql";
	/**  Constant for  */
	public static final String TREENO_ZERO = "zero";
	/**  Constant for  */
	public static final String COLUMN_NAMES = "columnNames";
	/**  Constant for  */
	public static final String INDEX = "index";
	/**  Constant for  */
	public static final String[] ATTRIBUTE_NAMES_FOR_TREENODE_LABEL = {"firstName", "lastName",
			"title", "name", "label", "shorttitle"};
	/**  Constant for  */
	public static final String COLUMN_NAME = "Column";
	/**  Constant for  */
	public static final String ON = " ON ";
	/**  Constant for  */
	public static final String OFF = "off";
	/**  Constant for  */
	public static final String PAGE_OF_QUERY_MODULE = "pageOfQueryModule";
	/**  Constant for  */
	public static final String RANDOM_NUMBER = "randomNumber";
	/**  Constant for  */
	public static final String IS_NOT_NULL = "is not null";
	/**  Constant for  */
	public static final String IS_NULL = "is null";
	/**  Constant for  */
	public static final String IN = "in";
	/**  Constant for  */
	public static final String Not_In = "Not In";
	/**  Constant for  */
	public static final String Equals = "Equals";
	/**  Constant for  */
	public static final String Not_Equals = "Not Equals";
	/**  Constant for  */
	public static final String Between = "Between";
	/**  Constant for  */
	public static final String Less_Than = "Less than";
	/**  Constant for  */
	public static final String Less_Than_Or_Equals = "Less than or Equal to";
	/**  Constant for  */
	public static final String Greater_Than = "Greater than";
	/**  Constant for  */
	public static final String Greater_Than_Or_Equals = "Greater than or Equal to";
	/**  Constant for  */
	public static final String Contains = "Contains";
	/**  Constant for  */
	public static final String STRATS_WITH = "Starts With";
	/**  Constant for  */
	public static final String ENDS_WITH = "Ends With";
	/**  Constant for  */
	public static final String NOT_BETWEEN = "Not Between";
	/**  Constant for  */
	public static final String INVALID_CONDITION_VALUES = "InvalidValues";
	/**  Constant for  */
	public static final String SAVE_QUERY_PAGE = "Save Query Page";
	/**  Constant for  */
	public static final String EXECUTE_QUERY_PAGE = "Execute Query Page";
	/**  Constant for  */
	public static final String FETCH_QUERY_ACTION = "FetchQuery.do";
	/**  Constant for  */
	public static final String EXECUTE_QUERY_ACTION = "ExecuteQueryAction.do";
	/**  Constant for  */
	public static final String EXECUTE_QUERY = "executeQuery";
	/**  Constant for  */
	public static final String SHOPPING_CART_FILE_NAME = "MyList.csv";
	/**  Constant for  */
	public static final String APPLICATION_DOWNLOAD = "application/download";
	/**  Constant for  */
	public static final String DOT_CSV = ".csv";
	/**  Constant for  */
	public static final String HTML_CONTENTS = "HTMLContents";
	/**  Constant for  */
	public static final String INPUT_APPLET_DATA = "inputAppletData";
	/**  Constant for  */
	public static final String SHOW_ALL = "showall";
	/**  Constant for  */
	public static final String SHOW_ALL_ATTRIBUTE = "Show all attributes";
	/**  Constant for  */
	public static final String SHOW_SELECTED_ATTRIBUTE = "Show selected attributes";
	/**  Constant for  */
	public static final String ADD_EDIT_PAGE = "Add Edit Page";
	/**  Constant for  */
	public static final String IS_QUERY_SAVED = "isQuerySaved";
	/**  Constant for  */
	public static final String CONDITIONLIST = "conditionList";
	/**  Constant for  */
	public static final String QUERY_SAVED = "querySaved";
	/**  Constant for  */
	public static final String DISPLAY_NAME_FOR_CONDITION = "_displayName";
	/**  Constant for  */
	public static final String SHOW_ALL_LINK = "showAllLink";
	/**  Constant for  */
	public static final String VIEW_ALL_RECORDS = "viewAllRecords";
	/**  Constant for  */
	public static final String POPUP_MESSAGE = "popupMessage";
	/**  Constant for  */
	public static final String ID_COLUMNS_MAP = "idColumnsMap";
	/**  Constant for  */
	public static final String TREE_NODE_ID = "nodeId";
	/**  Constant for  */
	public static final String HASHED_NODE_ID = "-1";
	/**  Constant for  */
	public static final String BUTTON_CLICKED = "buttonClicked";
	/**  Constant for  */
	public static final String UPDATE_SESSION_DATA = "updateSessionData";
	/**  Constant for  */
	public static final String EVENT_PARAMETERS_LIST = "eventParametersList";
	/**  Constant for  */
	public static final String VIEW = "view";
	/**  Constant for  */
	public static final String APPLET_SERVER_URL_PARAM_NAME = "serverURL";
	/**  Constant for  */
	public static final String TEMP_OUPUT_TREE_TABLE_NAME = "TEMP_OUTPUTTREE";
	/**  Constant for  */
	public static final String CREATE_TABLE = "Create table ";
	/**  Constant for  */
	public static final String AS = "as";
	/**  Constant for  */
	public static final String TREE_NODE_FONT = "<font color='#FF9BFF' face='Verdana'><i>";
	/**  Constant for  */
	public static final String TREE_NODE_FONT_CLOSE = "</i></font>";
	/**  Constant for  */
	public static final String ZERO_ID = "0";
	/**  Constant for  */
	public static final String NULL_ID = "NULL";
	/**  Constant for  */
	public static final String UNIQUE_ID_SEPARATOR = "UQ";
	/**  Constant for  */
	public static final String SELECT_DISTINCT = "select distinct ";
	/**  Constant for  */
	public static final String SELECT = "SELECT ";
	/**  Constant for  */
	public static final String FILE_TYPE = "file";
	/**  Constant for  */
	public static final String FROM = " from ";
	/**  Constant for  */
	public static final String WHERE = " where ";
	/**  Constant for  */
	public static final String LIKE = " LIKE ";
	/**  Constant for  */
	public static final String LEFT_JOIN = " LEFT JOIN ";
	/**  Constant for  */
	public static final String INNER_JOIN = " INNER JOIN ";
	/**  Constant for  */
	public static final String HASHED_OUT = "####";
	/**  Constant for  */
	public static final String DYNAMIC_UI_XML = "dynamicUI.xml";
	/**  Constant for  */
	public static final String DATE = "date";
	/**  Constant for  */
	public static final String DATE_FORMAT = "MM-dd-yyyy";
	/**  Constant for  */
	public static final String DEFINE_SEARCH_RULES = "Define Limits For";
	/**  Constant for  */
	public static final String CLASSES_PRESENT_IN_QUERY = "Objects Present In Query";
	/**  Constant for  */
	public static final String CLASS = "class";
	/**  Constant for  */
	public static final String ATTRIBUTE = "attribute";
	/**  Constant for  */
	public static final String FILE = "file";
	/**  Constant for  */
	public static final String MISSING_TWO_VALUES = "missingTwoValues";
	/**  Constant for  */
	public static final String METHOD_NAME = "method";
	/**  Constant for  */
	public static final String categorySearchForm = "categorySearchForm";
	/**  Constant for  */
	public static final int ADVANCE_QUERY_TABLES = 2;
	/**  Constant for  */
	public static final String DATE_TYPE = "Date";
	/**  Constant for  */
	public static final String INTEGER_TYPE = "Integer";
	/**  Constant for  */
	public static final String FLOAT_TYPE = "Float";
	/**  Constant for  */
	public static final String DOUBLE_TYPE = "Double";
	/**  Constant for  */
	public static final String LONG_TYPE = "Long";
	/**  Constant for  */
	public static final String SHORT_TYPE = "Short";
	/**  Constant for  */
	public static final String FIRST_NODE_ATTRIBUTES = "firstDropDown";
	/**  Constant for  */
	public static final String ARITHMETIC_OPERATORS = "secondDropDown";
	/**  Constant for  */
	public static final String SECOND_NODE_ATTRIBUTES = "thirdDropDown";
	/**  Constant for  */
	public static final String RELATIONAL_OPERATORS = "fourthDropDown";
	/**  Constant for  */
	public static final String TIME_INTERVALS_LIST = "timeIntervals";
	/**  Constant for  */
	public static final String ENTITY_LABEL_LIST = "entityList";

	/**  Constant for  */
	public static final String DefineSearchResultsViewAction = "/DefineSearchResultsView.do";

	/**  Constant for  */
	public static final Color BG_COLOR = new Color(0xf4f4f5);

	// Dagviewapplet constants
	/**  Constant for  */
	public static final String QUERY_OBJECT = "queryObject";
	/**  Constant for  */
	public static final String SESSION_ID = "session_id";
	/**  Constant for  */
	public static final String STR_TO_CREATE_QUERY_OBJ = "strToCreateQueryObject";
	/**  Constant for  */
	public static final String ENTITY_NAME = "entityName";
	/**  Constant for  */
	public static final String INIT_DATA = "initData";
	/**  Constant for  */
	public static final String ATTRIBUTES = "Attributes";
	/**  Constant for  */
	public static final String ATTRIBUTE_OPERATORS = "AttributeOperators";
	/**  Constant for  */
	public static final String FIRST_ATTR_VALUES = "FirstAttributeValues";
	/**  Constant for  */
	public static final String SECOND_ATTR_VALUES = "SecondAttributeValues";
	/**  Constant for  */
	public static final String SHOW_ENTITY_INFO = "showEntityInformation";
	/**  Constant for  */
	public static final String SRC_ENTITY = "srcEntity";
	/**  Constant for  */
	public static final String PATHS = "paths";
	/**  Constant for  */
	public static final String DEST_ENTITY = "destEntity";
	/**  Constant for  */
	public static final String ERROR_MESSAGE = "errorMessage";
	/**  Constant for  */
	public static final String SHOW_VALIDATION_MESSAGES = "showValidationMessages";
	/**  Constant for  */
	public static final String SHOW_RESULTS_PAGE = "showViewSearchResultsJsp";
	/**  Constant for  */
	public static final String ATTR_VALUES = "AttributeValues";
	/**  Constant for  */
	public static final String SHOW_ERROR_PAGE = "showErrorPage";
	/**  Constant for  */
	public static final String GET_DATA = "getData";
	/**  Constant for  */
	public static final String SET_DATA = "setData";
	/**  Constant for  */
	public static final String EMPTY_LIMIT_ERROR_MESSAGE = "<li><font color='red'>Please enter at least one condition to add a limit to limit set.</font></li>";
	/**  Constant for  */
	public static final String EMPTY_DAG_ERROR_MESSAGE = "<li><font color='red'>Limit set should contain at least one limit.</font></li>";
	/**  Constant for  */
	public static final String MULTIPLE_ROOTS_EXCEPTION = "<li><font color='red'>Expression graph should be a connected graph.</font></li>";
	/**  Constant for  */
	public static final String EDIT_LIMITS = "<li><font color='blue'>Limit succesfully edited.</font></li>";
	/**  Constant for  */
	public static final String DELETE_LIMITS = "<li><font color='blue'>Limit succesfully deleted.</font></li>";

	/**  Constant for  */
	public static final String MAXIMUM_TREE_NODE_LIMIT = "resultView.maximumTreeNodeLimit";
	//public static final String ATTRIBUTES = "Attributes";
	/**  Constant for  */
	public static final String SESSION_EXPIRY_WARNING_ADVANCE_TIME = "session.expiry.warning.advanceTime";

	/**  Constant for  */
	public static final String SearchCategory = "SearchCategory.do";
	/**  Constant for  */
	public static final String DefineSearchResultsViewJSPAction = "ViewSearchResultsJSPAction.do";
	/**  Constant for  */
	public static final String NAME = "name";
	/**  Constant for  */
	public static final String TREE_VIEW_FRAME = "treeViewFrame";
	/**  Constant for  */
	public static final String QUERY_TREE_VIEW_ACTION = "QueryTreeView.do";
	/**  Constant for  */
	public static final String QUERY_GRID_VIEW_ACTION = "QueryGridView.do";
	/**  Constant for  */
	public static final String GRID_DATA_VIEW_FRAME = "gridFrame";
	/**  Constant for  */
	public static final String PAGE_NUMBER = "pageNum";
	/**  Constant for  */
	public static final String TOTAL_RESULTS = "totalResults";
	/**  Constant for  */
	public static final String RESULTS_PER_PAGE = "numResultsPerPage";
	/**  Constant for  */
	public static final String SPREADSHEET_COLUMN_LIST = "spreadsheetColumnList";
	/**  Constant for  */
	public static final String PAGE_OF = "pageOf";

	/**  Constant for  */
	public static final String SPREADSHEET_EXPORT_ACTION = "SpreadsheetExport.do";
	/**  Constant for  */
	public static final int[] RESULT_PERPAGE_OPTIONS = {10, 50, 100, 500, 1000};
	/**  Constant for  */
	public static final String PAGE_OF_PARTICIPANT_CP_QUERY = "pageOfParticipantCPQuery";
	/**  Constant for  */
	public static final String CONFIGURE_GRID_VIEW_ACTION = "ConfigureGridView.do";
	/**  Constant for  */
	public static final String SAVE_QUERY_ACTION = "SaveQueryAction.do";

	/**  Constant for  */
	public static final int CHARACTERS_IN_ONE_LINE = 110;
	/**  Constant for  */
	public static final String SINGLE_QUOTE_ESCAPE_SEQUENCE = "&#096;";
	/**  Constant for  */
	public static final String ViewSearchResultsAction = "ViewSearchResultsAction.do";

	/**  Constant for  */
	public static final String QUERY_IDENTIFIER_NOT_VALID = "Query identifier is not valid.";
	/**  Constant for  */
	public static final String NO_RESULT_FOUND = "No result found.";
	/**  Constant for  */
	public static final String QUERY_ID = "queryId";
	/**  Constant for  */
	public static final String QUERY_COLUMN_NAME = "Column";

	/**  Constant for  */
	public static final String QUERY_OPENING_PARENTHESIS = "(";
	/**  Constant for  */
	public static final String QUERY_CLOSING_PARENTHESIS = ")";
	/**  Constant for  */
	public static final String QUERY_DOT = ".";
	/**  Constant for  */
	public static final String QUERY_UNDERSCORE = "_";
	/**  Constant for  */
	public static final String QUERY_COMMA = " ,";
	/**  Constant for  */
	public static final String QUERY_EQUALS = " = ";
	/**  Constant for  */
	public static final String QUERY_FILE = "file";
	/**  Constant for  */
	public static final String STR_TO_DATE = "STR_TO_DATE";

	/**  Constant for  */
	public static final String QUERY_FROM_XMLTABLE = " from xmltable";
	/**  Constant for  */
	public static final String QUERY_FOR = " for ";
	/**  Constant for  */
	public static final String QUERY_LET = " let ";
	/**  Constant for  */
	public static final String QUERY_ORDER_BY = " order by ";
	/**  Constant for  */
	public static final String QUERY_RETURN = " return ";

	/**  Constant for  */
	public static final char QUERY_DOLLAR = '$';
	/**  Constant for  */
	public static final String QUERY_XMLCOLUMN = "db2-fn:xmlcolumn";
	/**  Constant for  */
	public static final String QUERY_XMLDATA = "XMLDATA";
	/**  Constant for  */
	public static final String QUERY_AND = " and ";

	/**  Constant for  */
	public static final String TRUE = "true";
	/**  Constant for  */
	public static final String FALSE = "false";
	/**  Constant for  */
	public static final String Is_PAGING = "isPaging";
	/**  Constant for  */
	public static final String CONTENT_TYPE_TEXT = "text/html";

	/**
	 * 
	 * @param s
	 * @return
	 */
	public static final String getOracleTermString(String s)
	{
		return "extract(day from " + s + ")*86400 + extract(hour from " + s
				+ ")*3600 + extract(minute from " + s + ")*60 + extract(second from " + s + ")";
	}
	
	public static final String VERSION = "VERSION";

	//Constants related to Export functionality
	/**  Constant for  */
	public static final String SEARCH_RESULT = "SearchResult.csv";
	/**  Constant for  */
	public static final String ZIP_FILE_EXTENTION = ".zip";
	/**  Constant for  */
	public static final String CSV_FILE_EXTENTION = ".csv";
	/**  Constant for  */
	public static final String EXPORT_ZIP_NAME = "SearchResult.zip";
	/**  Constant for  */
	public static final String PRIMARY_KEY_TAG_NAME = "PRIMARY_KEY";
	/**  Constant for  */
	public static final String ID_COLUMN_NAME = "ID_COLUMN_NAME";
	/**  Constant for  */
	public static final String PRIMARY_KEY_ATTRIBUTE_SEPARATOR = "!~!~!";

	//<NAME>
	/**  Constant for  */
	public static final Object PERMISSIBLEVALUEFILTER = "PV_FILTER";
	/**  Constant for  */
	public static final int ADVANCE_QUERY_INTERFACE_ID = 24;
	/**  Constant for  */
	public static final String PUBLIC_QUERY_PROTECTION_GROUP = "Public_Query_Protection_Group";
	/**  Constant for  */
	public static final String MY_QUERIES = "MyQueries";

	/**  Constant for  */
	public static final String[] NUMBER = {"long", "double", "short", "integer", "float"};
	/**  Constant for  */
	public static final String NEWLINE = "\n";
	/**  Constant for  */
	public static final String DATATYPE_BOOLEAN = "boolean";
	/**  Constant for  */
	public static final String DATATYPE_NUMBER = "number";
	/**  Constant for  */
	public static final int MAX_PV_SIZE = 500;
	/**  Constant for  */
	public static final int MAX_SIZE = 500;

	/**  Constant for  */
	public static final int WORKFLOW_BIZLOGIC_ID = 101;
	/**  Constant for  */
	public static final String MY_QUERIES_FOR_WORKFLOW = "myQueriesForWorkFlow";
	/**  Constant for  */
	public static final String PUBLIC_QUERIES_FOR_WORKFLOW = "publicQueryForWorkFlow";
	/**  Constant for  */
	public static final String DISPLAY_QUERIES_IN_POPUP = "displayQueriesInPopup";
	/**  Constant for  */
	public static final String PAGE_OF_MY_QUERIES = "MyQueries";

	/**  Constant for  */
	public static final int WORKFLOW_FORM_ID = 101;

	/**  Constant for  */
	public static final String ELEMENT_ENTITY_GROUP = "entity-group";
	/**  Constant for  */
	public static final String ELEMENT_ENTITY = "entity";
	/**  Constant for  */
	public static final String ELEMENT_NAME = "name";
	/**  Constant for  */
	public static final String ELEMENT_ATTRIBUTE = "attribute";
	/**  Constant for  */
	public static final String ELEMENT_TAG = "tag";
	/**  Constant for  */
	public static final String ELEMENT_TAG_NAME = "tag-name";
	/**  Constant for  */
	public static final String ELEMENT_TAG_VALUE = "tag-value";
	/**  Constant for  */
	public static final String TAGGED_VALUE_NOT_SEARCHABLE = "NOT_SEARCHABLE";
	/**  Constant for  */
	public static final String TAGGED_VALUE_NOT_VIEWABLE = "NOT_VIEWABLE";
	/**  Constant for  */
	public static final String VI_IGNORE_PREDICATE = "VI_IGNORE_PREDICATE";
	/**  Constant for  */
	public static final String TAGGED_VALUE_PRIMARY_KEY = "PRIMARY_KEY";
	/**  Constant for  */
	public static final String TAGGED_VALUE_PV_FILTER = "PV_FILTER";
	/**  Constant for  */
	public static final String TAGGED_VALUE_VI_HIDDEN = "VI_HIDDEN";
	/**  Constant for  */
	public static final String CONTAINMENT_OBJECTS_MAP = "containmentObjectMap";
	/**  Constant for  */
	public static final String ENTITY_EXPRESSION_ID_MAP = "entityExpressionIdMap";

	//added by amit_doshi
	/**  Constant for  */
	public static final String PV_TREE_VECTOR = "PermissibleValueTreeVector";

	/**  Constant for  */
	public static final String PROPERTIESFILENAME = "vocab.properties";
	/**  Constant for  */
	public static final int SEARCH_PV_FROM_VOCAB_BILOGIC_ID = 12;
	/**  Constant for  */
	public static final String ATTRIBUTE_INTERFACE = "AttributeInterface";
	/**  Constant for  */
	public static final String ENTITY_INTERFACE = "EntityInterface";
	/**  Constant for  */
	public static final String VOCABULIRES = "Vocabulries";
	/**  Constant for  */
	public static final String ENUMRATED_ATTRIBUTE = "EnumratedAttribute";
	/**  Constant for  */
	public static final String COMPONENT_ID = "componentId";
	/**  Constant for  */
	public static final String NO_RESULT = "No results found";
	/**  Constant for  */
	public static final String MED_PV_HTML = "MEDPVHTML";

	/**  Constant for  */
	public static final String DEFINE_VIEW_MSG = "DefineView";
	/**  Constant for  */
	public static final String ENTITY_NOT_PRESENT = "not present";
	/**  Constant for  */
	public static final String ENTITY_PRESENT = "present";
	/**  Constant for  */
	public static final String MAIN_ENTITY_MSG = "Main Entity";
	/**  Constant for  */
	public static final String NOT_PRESENT_MSG = " Is Not Present In DAG";
	/**  Constant for  */
	public static final String MAIN_ENTITY_LIST = "mainEntityList";
	/**  Constant for  */
	public static final String SELECTED_CONCEPT_LIST = "SELECTED_CONCEPT_LIST";
	/**  Constant for  */
	public static final String TAGGED_VALUE_MAIN_ENTIY = "MAIN_ENTITY";
	/**  Constant for  */
	public static final String BASE_MAIN_ENTITY = "BASE_MAIN_ENTITY";
	/**  Constant for  */
	public static final String QUERY_NO_ROOTEXPRESSION="query.noRootExpression.message";
	/**  Constant for  */
	public static final String ENTITY_LIST = "entityList";
	/**  Constant for  */
	public static final String MAIN_ENTITY_EXPRESSIONS_MAP = "mainEntityExpressionsMap";
	/**  Constant for  */
	public static final String MAIN_EXPRESSION_TO_ADD_CONTAINMENTS = "expressionsToAddContainments";
	/**  Constant for  */
	public static final String ALL_ADD_LIMIT_EXPRESSIONS = "allLimitExpressionIds";
	/**  Constant for  */
	public static final String MAIN_EXPRESSIONS_ENTITY_EXP_ID_MAP = "mainExpEntityExpressionIdMap";
    
{'fraction_non_alphanumeric': 0.11047118395114221, 'fraction_numerical': 0.0023191991032430136, 'mean_word_length': 3.9129320167109762, 'pattern_counts': {'":': 2, '<': 52, '<?xml version=': 0, '>': 52, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 6}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2555703', 'n_tokens_mistral': 16336, 'n_tokens_neox': 15947, 'n_words': 4912}