(Created page with "<div style="float:right; clear:both; margin-left:0.5em;">__TOC__</div> <span STYLE="font-size: xx-large"><code>gn:act_filterDistinctRows</code></span> Category:Action_Librar...") |
m (formatting) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
[[Category:Action_Library]] | [[Category:Action_Library]] | ||
| − | ;Description: Action | + | ;Description: Action used to remove duplicate rows from [[target]] |
;Action returns: void | ;Action returns: void | ||
==Action signatures== | ==Action signatures== | ||
| − | :;<code>[gn: | + | :;<code>[gn:act_filterDistinctRows]|[target;columns{n}]</code> |
:{| class="wikitable sortable" style="font-size: 85%; text-align: left;" | :{| class="wikitable sortable" style="font-size: 85%; text-align: left;" | ||
| Line 15: | Line 15: | ||
|- | |- | ||
| <code>[[target]]</code> | | <code>[[target]]</code> | ||
| − | | [[target]] | + | | [[target]] from where duplicate rows will be removed |
* Valid [[target|targets]]: | * Valid [[target|targets]]: | ||
| − | :*<code>[[Datatypes# | + | :*<code>[[Datatypes#rows|rows]]</code> |
| + | :*<code>[[Datatypes#rowsColumn|rowsColumn]]</code> | ||
| + | |- | ||
| + | | <code>column</code>{n} | ||
| + | | used if [[target]] is [[Datatypes#rows|rows]] to filter rows only by defined column names | ||
| + | * Can be: | ||
| + | :*<code>hardcoded</code> | ||
|} | |} | ||
====Example==== | ====Example==== | ||
| − | |||
=====initial value===== | =====initial value===== | ||
| − | : | + | ::<code>@variable/onlyDistinctDeviceTypes</code> = <code>John,John,Mark,Mark,John</code> |
| − | :<code>@variable/ | ||
=====variables.xml===== | =====variables.xml===== | ||
<syntaxhighlight lang="xml"> | <syntaxhighlight lang="xml"> | ||
| − | <variable id=" | + | <variable id="onlyDistinctDeviceTypes" type="rowsColumn" defaultValue="" columnType="pointer" /> |
</syntaxhighlight> | </syntaxhighlight> | ||
| − | |||
=====screen.xml===== | =====screen.xml===== | ||
| Line 39: | Line 42: | ||
android:layout_height="wrap_content" | android:layout_height="wrap_content" | ||
android:visibility="gone" | android:visibility="gone" | ||
| − | gn:act_set="[gn: | + | gn:act_set="[gn:act_filterDistinctRows]|[@variable/onlyDistinctDeviceTypes]" /> |
</syntaxhighlight> | </syntaxhighlight> | ||
=====after action execution===== | =====after action execution===== | ||
| − | :<code>@variable/ | + | ::<code>@variable/onlyDistinctDeviceTypes</code> = <code>John,Mark</code> |
<hr> | <hr> | ||
Latest revision as of 18:23, 24 January 2018
gn:act_filterDistinctRows
- Description
- Action used to remove duplicate rows from target
- Action returns
- void
Action signatures
[gn:act_filterDistinctRows]|[target;columns{n}]
Parameter Description targettarget from where duplicate rows will be removed - Valid targets:
column{n}used if target is rows to filter rows only by defined column names - Can be:
hardcoded
Example
initial value
@variable/onlyDistinctDeviceTypes=John,John,Mark,Mark,John
variables.xml
<variable id="onlyDistinctDeviceTypes" type="rowsColumn" defaultValue="" columnType="pointer" />
screen.xml
<FrameLayout
android:id="@+id/exampleFrame"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:visibility="gone"
gn:act_set="[gn:act_filterDistinctRows]|[@variable/onlyDistinctDeviceTypes]" />
after action execution
@variable/onlyDistinctDeviceTypes=John,Mark
