LogoLogo
What's NewDeveloper CommunitySupportStatus
  • 🚀Get Started
    • What is JourneyApps Platform?
    • Tutorial: Build your First App
      • 1. Introduction
      • 2. Create a new App
      • 3. OXIDE IDE Overview
      • 4. Hello World app
      • 5. The Data Model
      • 6. View Components
      • 7. Queries and Data Sync
      • 8. Simple Navigation
      • 9. View Stack
      • 10. Input Validation
      • 11. View Parameters
      • 12. Data Manipulation
      • 13. Responsive Apps
      • 14. Styling
      • 15. Lists
      • 16. GPS Capturing
      • 17. Relationships
      • 18. Multiple User Roles
      • 19. Deployment and Users
      • 20. Version Control
      • 21. CSV and APIs
      • 22. Conclusion
    • JourneyApps Platform Fundamentals
      • Creating a New App
        • Git-enabled Apps
      • What are Views?
      • What is the Data Model?
      • JourneyApps Syntax Basics
      • Access the Database (DB)
        • Manipulate DB Objects
        • Query DB Objects
      • View Navigation
        • Deep Linking
      • CloudCode Overview
      • OXIDE (Online IDE)
  • 💻Build your App
    • JourneyApps Syntax
      • Syntax Basics
      • Access the DB
      • View Navigation
      • Async & Await
      • TypeScript Apps (Beta)
        • runtime-build package
        • TypeScript App Troubleshooting
      • What's New in V4
        • Updating to the V4 API
    • Configure your Data Model
      • What is the data model?
      • Reference: model
        • field
        • belongs-to
        • has-many
        • index
      • Data Rules
        • Data Buckets
        • Sync Rules - Limit data synced to devices
        • Data ACLs - Limit access to data
        • Real-world example for Data Rules
        • ❔FAQs
        • Migrate to Data Rules
      • App Indexes
      • Webhooks
    • UI Components
      • All UI Components
        • actionSheet
        • Attachments
        • button
        • button-group
        • capture-coordinates
          • marker
          • marker-query
        • capture-file
        • capture-photo
        • capture-signature
        • card
          • accent
          • action
        • columns
          • column
        • component
        • context-menu
          • divider
          • item
        • CSV
        • date-input
        • datetime-input
        • dialog
          • body
        • display-3d-model
          • 📖display-3d-model Guides
            • Guide 1: Initialize and layout a 3D model in a view
            • Guide 2: Control playback position
            • Guide 3: Troubleshooting controls
        • display-coordinates
        • display-file
        • display-image
        • display-photo
        • display-signature
        • heading
        • html
          • HTML Advanced Topics
          • ❔HTML FAQs
          • 📖Guide: HTML & JourneyApps iFrame Client
        • icons
        • info
        • info-table
          • row
        • journey.photos (capture multiple photos)
        • JourneyPrinter (print PDFs)
        • grid
          • cell
          • 📖grid Examples
        • list
          • list-item
            • accent
            • asset
            • pills
              • pill
            • action
        • multiple-choice-checklist
        • navigation (Navigation drawer)
          • general-section
            • item
          • section
            • item
              • item
          • ❔navigation FAQs
        • notification
        • object-dropdown
        • object-list
          • action
        • object-repeat
        • object-table
          • action
          • column
            • action
            • edit-boolean
            • edit-date
            • edit-datetime
            • edit-integer
            • edit-number
            • edit-select
            • edit-text
            • edit-time
            • edit-typeahead
              • action
            • header-action
          • column-group
          • empty-action
          • 📖object-table Guides
            • Actions
            • Cell callouts
            • Column groups
            • Columns
            • Controlled object-table
            • Controls
            • Copy & paste data
            • Edit cells
            • Filters
            • Frozen columns
            • Fullscreen object-table
            • Mode
            • State
            • Styles
        • optionList
        • PhotonSync (transfer data offline)
        • power-bi
          • 📖Guide: PowerBI Embedding
        • scan-barcode
        • shortcut
        • sidebar
        • single-choice-dropdown
        • single-choice-radio
        • template
        • text-input
        • time-input
        • toggle
        • view
      • JS/TS Events
      • Show / Hide UI Components
      • View Templates
      • XML Fields (Attributes)
        • align-content
        • align-controls
        • align-label
        • bind
        • clear-button-visibility
        • control-order
        • disabled
        • error-message
        • icon-position
        • id
        • hide-if
        • modifier-text
        • label
        • label-case
        • label-color
        • on-change
        • on-press
        • placeholder
        • required
        • show-if
    • JS / TS APIs
      • Attachment
      • Bluetooth (Beta)
      • Broadcast
      • component
      • CSV
      • DB
      • HardwareBarcode
      • journey
        • journey.config
        • journey.container
        • journey.device
        • journey.diagnostics
        • journey.dialog
        • journey.files
        • journey.hardware
        • journey.photos
        • journey.runtime
        • journey.sensors
        • journey.viewStack
      • JourneyPrinter
      • KeyboardBarcode
      • LocalDB
      • NFC
      • OnlineDB
      • PhotonSync
      • SerialPort
      • ShortcutManager
      • TCPSocket
      • user
    • Extend your App with Custom Code
      • App packages
        • App packages overview
        • PDF report package
        • TypeScript library & unit tests
        • Manage External Dependencies
      • Custom HTML
    • Style & Customize your App
      • Style & configure UI components
        • Overview
        • Understand extendable themes
        • Use themes on a view
        • Theme specific components on a view
        • Examples
        • Debugging
        • ❔FAQs
      • Change your App Font
      • Custom Branding
        • Custom Container Features
        • Special Requirements for iOS Containers
    • Integrate your App
      • Backend integrations with CloudCode
      • Barcode Scanning
        • Barcode Scanning using Keyboard Emulation
        • Hardware Barcode Scanning
        • scan-barcode
      • Bluetooth Low Energy (BLE)
      • Broadcast API
      • HTTP requests (Fetch API)
      • JourneyApps Print (Android)
      • Maps and navigation
      • NFC
      • Opening external links/apps
      • Serial Port
      • TCP Sockets
    • Design Intuitive Apps
      • UX Guidelines
      • Write Effective Copy
  • 📱App Features
    • RealWear® Voice Control
      • Automatic Voice Commands
        • Automatic Voice Commands - Advanced
      • Manual Voice Commands
    • App, Runtime and Container Updates
    • Batch Operations (App)
    • Call JS/TS Functions from XML
    • Capture GPS Locations
    • Push Notifications
    • Translations
    • XML Format Strings
    • Webhooks (External)
  • 🌐CloudCode
    • CloudCode Overview
    • Trigger a CloudCode Task
      • Trigger CC with a Schedule
      • Trigger CC via a Webhook
      • Trigger CC from an App
      • Trigger CC from Another Task
      • Trigger CC via HTTP
    • Attachments in CloudCode
    • Timezones
    • Advanced CloudCode Topics
      • Access Multiple DBs in CloudCode Tasks
      • Batch API (CloudCode)
      • CloudCode Dependencies
      • Configure HTTPS in CloudCode
      • Deployment environment variables
      • Local CloudCode Development
      • PDF Reports using CloudCode
      • Shared CloudCode Tasks
      • Translations in CloudCode
  • 📥Backend API
    • Introduction
    • API Reference
      • Retrieve All Objects
      • Query Objects
      • Sort Results
      • Limit and Skip
      • Count Objects
      • Create a New Object
      • Retrieve a Single Object
      • Update a Single Object
      • Delete a Single Object
      • Batch Operations (v4 API)
      • Oplog API
      • Retrieve the App Data Model
      • Manage App Users and Sessions
      • Field Representation
      • Error Responses
    • API Limits
    • Update to the V4 API
  • ⚙️Technical
    • Data Synchronization Priority
    • Device Diagnostics
    • JSON1 Query Engine
    • Improve App Performance
    • Security Measures
    • Supported Platforms
      • Web Container
      • Windows Installer
    • Domain Whitelist
  • 🖥️OXIDE
    • Get started with OXIDE
      • OXIDE Overview
      • Components of OXIDE
    • Configure Testing Deployments
    • Edit and Manage Files
      • How to Navigate to a Function
      • Manage External Dependencies
    • Create and Manage App Containers
    • Debugging & Troubleshooting
      • Common Troubleshooting Pointers
      • App Diagnostics Reports
      • Build Logs
    • OXIDE Workspaces
      • OXIDE Trees
  • ❕Deprecated Features
    • Deprecated Features and Components
