Difference between revisions of "Details Attributes"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| Line 54: | Line 54: | ||
[[Attachments Section Attributes|Attachments Section]], [[Grid Section Attributes|Grid Section]] | [[Attachments Section Attributes|Attachments Section]], [[Grid Section Attributes|Grid Section]] | ||
| + | |||
| + | '''Notes''' | ||
| + | |||
| + | ==Filter== | ||
| + | The filter expression that restricts the records that will be included in the data | ||
| + | |||
| + | '''Supported by''' | ||
'''Notes''' | '''Notes''' | ||
| Line 155: | Line 162: | ||
'''Notes''' | '''Notes''' | ||
| + | |||
| + | ==Search field== | ||
| + | The search field for the section | ||
| + | |||
| + | '''Supported by''' | ||
| + | |||
| + | '''Notes''' | ||
| + | * See [[Instant Search]] | ||
| + | |||
| + | ==SQL statement== | ||
| + | The SQL statement used to populate a Virtual Table. Use {} macros in the WHERE condition to relate parent-->child sections and ORDER BY to order the display of records. This is native SQL for the target SQL database and may call stored procedures as well as SQL Select. | ||
| + | |||
| + | '''Supported by''' | ||
| + | |||
| + | '''Notes''' | ||
| + | * See [[Virtual Tables]] | ||
==Stretch width== | ==Stretch width== | ||
| Line 200: | Line 223: | ||
<pre>cVar = Lianja.getElementByID("page1.section1").type | <pre>cVar = Lianja.getElementByID("page1.section1").type | ||
cVar = Lianja.getElementByID("page1.section1.field1").type</pre> | cVar = Lianja.getElementByID("page1.section1.field1").type</pre> | ||
| + | |||
| + | ==Where condition== | ||
| + | The dynamic WHERE condition for a Virtual Table that restricts which records will be retrieved | ||
| + | |||
| + | '''Supported by''' | ||
| + | |||
| + | '''Notes''' | ||
| + | * See [[Virtual Tables]] | ||
| + | |||
[[Category:Attribute Categories]] | [[Category:Attribute Categories]] | ||
Revision as of 08:40, 19 May 2016
Under Construction
Contents
- 1 Auto layout percent
- 2 Caption
- 3 Command
- 4 Data source
- 5 Database
- 6 Double click to edit
- 7 Filter
- 8 Fixed height
- 9 Fixed width
- 10 Gadget type
- 11 Heading
- 12 Height
- 13 Inline
- 14 Margin
- 15 Meta types
- 16 Name
- 17 Readonly
- 18 Search field
- 19 SQL statement
- 20 Stretch width
- 21 Sortable
- 22 Table
- 23 Timelines enabled
- 24 Type
- 25 Where condition
Auto layout percent
Auto layout percentage of page size. If set to 0, then all sections on a page are resized to an equal height.
Supported by
Notes
Caption
The section caption displayed in the section header.
Supported by
Notes
- The Caption attribute can be queried or changed programmatically using Lianja.getElementByID("<item>").caption.
cVar = Lianja.getElementByID("page1.section1").caption
Command
A custom BROWSE or EDIT command to be executed in this section.
Supported by
Notes
- For example:
BROWSE NOEDIT FIELDS name,account,amount=items*itemcount:h"Total
Data source
The table and object column that this Image Strip is bound to, e.g. table.column.
Supported by
Notes
Database
The database for this section.
Supported by
Notes
Double click to edit
Double click grid rows to edit data (True | False)
Supported by
Attachments Section, Grid Section
Notes
Filter
The filter expression that restricts the records that will be included in the data
Supported by
Notes
Fixed height
For Sections, the Fixed height attribute is a checkbox (True | False) determining whether the height should be fixed or not. The section height in pixels is set in the Height attribute.
For Gadgets, the Fixed height attribute defines the height of the gadget in pixels. If Fixed height is 0 (default), the gadget is autosized to the height of the containing section.
Supported by
Notes
Fixed width
Defines the width of the gadget in pixels. If Fixed width is 0 (default), the gadget is autosized to the available width of the containing section.
Supported by
Notes
Gadget type
The type of gadget (readonly).
Supported by
Notes
Heading
The grid column heading.
Supported by
Notes
Height
The section height in pixels.
Supported by
Notes
- See also Fixed height.
- See also Page Appearance.
- For the Gadget, Form Section Field and Canvas Section Advanced Control Height attribute, see Geometry.
Inline
Render the gadget inline rather than it its own column (True | False).
Supported by
Notes
Margin
Margin size in pixels around the gadget.
Supported by
Notes
Meta types
A comma separated list of metatype names.
Supported by
Page, Sections, Gadgets, Form Section Fields, Canvas Section Advanced Controls, Grid Columns
Notes
- See MetaTypes.
Name
The name for this container or control.
Supported by
Page, Sections, Gadgets, Form Section Fields, Canvas Section Advanced Controls
Notes
- The Name attribute can be queried or changed programmatically using Lianja.getElementByID("<item>").id.
cVar = Lianja.getElementByID("page1").id
cVar = Lianja.getElementByID("page1.section1").id
cVar = Lianja.getElementByID("page1.section1.field1").id
Readonly
Section is readonly (True | False)
Supported by
Notes
Search field
The search field for the section
Supported by
Notes
- See Instant Search
SQL statement
The SQL statement used to populate a Virtual Table. Use {} macros in the WHERE condition to relate parent-->child sections and ORDER BY to order the display of records. This is native SQL for the target SQL database and may call stored procedures as well as SQL Select.
Supported by
Notes
- See Virtual Tables
Stretch width
Auto stretch the width of the gadget into the width of the section (True | False)
Supported by
Notes
Sortable
Section is sortable by clicking on the column headers (True | False)
Supported by
Attachments Section, Grid Section
Notes
Table
The table for this section.
Supported by
Notes
Timelines enabled
Enable database timelines for this section.
Supported by
Notes
Type
The type of container or control (readonly).
Supported by
Sections, Gadgets, Form Section Fields, Canvas Section Advanced Controls
Notes
- The Type attribute can be queried programmatically using Lianja.getElementByID("<item>").type.
cVar = Lianja.getElementByID("page1.section1").type
cVar = Lianja.getElementByID("page1.section1.field1").type
Where condition
The dynamic WHERE condition for a Virtual Table that restricts which records will be retrieved
Supported by
Notes
- See Virtual Tables
