Add/Delete

Add/Delete Query Task will be used by Designers when they want to add or delete rows in an app. Microsoft Excel also have the option to add or delete the rows however, Valorx Fusion will provide few enhanced option to add or delete the rows with different filter options.

To get started with this follow the below steps.

Open an Excel, click Start from Valorx Fusion Ribbon. Now, open an app from Connections list and click Tasks and then, select Add/Delete and click on New Add/Delete Task.

Add/Delete screen will open which will have two options under Type. Designer will select Add or Delete as per their requirement.

Let's get started with Add Task type. Follow the below procedure to add the rows using this Query Task.

Designers will select Add from Type and then, we can find Name , Map and Object Name of Map. Designers can select the Maps from the drop down.

Add Task query will have four types of properties. Below is the explanation.

• STATIC: Designers will use this when they want to add the rows at the bottom of the grid. Designers can provide the number of rows to be added in the Static Record Count and click Save.

• CELL REFERENCE: Designers can use this when they want to add rows without using the Design Studio each time. Designer should provide the name of top most cell of the map under Cell. Designer can just change the number of rows to be inserted in the cell in Runtime and hence, those rows will be added at the bottom of the grid. Example : In this example Designer has a map with name Masterorder and want to provide the cell reference. Hence, the format should be Masterorder!$A$1.

• NAMED RANGE REFERENCE: Designers can add a name to the cell and use this property. Right click on a cell and select Define Name and provide the name to the cell. Search for the name under Name Range Reference and select the name provided and click Save. Designer can just change the number of rows to be inserted in the cell in Runtime and hence, those rows will be added at the bottom of the grid. Example : Designer has named the cell as Record and in the drop down search for the Record and save it.

Difference between Cell Reference and Name Range Reference is when we add or delete rows in our Excel then, Designer may have to check and change the cell reference however, Name Range Reference will remain the same.

• RECORD COUNT: Record count is a tricky one however, we will make it simple for you. If we have two maps in one workbook and Designer wants to add same number of rows that matches the search result. Designer will select the map which needs to be matched and click save. Designer should provide the input in Workflow for this property. Example : Designer will be able to add the number of rows according to the results found on CustomerAccount, and this will change every time depending on the results found.

Let's have a look at Delete type. Delete type will have two task properties.

• Apply delete operation to selected record(s) only will allow the users to delete the record based on the user selection grid in runtime.

• Disable fast Delete by enabling this option Designers can disable the fast delete option.