Developer Tools


On your Appframe Web installation there should be a menu with various developer commands such as new app, edit app, article list, edit sidebar and edit site. These commands are typically located on the profile dropdown in the sidebar.

To get a basic app up and running all you have to do is to add and configure a data source (remember to add columns) and write markup that references that data source.

Keyboard shortcuts:

  • Alt + 1 toggle source list
  • Alt + W close current tab
  • Alt + Shift + P publish

There are code editors for html blocks, JavaScript and CSS. You use these to change the code. Typically in most apps, most of your code will reside in html blocks. In the source list to the left you can add, remove and rename html blocks, scripts, stylesheets, data sources and stored procedures to your app. The File menu allow you to bring up app various things, such as getting to the app settings (including app history).

Code Builder

A powerful tool, espescially if you are new to Appframe Web 2016 is the Code Builder. This is a tool that based on the specific data sources for your app can generate usable markup.

Database Manager

Database Manager allows you to test, inspect, create and modify: tables, views, triggers and stored procedures. You can also simply run queries.

Key bindings

We use Ace text editor and most default keyboard shortcuts still apply. On top of that there are predefined keyboard shortcuts:

  • Alt + 1 toggle source list
  • Alt + W close current tab
  • Alt + W refresh views
  • Alt + P apply permissions
  • Alt + M namespaces
  • Alt + I key bindings
  • Alt + N new query

You can also define key bindings to open new query, replace selection or execute based on your current selection. SQL Template engine is used under the hood. To open key bindings press Alt + I

Appframe365.DBManager is already included and you can use SQL fragments $definition$ and $select_top_n n=101$. Watch $definition$ usage in action here

Global key bindings using SQL Templates:

  • Alt + C generates column list for table or a view
  • Alt + S performs appframe search
  • Alt + U shows space used for a table selected
  • Ctrl + 2 generates select top 120 statement for table or view selected. includes all columns
  • Ctrl + 3 selects top 130 for table or a view selected. includes all columns
  • Ctrl + Alt + 2 generates select top 120 statement for table or a view slected. includes non system columns
  • Ctrl + Alt + 3 selects top 130 for table or a view selected. includes non system columns.
  • Ctrl + Alt + C generates column list for table or a view. sets column alias to one after "as" keyword
  • Ctrl + Alt + D generates object definition and opens it in a new query

DB Updater

DB Updater allows you generate SQL updates in development database and apply them in destination database. DB Updater is only available in Pims365-based Appframe installations so far.

How to target a database as update source?

In a source solution reach into /api/sqlupdate/listentome.sql for example This will generate SQL that you can run in your solution. After running generated script your database will be configures to listen to the source database as a compatibility source.

Site setup

Site setup is where global settings for your whole site are set up. For most appframe installations the changes you need to make here should be minimal. Changing the sidebar or mega menu is not done here. That is done with a edit sidebar or edit mega menu commannd.

Use Alt + 1 to toggle sourcelist.

Debug tools

  • /api/debug/status (tries to detect configuration errors and tests filestore)
  • /api/debug/cache (for cache control)
  • /api/debug/assemblies (lists all currently loaded assemblies grouped by category)
  • /api/debug/errors (a live error listener that will instantly get errors as they happen on the server)
  • /api/debug/profiler (a live profiler listener similar to the profiler app in winforms)
  • /api/debug/trace (a live trace listener similar to the output window when attached in visual studio)
  • /api/debug/razor (lists all compiled razor code - be articles, templates, html blocks or form panels)
  • /api/debug/placeholders (list of all available placeholders and their parameters)
  • /api/debug/routes (list of all published route handlers)