Versions Compared

Old Version 9

changes.mady.by.user Sze Kun Yan

Saved on

compared with

New Version 10

changes.mady.by.user Sze Kun Yan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleAssuming you have a Joget DX 8 form that deals with budget entries and you want to validate whether a budget entry with the same year ('c_year') and name ('c_name') already exists while excluding the current budget entry (identified by its 'id'), you can use the following SQL query within the JDBC Validator (shown in Figure 2: Demo): 
Info
iconfalse

SELECT * FROM app_fd_budget WHERE c_year = {year} AND c_name = {name} AND id != {id}

Info
titleExplainationexplaination

The combination of these conditions ensures that the JDBC Validator checks for duplicate budget entries with the same year and name, excluding the current budget entry being edited (identified by its 'id') from the validation process. 

...