Indexing is a method for "looking up" a row in your app's data source, if that data source is a table from the database in your Afterpattern project. Indexing allows you to find a row where the Key column equals a certain value. If you want to be able to a row where any column, not just the Key column, equals a certain value, use querying.
To index into your database, you must first define a variable. This variable can come from many places, including:
Once you have a variable, you can use it to index into your database with an Expression Block using the index operator:
Notice that your Expression Block is defining a variable. Give this variable a semantic name. This variable represents the selected row from your database, so a good name for this variable could be "selected_X" (e.g. selected_client).
When you index into a database, you are searching through its key column:
As soon as your finish setting up your index Expression Block, you will have access to variables for each column in your database table. These new variables are labeled using the Expression Block variable + column name:
You can use these new variables for anything you can use a normal variable for, such as creating document templates.
Go from idea to launch in weeks.View services