CREATING DATA ACTIONS

Creating Actions for Idea Detail Screen

In this learning content, we will create the actions needed for the idea detail screen in I Have an Idea mobile application. We will start by creating two actions for the idea information and the structures related to the ideas on the screen.

In this learning content, we will create the actions needed for the idea detail screen in the I Have an Idea mobile application.

Let's start by examining the screen.

When we look at the screen, we first view a structure containing idea information. In this structure, we see that there is information about the idea owner, information about the idea, and some numerical information about the idea.

In our second structure on the screen, we view the idea information and the comment information about the idea in the Tab element.

Two actions will be enough to fulfill our needs here. Our first action will be similar to the action we created in the learning content titled Select Action. Let's start by creating this action.

  1. Open the Custom Actions panel.
  2. Create and name a new Select Action.
  3. Select the Idea table by clicking the + icon in the Choose Source field.
  4. Select the Personnel table that is related to the Idea table from the screen that opens by clicking the link icon next to the Idea table.
  5. Do the same for the IdeaCategory table.
  6. Let's proceed by adding to the default selections through the Fields tab.
  7. In the Idea table, add ID first in order. Make the IdeaID naming in the Alias field.
  8. Then select CreatedDate, IdeaHolder, IdeaImage, IdeaImage, and Ideatitle respectively.

Now let's proceed by adding the columns in the Personnel table.

  1. Select the ID in the Personnel Table and give the PersonnelID nomenclature through the Alias field.
  2. Then select Fullname, PersonnelImage, and Title.
  3. Finally, add the ID from the Category table and name it CategoryID via Alias.
  4. On the Filter tab, select the Idea table and select the Id field.
  5. Leave the default Is Equal To selection selected. In the field on the right, select Symbol Picker SQL Parameter and type Id in the relevant field.
  6. Save the action by clicking the Create button.

This is how we created our first action. Let's create the related action in the Tab that lists the comment information.

  1. Create one more Select Action.
  2. Select and add the IdeaComment table.
  3. Select the Personnel table associated with the IdeaComment table from the screen that opens by clicking the link icon next to the IdeaComment table.
  4. In addition to the fields that come by default, add the ID of the IdeaComment table and name it as CommentId in the Alias field.
  5. Add CreatedDate, and PersonnelID columns in the IdeaComment table.
  6. Then add the Fullname field in the Personnel table.
  7. On the Filter tab, select the IdeaComment table and select the IdeaId field.
  8. Leave the default Is Equal To selection selected. In the field on the right, select Symbol Picker SQL Parameter and type IdeaID in the corresponding field.
  9. Now open the SortOrder tab, select the IdeaComment table, select CreatedDate as a column, and select Descending. This will sort the columns in the table from last added to first added.
  10. Click the Create button and create the action.

With these operations, we have prepared our actions.

In this learning content, we will create the actions needed for the idea detail screen in I Have an Idea mobile application. We will start by creating two actions for the idea information and the structures related to the ideas on the screen.

In this learning content, we will create the actions needed for the idea detail screen in the I Have an Idea mobile application.

Let's start by examining the screen.

When we look at the screen, we first view a structure containing idea information. In this structure, we see that there is information about the idea owner, information about the idea, and some numerical information about the idea.

In our second structure on the screen, we view the idea information and the comment information about the idea in the Tab element.

Two actions will be enough to fulfill our needs here. Our first action will be similar to the action we created in the learning content titled Select Action. Let's start by creating this action.

  1. Open the Custom Actions panel.
  2. Create and name a new Select Action.
  3. Select the Idea table by clicking the + icon in the Choose Source field.
  4. Select the Personnel table that is related to the Idea table from the screen that opens by clicking the link icon next to the Idea table.
  5. Do the same for the IdeaCategory table.
  6. Let's proceed by adding to the default selections through the Fields tab.
  7. In the Idea table, add ID first in order. Make the IdeaID naming in the Alias field.
  8. Then select CreatedDate, IdeaHolder, IdeaImage, IdeaImage, and Ideatitle respectively.

Now let's proceed by adding the columns in the Personnel table.

  1. Select the ID in the Personnel Table and give the PersonnelID nomenclature through the Alias field.
  2. Then select Fullname, PersonnelImage, and Title.
  3. Finally, add the ID from the Category table and name it CategoryID via Alias.
  4. On the Filter tab, select the Idea table and select the Id field.
  5. Leave the default Is Equal To selection selected. In the field on the right, select Symbol Picker SQL Parameter and type Id in the relevant field.
  6. Save the action by clicking the Create button.

This is how we created our first action. Let's create the related action in the Tab that lists the comment information.

  1. Create one more Select Action.
  2. Select and add the IdeaComment table.
  3. Select the Personnel table associated with the IdeaComment table from the screen that opens by clicking the link icon next to the IdeaComment table.
  4. In addition to the fields that come by default, add the ID of the IdeaComment table and name it as CommentId in the Alias field.
  5. Add CreatedDate, and PersonnelID columns in the IdeaComment table.
  6. Then add the Fullname field in the Personnel table.
  7. On the Filter tab, select the IdeaComment table and select the IdeaId field.
  8. Leave the default Is Equal To selection selected. In the field on the right, select Symbol Picker SQL Parameter and type IdeaID in the corresponding field.
  9. Now open the SortOrder tab, select the IdeaComment table, select CreatedDate as a column, and select Descending. This will sort the columns in the table from last added to first added.
  10. Click the Create button and create the action.

With these operations, we have prepared our actions.

Files

Yardımcı kaynaklar

Glossary