Support > Forums > OpenBots Studio > Syntax for RowFilter

Syntax for RowFilter

Martin McCloy

  • Reporter
  • Calender Icon January 28,2022 at 8:27 PM

I am working through the practice developer automations and have an issue with the syntax for RowFilter on Filter DataTable for the second example "Updating Employee Information" I have inserted the code as below which I tried to copy from the video example but it does not accept the Ok button. This section is at 14minutes into the video. RowFilter

"[Last Name]<>""+vLastName+""AND[First Name]<>""+vFirstName+"""

Appreciate your help

This forum has 172 topics, 459 replies, and was last updated 2 hours ago by Poornima Malv

Martin McCloy

  • Participant
  • Calender Icon February 03,2022 at 10:51 AM

Interesting. I used the project code and uploaded it to a new project. It appears that the keyboard used in the US as opposed to ....UK provides a different syntax output. The code below worked as per the project .... which appears slightly different that the code provided in the forum response.

"[Last Name] <> '" + vLastName + "' AND [First Name] <> '" + vFirstName + "'"

I was able to get "Remove Data Option" to work but found "Remove Index Row" results confusing as it removed the row number and ignored the form data input. However I can see other use cases where this can be useful.

Many thanks for your prompt response and assistance!!

Poornima Malviya

  • Participant
  • Calender Icon January 31,2022 at 9:20 AM


Thankyou for reaching out to us. The correct syntax for row filter command to filter datatable - "[Last Name] <> '" + vLastName + "' AND [First Name] <> '" + vFirstName + "'". In case the syntax is not clear, below there video, there is a project file which you can download and open it to view the exact syntax and understand the code as well. Please try it out and other alternative for row filter command would be to use - Remove Datarow command.

In the Remove data row command you need to provide - Input datatable name, Remove data option - Data/Index. 1)Remove Index option - Index - Please provide index number - It's the row number of datatable starting from 0. 2)Remove Data option - Data - Please provide necessary input data - Column names of excel sheet and the data variable entered during the form. For the second option , we have another field overwrite option, where the values can be connected logically using AND/OR which will remove based on the constraints matching.

Please try it out and let me know if you face any further issues.

You are not authorized to reply, please click here to login and add your reply to this topic.