Knowledge Base > Page Editor > Actions > Remote DB Control > User Database

Change Remote condition action will allow the user to filter or sort the database page temporarily. It implies that If user executes this action with specific Order & Where clause then the database page will be filtered or sorted accordingly. To know more about the action please follow the steps given below:

Note:

1.If there is any pre-defined order/where format set to the database page then it will convert/overwrite to the order/where clause which is define in the Change remote condition action.

2.Changes/effect of change condition action will remain until the user does not navigate to any other page.

Step 1: Follow the Steps below to create a List View page with a UI element.

a.Create a List View Page.

b.Uncheck Hide Tool Bar (Top).

c.Click on Edit (0) button corresponding to "UI elements" to add UI Part to Toolbar.

mobilous_appexe_npe_myproject_Actions_localDBcontrol_changecondition_first

Step 2: Drag and Drop RoundButton UI Part and set title as "Change Condition". Add action to the RoundButton by clicking on Edit(0). To know more about the Functions click here .

mobilous_appexe_npe_myproject_Actions_remoteDBcontrol_changeremotecondition_second

Step 3: Click on "Add" button on the Actions window to add an action.To know more about actions click here.

mobilous_appexe_npe_myproject_Actions

Step 4: Select the Actions Category as “Remote DB Control”.

mobilous_appexe_npe_myproject_Actions_category1

Step 5: Click on the "Remote DB Control" and then click on “Change Remote Condition” action.

mobilous_appexe_npe_myproject_Actions_RemoteDBcontrol_changeremotecondition_setaction

Click here to know about "Doc" Button.

Step 6: Enter Action Parameters:-

Parameter	Description
Page Name	Select the Target Page name.
Group List	Specify the “Group” number here. Usage example: If user is using DB Table View Page with more than one groups in a page, then user needs to specify the index of that group on which this action will be applied. The default value of group is 0. If this is used it means it will be applied on the first group by default.
Cell List	User can specify the Cell number of the specified group.
Target UI Part	Target UI Parts within that cell will be displayed in the drop down.
Group	Specify the “Group” number here. Usage example: if user is using DB Table View Page with more than one group in a page, then user needs to specify the index of that group on which this action will be applied. The default value of group is 0. If this is used it means it will be applied on the first group by default.
Where	Enter the where parameter when user wants to update a specific record. The syntax of where condition is same as SQL i.e. Columnname='data'. Column name is the name of the table field from the database and data is any entry which is mentioned in that field of database. Example id='7'. Click here for more Examples.
Order	Enter the Order condition to sort the list of Records in ascending or descending order.

mobilous_appexe_npe_myproject_Actions_localDBcontrol_changecondition_setparameters

Note: Above a DB List Page is used, here only Page Name and Where condition needs to be given. Click here to know more.

Step 7: Click on "OK" button if the user doesn't want to add more actions.

mobilous_appexe_npe_myproject_Actions_localDBcontrol_changeremotecondition_apply

Step 8: Change Condition is applied.

mobilous_appexe_npe_myproject_Actions_remoteDBcontrol_changeremotecondition_third

Use case of change remote condition action:

This action can be used on Search bar to change the "where" and "order" condition of any Remote DB List, Remote Record type pages. Click here to know.

Note: Change Condition can be applied only on the same Page.