Powered by GitBook
On this page
  • Queries
  • The init() and resume() Functions
  • A Simple Query
  • Filtering
  • Global Automatic Data Sync
  • Create Some Data
  • See Synchronized Data on Device
  1. Get Started
  2. Tutorial: Build your First App

7. Queries and Data Sync

Queries

In the previous section, we created open_punches as the variable which will contain all of our open punches. In order to populate that variable with data, we need to use a Query, which pulls data from the database in your app. Queries are defined in the JavaScript file of the relevant view. Before we define our query, a word about the init() and resume() functions in JavaScript:

The init() and resume() Functions

You'll notice that every View in JourneyApps has an init() function in its JavaScript file. This function is automatically called every time that the user opens the particular view (every time the view loads), and therefore its purpose is to allow you to initialize any data that you might require in the view. For example, setting default values for new objects that are created, or performing Queries are typical things that you might do in the init() function.

You'll also notice that every View in JourneyApps has a resume() function in its JavaScript file. This function is automatically called every time that the user goes back to the particular view using a dismiss or discard navigation action (more about that later). It is typically used for advanced business logic and workflow. It can also be used to ensure that users don't access stale data when they navigate back to a specific view by refreshing any data that is used in that view.

A Simple Query

In the Main View of your Punch List app, in your main.js file, you can create a query that pulls all punch list items from the database and stores them in the view variable open_punches as follows:

