SQLite Database Repeater Widget

Databases are a critical part of most Web and WebApps. They have the ability to store and retrieve information. Thorium Builder's Database Widgets are designed to work easily with Web Project Databases and WebApps Project Databases.
Note that if your project is not selected as a Web Project With Database or WebApp With Database , as shown above, you will see no widgets listed in the Database Widget Area. 

Database Repeater is a Widget that will display a list of records filtered and sorted according to the settings you will apply.  

...

When first dropped into the Page Editor, the Database Repeater Widget appears as above.

Advanced Property Settings (General Tab)

...
Data Source Filter

The category of data that will be loaded. It can be All Categories.

Data Hierarchy

The Level of records you want to display; it can be one of these settings:

  • 1. All Hierarchy (default) : all the records for the selected category.

  • 2. Root Records Only: Only the records at the first level of the category will be displayed.

  • 3. Show Only Current record Child: when you display a detail page for a record, then if you choose this option, only the child records of the current records will be displayed.

    • a. First, you must display a detail page for a record.

    • b. Add the Database Displayer Record to the page.

    • c. Add any Text or images into the Database Displayer Record.

    • d. Select this option.

    • e. Only the child records of the current records will be displayed.

...
Sorted By

The default sorting (Older, recents, Alphabetical or Event Date)

Detail Page

The page that will be loaded when the user will click on a record.

Template

Choose here the way you want to display the records: it can be a DataList (Text Only) , a Media List View (Text + Images) or a Collection (Grid of Images with text).

See the example below that illustrates the three display modes:

...

DATA LIST VIEW

...

MEDIA LIST VIEW

...

COLLECTION VIEW

First Field
...

The first Field Displayed for each line.
The dropdown selector allows you to choose what is displayed.
In the above example, the custom fields have been set to be read from the wikipedia website.

Second Field

The second Field Displayed for each line.
The dropdown selector allows you to choose what is displayed.

Third Field

The third Field Displayed for each line.
The dropdown selector allows you to choose what is displayed.

Show Badge

When this button is selected, a Badge Widget will be shown.

Advanced Tab

...
Search Bar

f the Search Bar option is selected, a search bar will be displayed at the top of the Database Displayer Repeater (Not that all the searches are Full-Text based).

Place Holder

The short help text prompt that is displayed within the search box for the user. Generally, “Search” is used.

Cancel Button Text

The text of the cancel button of the search box. 

Row Limit

For Large databases, it is better to limit the number of records that are initially loaded, especially when you display images. When you use that option, then it is recommended to enable the Infinite scroll option as well, so the records will be progressively loaded by packets of n records when the user will scroll to the end of the page.

Infinite Scroll

When the user scrolls to the end of the page, this option activates the load of another packet of records.

Enabled at distance

The distance from the bottom of the page in pixels that will trigger the load of a new packet of records (Default to 50px, the recommended value).

Copyright©  Nymphide Lab 2020 - All Rights Reserved 

...