citrusframework / citrusframework/citrus

Can't use variables in SQL validate action column

Open
#308 0 comments 0 reactions 0 assignees View on GitHub
enhancement prio-low
Dominant language
Java
Stars
485
Forks
155
Avg merge
4d 22h
Merged PRs (30d)
6

Description

### Version

Citrus `2.7.2`

### Problem

The `validation` section in an SQL action has the attributes `column` and `value`. You can use Citrus variables in the `value` attribute but not in the `column` attribute.

Referring to column names via variables is useful since they can be named more clearly this way. SQL column names don't always reflect the name used in the application domain, e.g. an XML field `lastName` may be stored in a DB as `name_2`. To make the connection clear for the test you can name the corresponding variables `${lastName}` and `${SqlColLastName}`.

### Example

```xml


...


```

### Solution

Allow dynamic variables in `validation`'s `column` attribute.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.