main.js
// This function is called when the app navigates to this view (using a link)
function init() {
    // initialize any data here that should be available when the view is shown
    view.open_punches = DB.item.all();
}
  • You can access your view variables and parameters in the JavaScript using the view. prefix. This allows you to differentiate between view variables and JS variables with the same name.

  • DB.item is automatically made available because we've defined the item Object Type in our Data Model.

Filtering

The query we've now added will show all punch list items in our <object-list> — however, we only want to show punches that have "Open" as their status (as defined in our Data Model). This can be done by filtering the query. To retrieve only the "Open" punches, change your code to the following:

main.js
// This function is called each time the view is loaded

function init() {
    // initialize any data here that should be available when the view is shown
    view.open_punches = DB.item.where('status = ?', 'Open');
}

The first argument of the where() function is a string specifying the condition of how we want to match objects, and the arguments thereafter are the values that we are actually matching against.

Global Automatic Data Sync

Now let's see that data sync in action. First, go to the Data Browser action next to the Workspace Tabs in OXIDE, and from the list of available deployments select testing.

This will open the select backend deployment a new tab/window. After the redirect, click on Item in the lefthand sidebar and you should see the following:

Create Some Data

So if you add some punch list items here, they will be synchronized to your mobile device. Add a couple of items by hitting Create New Item:

After creating some items like this, your list of Items should look like this:

See Synchronized Data on Device

Now, refresh your app but remember that the init() function, which contains your query, only runs when you open a view (when the view loads), so to run the query again, you need to re-open your Main View.

  • Close the app, don't just minimize it, and open it again. (Don't use the instructions to Leave App, you simply need to close the app and open it again)

You should now see the punch list items that you've entered on the web portal, that were automatically synchronized to your device:

In summary, you've seen how JourneyApps' built-in automatic data synchronization works, and how you can use a Query to pull data from the on device database and display it in your Views. Now let's continue to work on fleshing out the functionality of our Punch List app in the next sections.

Previous6. View ComponentsNext8. Simple Navigation

Last updated 2 years ago

Recall from the page that devices running your app automatically synchronize data from the cloud database to their local storage memory for offline access. This offline locally stored data is what is queried when you run a Query. (Please note the data is securely stored in a local database that is managed by the JourneyApps Container and is only accessible through the app).

The "Testing" App Backend is where you manage the data for your "Testing" environment (which is the environment that is used while you're developing apps in OXIDE — recall the and sections of the What is JourneyApps? page.)

🚀
Global Automatic Data Sync section of the What is JourneyApps?
Components of JourneyApps
Environments and Staged Deployment