jeevanm7 Member since 2019 7 posts
Posted: November 4, 2019
Last activity: December 11, 2019

How to search if a value exists in table

Hi Guys,

I am trying to delete records via GUI. I have a text input in my section mapped with property (.EID) which intakes employee ID (for example 1) and when i click a button 'delete' that particular record should be deleted from DB. I have written an activity that successfully deletes. But I want to display a message if the entered employee ID is not present in the table. For example if I have already deleted record 1 and the user again tries to delete record 1 it should display a amessage saying "employee doesnt exist, please enter existing ID". I have used obj-open->obj-delete->commit to delete the records. Please help me how to achieve this.

Help is very much appreciated!!

***Moderator Edit-Vidyaranjan: Updated Platform Capability***

Pega Platform Data Integration
Share this page LinkedIn