Versions Compared

Old Version 5

changes.mady.by.user Stefan Franz

Saved on

compared with

New Version 6

changes.mady.by.user Stefan Franz

Saved on

Key

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

...

Code Block
SELECT p.*, pv.FIELDSTRINGVALUE as 'Path'
  FROM [PROTOCOL] p
  inner join PROTKEY_VALUES pv on p.RECORDID = pv.RECORDID
  where pv.FIELDID = 'path' 
  and p.COMMANDCATEGORY = 'read'

...