Check If Record Exists

This action determines if a record exists in a database table.

Select a database

If Profound.js has been configured for multiple connections, this allows you to select the appropriate database connection for this step. If a database is not selected, the default connection will be used.

Which table to check?

Select a database table to search records in.

Selection criteria expression

Provide a WHERE-clause expression to identify the records. Use the dropdown to create the expression without having to write code manually.

Question marks (?) in the expression are used to identify dynamic values, which are also referred to as selection parameter values. For each question mark, you will be prompted to provide a selection parameter value, where you can select or manually type dynamic content.

Not Condition?

Check this box if you want to check if the record does NOT exist.

In Designer

The Record Exists plugin will display as a set of brackets in the designer. The steps that you want to run if the record exists (or doesn't exist if you use the Not Condition) can be dragged inside the brackets or the brackets can be dragged around the other steps.

As you drag the bracket you will see a dotted green bracket appear at areas where the bracket can be dropped.