From/Where Clause Syntax Examples - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 23.1
License

From Clause

hsi.itemdata, hsi.keyxitem113, hsi.keytable113

Where Clause

hsi.itemdata.itemnum= ki.itemnum 
and hsi.keyxitem113.keywordnum= hsi.keytable113.keywordnum
and substring(hsi.keytable113.keyvaluechar,1,1)= 'A’ 
and hsi.itemdata.itemtypenum = 101 and hsi.itemdata.status + 0 = 0