Filter

For a better understanding on how the Filter function works in the context of connections, follow the exercise below.

1. Open your existing application or start a new one.
2. Reference the Jira connector to your app. For more information on how to do this, see the Referencing a Connector in your App page.
3. Add a Custom List display control to your app.
4. Add the issue_comment Jira connection object in the Data source property of the Custom List control by double-clicking on the issue_comment object.

5. In the Set parameters and conditions window, in the issueIdOrKey field, add the ID of the Jira issue you want to use for comment filtering.

6. In the *orderBy** field, add -created. This way, the comments will be filtered by creation date in a descending order.

📘

Tip:

If you hover your mouse over the orderBy title, a pop-up is displayed informing you what fields are supported.
To order items in a descending order, add - before created.

7. Bind the body object from the Jira.issue_comment to the Text property of the Header by double-clicking on the body object.

If you preview the app, the comments from your selected Jira issue will be displayed in the custom list in a descending order.

Adding conditions

Not all connector support adding a condition. If a connector does not support this, the Add condition button is disabled.
In the example below we will use conditions to filter emails by subject using the Microsoft Outlook 365 connection.

1. Open your existing application or start a new one.
2. Reference the Microsoft Outlook 365 connector to your app. For more information on how to do this, see the Referencing a Connector in your App page.
3. Add a Custom List display control to your app.
4. Add the Message object from the Microsoft Outlook 365 connection in the Data source property of the Custom List control by double-clicking on the Message object.

5. In the Set parameters and conditions window, click Add condition.

6. In the Select value field, select subject. By doing this, you will use the Filter function on the email subject.
7. In the Operator field, select like (LIKE).
8. In the Enter value field, type in the term you want to filter by. For example, type in issue to filter all emails with the term issue in the subject.

📘

Note:

If you add more than one condition, a new filter will be displayed. You can choose from this drop-down if ALL (AND) or just ANY (OR) of the conditions should be met.

9. Bind the bodyPreview object from the Message of the Microsoft Outlook 365 connection to the Text property of the Header.

If you preview the app, a preview of all emails containing issue in their subject is displayed in the custom list.

Lookup

For a better understanding on how the Lookup function works in the context of connections and data context, follow the exercises below.

1. Open your existing application or start a new one.
2. Reference the Jira connector to your app. For more information on how to do this, see the Referencing a Connector in your App page.
3. In the Data context property of the Main Page, add the following information using the Lookup function and the Jira.issue_comment connection object: =Lookup(Jira.issue_comment, "JIRA-12345"), where JIRA-12345 is the JIRA issue ID you want to use.

4. Add a Label display control to your app.
5. Add the body object of the issue_comment data context in the Text property of the Label control.

If you preview the app, the first comment of the selected Jira issue will be displayed in the Label control.