From wiki.ginstr.com
Jump to: navigation, search

Dropdown database multiselect text

Widget is represented by a label and dropdown below label. Widget has option to select multiple items in dropdown. Data that is saved to database is of datatype "text". If multiple options are selected and saved, they are separated with ,

Widget id, ${gbamID}:

dropdownDatabaseMultiselectText

Back to GBAM widgets table

Datatypes

Value is stored from widget to database as text datatype.

Predefined user data

PreLoaded

Properties panel

User will configure this data in properties panels of selected widget:

GENERAL
VALIDATIONS
    <columnText required="true|false"></columnText>
ACTION
  • "dropdown items", ${dropdownItemsList} = ${<item>${dropdownListItem}</item>} - repeats to how many dropdown items were entered by user
  • ${dropdownListItem} - single "dropdown items" item entered by user
ACTION MESSAGES
  • "no data", if $defaultApp resource ${$dropDownNoData}, if we override then it has to be formed {@string/${widgetID}NoData} - message which appears when user clicks on dropdown and no data is loaded into dropdown
  • "no selection text", if $defaultApp resource ${$dropDownZeroItem}, if we override then it has to be formed ${@string/${widgetID}ZeroItem} - text which appears when dropdown is initially loaded and nothing is selected in it
  • "selected" if $defaultApp resource ${$selectedItem}, if we override then it has to be formed {@string/${widgetID}Selected} - text which appears in multiselect dropdown "display item"
DATABASE
  • "is part of database", checkbox option by default is set as checked. When checked database column is created for this widget.
  • "additional ginstr web column settings":
  • "align text", radio button options with values: "left", "middle", "right", add to configuration.xml:
<columnText>
    <horizontalAlignment>left|center|right</horizontalAlignment>
</columnText>
  • "list of allowed values" array with list of allowed values, add to configuration.xml:
<columnText>
  <valuesList>
    <value>val1</value>
    <value>val2</value>
  </valuesList>
</columnText>
  • "pattern", add to configuration.xml:
<columnText>
    <pattern errorMessage="invalidTextTableValue">[0-9A-Z]{3}</pattern>
</columnText>
  • "related unique columns", add to configuration.xml:
<columnText>
    <uniqueInsideList>
        <reference>
          <table>refTableId1</table>
          <column>refColumnField1</column>
        </reference>
        <reference>
          <table>refTableId2</table>
          <column>refColumnField2</column>
        </reference>
    </uniqueInsideList>
</columnText>

Code snippets

GBAM Code Variables

Variables which are used in code snippet below but not defined in user modifiable inputs.

Common widget code

<com.ginstr.widgets.GnTextView
	android:id="@+id/${widgetID}_label"
	android:layout_width="match_parent"
	android:layout_height="wrap_content"
	android:text="@string/${widgetID}"
	gn:style="@style/dropdownDatabaseMultiselectText_label"/>

<com.ginstr.widgets.GnDropDownSelection
	android:id="@+id/${widgetID}_input"
	android:layout_width="match_parent"
	android:layout_height="wrap_content"
	gn:s_sourceType="database"
	gn:dataType="text"
	gn:s_ZeroItemText="@string/${$dropDownZeroItem}"
	gn:s_SelectedItemText="@string/${$selectedItem}"
	gn:msg_nodata="@string/${$dropDownNoData}" 
	gn:act_beforeLoad="[gn:act_rawQueryToWidgets]|[${widgetID},${widgetID}_input;${widgetID};@+id/${widgetID}_input]"
	gn:style="@style/dropdownDatabaseMultiselectText_input"/>


strings.xml

Lines to be added for each language.

<string name="${widgetID}">${widgetLabel}</string>
<string name="${widgetID}_table">${widgetLabel}</string>
<string name="${widgetID}_column">${widgetLabel}</string>

queries.xml

Add to queries.xml :

    <query
        id="${widgetID}_input" 
        columns="${screenLabelGenerated}_${widgetLabelGenerated}"/>

configuration.xml

Table configuration for add to configuration.xml node <configuration>:

<tables>
    <table id="${widgetID}" name="${widgetID}_table">
        <columnText id="${widgetID}" name="${widgetID}_column" />
    </table>
</tables>

data for configuration.xml

Based on widgets that are grouped into questionnaire predefinedAppData will be generated in configuration.xml.

  • ${numberIncrement} - Starts from 1. Take biggest row id and increment by 1.
  • ${dropdownItemsListRows} - based on user entered data into "dropdown items", repeat for each user entered item:
<row id="${numberIncrement}">
    <column id="${widgetID}">${dropdownListItem}</column>			
</row>
  • ${dropdownListItem} user entered text should be transformed if contains |. | is reserved character in case this character is used entire expression needs to be quoted i.e. "One|Two"

Data configuration for add to configuration.xml node <configuration>:

<predefinedAppData>
	<table id="${widgetID}">
		${dropdownItemsListRows}
	</table>
</predefinedAppData>