ng at :-).
Joe
_
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser
Sent: Friday, May 15, 2015 1:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sort of OT: Help with an SQL query on the AR System database...
**
The same field id could
:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sort of OT: Help with an SQL query on the AR System database...
**
Hi
This subquery will list all the fields from all the forms You need to
include the schemaid
(A.FIELDID in (select B.FIELDID from FIELD_CHAR B where B.MAXLENGTH = 0 or
B.
The same field id could exist on multiple forms with different field
lengths, and as Jarl said, you need to include the schema id. Curious
though, do you need the subquery? How about:
select C.SCHEMAID, C.NAME, A.FIELDNAME, A.FIELDID, B.MAXLENGTH
from FIELD A, FIELD_CHAR B, ARSCHEMA C where
(A
Hi
This subquery will list all the fields from all the forms You need to
include the schemaid
(A.FIELDID in (select B.FIELDID from FIELD_CHAR B where B.MAXLENGTH = 0 or B
.MAXLENGTH >= 1000))
--
J
2015-05-15 19:13 GMT+02:00 Joe D'Souza :
> **
>
> I have developed this query for listing al
I have developed this query for listing all global fields (regular and
window specific) that are either of 0 length or input length above 1000.
select C.SCHEMAID, C.NAME, A.FIELDNAME, A.FIELDID, B.MAXLENGTH from FIELD A,
FIELD_CHAR B, ARSCHEMA C where
(A.SCHEMAID = C.SCHEMAID) and
(A.SCHEMA
5 matches
Mail list logo