| ElementParams |
| struct |
| ALLRANDOM |
0
|
| BOUNDTOFACETNAVCONTROL |
0
|
| DATALIST |
[empty string]
|
| DEFAULTSORTCOLUMN |
electionDate|asc
|
| ELEMENTVERSION |
1
|
| FIELDPARAMS |
| struct |
| 524497 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DLGTYPE |
customelement
|
| FIELDNAME |
FIC_name
|
| FIELDNAMENOFIC |
name
|
| FIELDPERMISSION |
2
|
| ID |
524497
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
text
|
| LABEL |
Name
|
| MAXLENGTH |
255
|
| MSG |
Please enter a valid Name value
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
Yes
|
| SIZE |
20
|
| TABID |
524495
|
| USESECURITY |
0
|
| USEUDEF |
0
|
|
| 524498 |
| struct |
| AUTOFOCUS |
0
|
| COLS |
40
|
| DLGTYPE |
customelement
|
| FIELDNAME |
FIC_generalInfo
|
| FIELDNAMENOFIC |
generalInfo
|
| FIELDPERMISSION |
2
|
| ID |
524498
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
large_textarea
|
| LABEL |
General Information/Description
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| ROWS |
8
|
| TABID |
524495
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| WRAP |
virtual
|
|
| 524499 |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
[empty string]
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FIELDNAME |
FIC_type
|
| FIELDNAMENOFIC |
type
|
| FIELDPERMISSION |
2
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
524499
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
select
|
| LABEL |
Election type
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
[empty string]
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
0
|
| SHARED |
0
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
[empty string]
|
| VALLIST |
Presidential Preference Primary - (Federal Election),General Election - (Federal Election),Primary Election - (Federal Election),General Municipal Election - (City-Wide Local Election),Primary Municipal Election - (City-Wide Local Election),Special Election - (Federal Election),Special Election - (City-Wide Local Election),Special Election
|
| VALSOURCE |
valList
|
| VALUEFIELDID |
[empty string]
|
|
| 524500 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_filingBegins
|
| FIELDNAMENOFIC |
filingBegins
|
| FIELDPERMISSION |
2
|
| ID |
524500
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
Candidate filing begins
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 524501 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_filingEnds
|
| FIELDNAMENOFIC |
filingEnds
|
| FIELDPERMISSION |
2
|
| ID |
524501
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
Candidate filing Ends
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 524502 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_absenteeBegins
|
| FIELDNAMENOFIC |
absenteeBegins
|
| FIELDPERMISSION |
2
|
| ID |
524502
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
Application-based absentee voting begins
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 524503 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_lastDayToRegister
|
| FIELDNAMENOFIC |
lastDayToRegister
|
| FIELDPERMISSION |
2
|
| ID |
524503
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
Last day to register to vote in this election
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 524504 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), "mm/dd/yyyy")
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_lastDayToRequestAbsentee
|
| FIELDNAMENOFIC |
lastDayToRequestAbsentee
|
| FIELDPERMISSION |
2
|
| ID |
524504
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
Last day to request an application-based absentee ballot by mail
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 524505 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_lastDayToVoteAbsentee
|
| FIELDNAMENOFIC |
lastDayToVoteAbsentee
|
| FIELDPERMISSION |
2
|
| ID |
524505
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
Last day to vote absentee in person (both types)
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 524506 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_electionDate
|
| FIELDNAMENOFIC |
electionDate
|
| FIELDPERMISSION |
2
|
| ID |
524506
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
Election date
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 524507 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_listOfCandidates
|
| FIELDNAMENOFIC |
listOfCandidates
|
| FIELDPERMISSION |
2
|
| ID |
524507
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
List of Candidates
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 524508 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_sampleBallot
|
| FIELDNAMENOFIC |
sampleBallot
|
| FIELDPERMISSION |
2
|
| ID |
524508
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Sample Ballot Document
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 524509 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_electionResults
|
| FIELDNAMENOFIC |
electionResults
|
| FIELDPERMISSION |
2
|
| ID |
524509
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Election Results Document
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 524510 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| EMAIL |
0
|
| FIELDNAME |
FIC_extraDocument1
|
| FIELDNAMENOFIC |
extraDocument1
|
| FIELDPERMISSION |
2
|
| ID |
524510
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Extra Document 1
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHARED |
0
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 524511 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_extraDocument2
|
| FIELDNAMENOFIC |
extraDocument2
|
| FIELDPERMISSION |
2
|
| ID |
524511
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Extra Document 2
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 525071 |
| struct |
| AUTOFOCUS |
0
|
| DLGTYPE |
customelement
|
| FIELDNAME |
FIC_Line_Break
|
| FIELDNAMENOFIC |
Line_Break
|
| FIELDPERMISSION |
2
|
| ID |
525071
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
linebreak
|
| LABEL |
Line Break
|
| LINEBREAKS |
1
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| TABID |
524496
|
| USESECURITY |
0
|
|
| 525072 |
| struct |
| AUTOFOCUS |
0
|
| DLGTYPE |
customelement
|
| FIELDNAME |
FIC_Line_Break_1
|
| FIELDNAMENOFIC |
Line_Break_1
|
| FIELDPERMISSION |
2
|
| ID |
525072
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
linebreak
|
| LABEL |
Line Break
|
| LINEBREAKS |
1
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| TABID |
524496
|
| USESECURITY |
0
|
|
| 525073 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_electionResults2
|
| FIELDNAMENOFIC |
electionResults2
|
| FIELDPERMISSION |
2
|
| ID |
525073
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Election Results 2
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 525074 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_electionResults3
|
| FIELDNAMENOFIC |
electionResults3
|
| FIELDPERMISSION |
2
|
| ID |
525074
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Election Results 3
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 525075 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_electionResults4
|
| FIELDNAMENOFIC |
electionResults4
|
| FIELDPERMISSION |
2
|
| ID |
525075
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Election Results 4
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 525076 |
| struct |
| AUTOFOCUS |
0
|
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| FIELDNAME |
FIC_electionResults5
|
| FIELDNAMENOFIC |
electionResults5
|
| FIELDPERMISSION |
2
|
| ID |
525076
|
| IMAGE |
0
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
csextendedurl
|
| LABEL |
Election Results 5
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
| 525077 |
| struct |
| AUTOFOCUS |
0
|
| DLGTYPE |
customelement
|
| FIELDNAME |
FIC_Line_Break_2
|
| FIELDNAMENOFIC |
Line_Break_2
|
| FIELDPERMISSION |
2
|
| ID |
525077
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
linebreak
|
| LABEL |
Line Break
|
| LINEBREAKS |
1
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| TABID |
524496
|
| USESECURITY |
0
|
|
| 982946 |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), "mm/dd/yyyy")
|
| DESCRIPTION |
[empty string]
|
| FIELDNAME |
FIC_allAccessAbsenteeBegins
|
| FIELDNAMENOFIC |
allAccessAbsenteeBegins
|
| FIELDPERMISSION |
2
|
| ID |
982946
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
date
|
| LABEL |
In-Person no excuse needed absentee voting begins
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
| 987716 |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
pageTitle
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| DLGTYPE |
customelement
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FIELDNAME |
FIC_relatedNewsItem
|
| FIELDNAMENOFIC |
relatedNewsItem
|
| FIELDPERMISSION |
2
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
987716
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
select
|
| LABEL |
Related News Item 1
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
SELECT DISTINCT TOP 10 df.pageID,
df2.fieldValue AS type,
LEFT(CAST(s.PublicReleaseDate AS varchar), 10) + ' - ' + s.title AS pagetitle,
s.publicreleasedate,
CAST(s.description AS varchar(max)) AS description,
ss.subsiteurl + s.filename AS pageurl
FROM dbo.data_fieldvalue df
INNER JOIN dbo.sitePages AS s
ON df.pageID = s.id
INNER JOIN dbo.SubSites AS ss
ON s.subsiteID = ss.id
LEFT JOIN (
SELECT fieldValue, pageID
FROM dbo.data_fieldvalue df1
WHERE df1.fieldid=6885
AND df1.formid=6844
) AS df2
ON df2.pageID = df.pageID
WHERE df.fieldid=6855
AND df.formid=6844
AND (
(',' + RTRIM(df.fieldValue) + ',') LIKE '%,306,%'
)
AND (s.isPublic = 1 OR s.isPublic = 9)
AND s.approvalStatus=0
AND s.filename not LIKE '%.pdf'
AND s.filename not LIKE '%.doc'
AND s.filename not LIKE '%.xls'
AND s.filename not LIKE '%.gif'
AND s.filename not LIKE '%.jpeg'
AND s.filename not LIKE '%.jpg'
AND s.filename not LIKE '%.png'
AND s.filename not like '%index.cfm'
AND CAST(s.publicreleasedate AS datetime) < GETDATE()
AND (
(CAST(s.expdate AS datetime) > GETDATE())
OR (s.expdate is null)
)
AND s.title <> ''
AND ss.subsiteurl not LIKE '%internal-apps%'
AND ss.subsiteurl not LIKE '%/web-development/documentation/%'
AND ss.subsiteurl not LIKE '%/news-media/newsgram/%'
and df2.fieldvalue = 'News and Announcements'
ORDER BY publicreleasedate DESC
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
1
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| TABID |
987715
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
pageID
|
| VALLIST |
[empty string]
|
| VALSOURCE |
query
|
| VALUEFIELDID |
[empty string]
|
|
| 987717 |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
pageTitle
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| DLGTYPE |
customelement
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FIELDNAME |
FIC_relatedNewsItem2
|
| FIELDNAMENOFIC |
relatedNewsItem2
|
| FIELDPERMISSION |
2
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
987717
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
select
|
| LABEL |
Related News Item 2
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
SELECT DISTINCT TOP 10 df.pageID,
df2.fieldValue AS type,
LEFT(CAST(s.PublicReleaseDate AS varchar), 10) + ' - ' + s.title AS pagetitle,
s.publicreleasedate,
CAST(s.description AS varchar(max)) AS description,
ss.subsiteurl + s.filename AS pageurl
FROM dbo.data_fieldvalue df
INNER JOIN dbo.sitePages AS s
ON df.pageID = s.id
INNER JOIN dbo.SubSites AS ss
ON s.subsiteID = ss.id
LEFT JOIN (
SELECT fieldValue, pageID
FROM dbo.data_fieldvalue df1
WHERE df1.fieldid=6885
AND df1.formid=6844
) AS df2
ON df2.pageID = df.pageID
WHERE df.fieldid=6855
AND df.formid=6844
AND (
(',' + RTRIM(df.fieldValue) + ',') LIKE '%,306,%'
)
AND (s.isPublic = 1 OR s.isPublic = 9)
AND s.approvalStatus=0
AND s.filename not LIKE '%.pdf'
AND s.filename not LIKE '%.doc'
AND s.filename not LIKE '%.xls'
AND s.filename not LIKE '%.gif'
AND s.filename not LIKE '%.jpeg'
AND s.filename not LIKE '%.jpg'
AND s.filename not LIKE '%.png'
AND s.filename not like '%index.cfm'
AND CAST(s.publicreleasedate AS datetime) < GETDATE()
AND (
(CAST(s.expdate AS datetime) > GETDATE())
OR (s.expdate is null)
)
AND s.title <> ''
AND ss.subsiteurl not LIKE '%internal-apps%'
AND ss.subsiteurl not LIKE '%/web-development/documentation/%'
AND ss.subsiteurl not LIKE '%/news-media/newsgram/%'
and df2.fieldvalue = 'News and Announcements'
ORDER BY publicreleasedate DESC
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
1
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| TABID |
987715
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
pageID
|
| VALLIST |
[empty string]
|
| VALSOURCE |
query
|
| VALUEFIELDID |
[empty string]
|
|
| 987718 |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
pageTitle
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| DLGTYPE |
customelement
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FIELDNAME |
FIC_relatedNewsItem3
|
| FIELDNAMENOFIC |
relatedNewsItem3
|
| FIELDPERMISSION |
2
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
987718
|
| INPUTDBTYPE |
varchar
|
| INPUTTYPE |
select
|
| LABEL |
Related News Item 3
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
SELECT DISTINCT TOP 10 df.pageID,
df2.fieldValue AS type,
LEFT(CAST(s.PublicReleaseDate AS varchar), 10) + ' - ' + s.title AS pagetitle,
s.publicreleasedate,
CAST(s.description AS varchar(max)) AS description,
ss.subsiteurl + s.filename AS pageurl
FROM dbo.data_fieldvalue df
INNER JOIN dbo.sitePages AS s
ON df.pageID = s.id
INNER JOIN dbo.SubSites AS ss
ON s.subsiteID = ss.id
LEFT JOIN (
SELECT fieldValue, pageID
FROM dbo.data_fieldvalue df1
WHERE df1.fieldid=6885
AND df1.formid=6844
) AS df2
ON df2.pageID = df.pageID
WHERE df.fieldid=6855
AND df.formid=6844
AND (
(',' + RTRIM(df.fieldValue) + ',') LIKE '%,306,%'
)
AND (s.isPublic = 1 OR s.isPublic = 9)
AND s.approvalStatus=0
AND s.filename not LIKE '%.pdf'
AND s.filename not LIKE '%.doc'
AND s.filename not LIKE '%.xls'
AND s.filename not LIKE '%.gif'
AND s.filename not LIKE '%.jpeg'
AND s.filename not LIKE '%.jpg'
AND s.filename not LIKE '%.png'
AND s.filename not like '%index.cfm'
AND CAST(s.publicreleasedate AS datetime) < GETDATE()
AND (
(CAST(s.expdate AS datetime) > GETDATE())
OR (s.expdate is null)
)
AND s.title <> ''
AND ss.subsiteurl not LIKE '%internal-apps%'
AND ss.subsiteurl not LIKE '%/web-development/documentation/%'
AND ss.subsiteurl not LIKE '%/news-media/newsgram/%'
and df2.fieldvalue = 'News and Announcements'
ORDER BY publicreleasedate DESC
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
1
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| TABID |
987715
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
pageID
|
| VALLIST |
[empty string]
|
| VALSOURCE |
query
|
| VALUEFIELDID |
[empty string]
|
|
|
| FILTER |
| struct |
| FORCECACHE |
0
|
| SERSRCHARRAY |
| array
|
| 1 |
| metadata_date| 524494_524506| >= | dateformat(DateAdd("d",-1,now()),'mm/dd/yyyy')| | | and |
| 2 |
((| metadata_date| 524494_524502| >= | | f,1988-03-09 11:49:50,| | and |
| 3 |
| metadata_date| 524494_524502| <= | | v,+:14:d,Current date plus 14 Day(s)| )| or |
| 4 |
(| metadata_date| 524494_982946| >= | | f,1986-03-13 12:29:18,| | and |
| 5 |
| metadata_date| 524494_982946| <= | | v,+:14:d,Current date plus 14 Day(s)| )| or |
| 6 |
| metadata_date| 524494_524506| <= | | v,+:14:d,Current date plus 14 Day(s)| )| |
|
|
| FILTEROPT |
1
|
| FORMPARAMETERS |
| struct |
| 524494 |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| ElementPageID |
524591
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
| HASPROPERTIES |
true
|
| LIMIT |
0
|
| MASKCOLLECTION |
[empty string]
|
| NOCACHE |
0
|
| PROPERTIES |
| query |
| |
ACTION |
CLASS |
CLASSID |
CS_EXISTINGORDER |
CUSTFLDTYPE_DATATYPE |
CUSTFLDTYPE_FILTERMODULE |
CUSTFLDTYPE_ID |
DATECREATED |
DATELASTMODIFIED |
DESCRIPTION |
FIELDNAME |
FORMID |
FORMNAME |
ID |
INPUTCREATED |
INPUTID |
INPUTLASTMODIFIED |
INPUTOVERRIDEPARAMS |
INPUTPARAMS |
INPUTTYPE |
ITEMPOS |
JSHANDLER |
METHOD |
OWNERID |
PARAMS |
SHARED |
TABDISPLAYNAME |
TABID |
TABSORTNAME |
VIEWERPAGEID |
| 1 |
[empty string]
|
6
|
1
|
1
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_name
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524497
|
2016-03-14 13:42:03
|
[empty string]
|
| wddx encoded |
| struct |
| COOKIEFIELD |
[empty string]
|
| DLGTYPE |
customelement
|
| LABEL |
Name
|
| MAXLENGTH |
255
|
| MSG |
Please enter a valid Name value
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
Yes
|
| SIZE |
20
|
| TABID |
524495
|
| USESECURITY |
0
|
| USEUDEF |
0
|
|
|
text
|
1
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 2 |
[empty string]
|
6
|
1
|
2
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_generalInfo
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524498
|
2016-03-14 13:42:03
|
[empty string]
|
| wddx encoded |
| struct |
| COLS |
40
|
| DLGTYPE |
customelement
|
| LABEL |
General Information/Description
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| ROWS |
8
|
| TABID |
524495
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| WRAP |
virtual
|
|
|
large_textarea
|
2
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 3 |
[empty string]
|
6
|
1
|
3
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_type
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524499
|
2022-09-08 15:24:03
|
[empty string]
|
| wddx encoded |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
[empty string]
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
524499
|
| LABEL |
Election type
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
[empty string]
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
0
|
| SHARED |
0
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
[empty string]
|
| VALLIST |
Presidential Preference Primary - (Federal Election),General Election - (Federal Election),Primary Election - (Federal Election),General Municipal Election - (City-Wide Local Election),Primary Municipal Election - (City-Wide Local Election),Special Election - (Federal Election),Special Election - (City-Wide Local Election),Special Election
|
| VALSOURCE |
valList
|
| VALUEFIELDID |
[empty string]
|
|
|
select
|
3
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 4 |
[empty string]
|
6
|
1
|
4
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_filingBegins
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524500
|
2022-09-08 15:20:31
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| ID |
524500
|
| LABEL |
Candidate filing begins
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
4
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 5 |
[empty string]
|
6
|
1
|
5
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_filingEnds
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524501
|
2022-09-08 15:21:06
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| ID |
524501
|
| LABEL |
Candidate filing Ends
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
5
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 6 |
[empty string]
|
6
|
1
|
6
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_absenteeBegins
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524502
|
2022-09-08 15:21:20
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| ID |
524502
|
| LABEL |
Application-based absentee voting begins
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
6
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 7 |
[empty string]
|
6
|
1
|
7
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_lastDayToRegister
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524503
|
2022-09-08 15:23:23
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| ID |
524503
|
| LABEL |
Last day to register to vote in this election
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
7
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 8 |
[empty string]
|
6
|
1
|
8
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_allAccessAbsenteeBegins
|
524494
|
BOE Election
|
524494
|
2022-09-02 16:24:07
|
982946
|
2024-09-09 18:20:43
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), "mm/dd/yyyy")
|
| DESCRIPTION |
[empty string]
|
| ID |
982946
|
| LABEL |
In-Person no excuse needed absentee voting begins
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
8
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 9 |
[empty string]
|
6
|
1
|
9
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_lastDayToRequestAbsentee
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524504
|
2022-09-08 15:22:41
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), "mm/dd/yyyy")
|
| DESCRIPTION |
[empty string]
|
| ID |
524504
|
| LABEL |
Last day to request an application-based absentee ballot by mail
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
9
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 10 |
[empty string]
|
6
|
1
|
10
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_lastDayToVoteAbsentee
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524505
|
2022-09-08 15:23:07
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| ID |
524505
|
| LABEL |
Last day to vote absentee in person (both types)
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
10
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 11 |
[empty string]
|
6
|
1
|
11
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_electionDate
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524506
|
2022-09-08 15:23:40
|
[empty string]
|
| wddx encoded |
| struct |
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
dateFormat(now(), 'mm/dd/yyyy')
|
| DESCRIPTION |
[empty string]
|
| ID |
524506
|
| LABEL |
Election date
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| SHARED |
0
|
| USESECURITY |
0
|
| USEUDEF |
1
|
|
|
date
|
11
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
General Election Info
|
524495
|
a
|
524591
|
| 12 |
[empty string]
|
6
|
1
|
12
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_listOfCandidates
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524507
|
2016-03-14 13:42:03
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
List of Candidates
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
12
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 13 |
[empty string]
|
6
|
1
|
13
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_Line_Break
|
524494
|
BOE Election
|
524494
|
2016-03-15 17:04:05
|
525071
|
2016-03-15 17:04:05
|
[empty string]
|
| wddx encoded |
| struct |
| DLGTYPE |
customelement
|
| LABEL |
Line Break
|
| LINEBREAKS |
1
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| TABID |
524496
|
| USESECURITY |
0
|
|
|
linebreak
|
13
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 14 |
[empty string]
|
6
|
1
|
14
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_sampleBallot
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524508
|
2016-03-14 13:42:03
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
Sample Ballot Document
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
14
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 15 |
[empty string]
|
6
|
1
|
15
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_Line_Break_1
|
524494
|
BOE Election
|
524494
|
2016-03-15 17:04:27
|
525072
|
2016-03-15 17:04:27
|
[empty string]
|
| wddx encoded |
| struct |
| DLGTYPE |
customelement
|
| LABEL |
Line Break
|
| LINEBREAKS |
1
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| TABID |
524496
|
| USESECURITY |
0
|
|
|
linebreak
|
15
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 16 |
[empty string]
|
6
|
1
|
16
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_electionResults
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524509
|
2016-03-14 13:42:03
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
Election Results Document
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
16
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 17 |
[empty string]
|
6
|
1
|
17
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_electionResults2
|
524494
|
BOE Election
|
524494
|
2016-03-15 17:05:04
|
525073
|
2016-03-15 17:05:04
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
Election Results 2
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
17
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 18 |
[empty string]
|
6
|
1
|
18
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_electionResults3
|
524494
|
BOE Election
|
524494
|
2016-03-15 17:05:32
|
525074
|
2016-03-15 17:05:32
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
Election Results 3
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
18
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 19 |
[empty string]
|
6
|
1
|
19
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_electionResults4
|
524494
|
BOE Election
|
524494
|
2016-03-15 17:05:56
|
525075
|
2016-03-15 17:05:56
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
Election Results 4
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
19
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 20 |
[empty string]
|
6
|
1
|
20
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_electionResults5
|
524494
|
BOE Election
|
524494
|
2016-03-15 17:06:20
|
525076
|
2016-03-15 17:06:20
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
Election Results 5
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
0
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
20
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 21 |
[empty string]
|
6
|
1
|
21
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_Line_Break_2
|
524494
|
BOE Election
|
524494
|
2016-03-15 17:06:32
|
525077
|
2016-03-15 17:06:32
|
[empty string]
|
| wddx encoded |
| struct |
| DLGTYPE |
customelement
|
| LABEL |
Line Break
|
| LINEBREAKS |
1
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REQ |
No
|
| TABID |
524496
|
| USESECURITY |
0
|
|
|
linebreak
|
21
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 22 |
[empty string]
|
6
|
1
|
22
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_extraDocument1
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524510
|
2016-03-14 13:42:03
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| EMAIL |
0
|
| ID |
524510
|
| IMAGE |
0
|
| LABEL |
Extra Document 1
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHARED |
0
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
22
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 23 |
[empty string]
|
6
|
1
|
23
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_extraDocument2
|
524494
|
BOE Election
|
524494
|
2016-03-14 13:42:03
|
524511
|
2016-03-14 13:42:03
|
[empty string]
|
| wddx encoded |
| struct |
| CSPAGE |
1
|
| DLGTYPE |
customelement
|
| EMAIL |
0
|
| IMAGE |
0
|
| LABEL |
Extra Document 2
|
| MULTIMEDIAFILE |
0
|
| MULTIMEDIAPLAYLIST |
0
|
| NEWDOC |
1
|
| NEWPAGE |
0
|
| PAGESET |
0
|
| PEDIT |
[empty string]
|
| PREAD |
[empty string]
|
| READONLY |
0
|
| REGURL |
0
|
| REQ |
No
|
| SHOWLINKCONTROL |
0
|
| SHOWWINPROPS |
0
|
| TABID |
524496
|
| UPLOADEDDOC |
1
|
| URL |
1
|
| USESECURITY |
0
|
| WINDOWNAME |
[empty string]
|
| WINDOWPROPS |
[empty string]
|
|
|
csextendedurl
|
23
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
Documents
|
524496
|
b
|
524591
|
| 24 |
[empty string]
|
6
|
1
|
24
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_relatedNewsItem
|
524494
|
BOE Election
|
524494
|
2022-10-06 13:17:12
|
987716
|
2022-10-06 13:17:12
|
[empty string]
|
| wddx encoded |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
pageTitle
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| DLGTYPE |
customelement
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
987716
|
| LABEL |
Related News Item 1
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
SELECT DISTINCT TOP 10 df.pageID,
df2.fieldValue AS type,
LEFT(CAST(s.PublicReleaseDate AS varchar), 10) + ' - ' + s.title AS pagetitle,
s.publicreleasedate,
CAST(s.description AS varchar(max)) AS description,
ss.subsiteurl + s.filename AS pageurl
FROM dbo.data_fieldvalue df
INNER JOIN dbo.sitePages AS s
ON df.pageID = s.id
INNER JOIN dbo.SubSites AS ss
ON s.subsiteID = ss.id
LEFT JOIN (
SELECT fieldValue, pageID
FROM dbo.data_fieldvalue df1
WHERE df1.fieldid=6885
AND df1.formid=6844
) AS df2
ON df2.pageID = df.pageID
WHERE df.fieldid=6855
AND df.formid=6844
AND (
(',' + RTRIM(df.fieldValue) + ',') LIKE '%,306,%'
)
AND (s.isPublic = 1 OR s.isPublic = 9)
AND s.approvalStatus=0
AND s.filename not LIKE '%.pdf'
AND s.filename not LIKE '%.doc'
AND s.filename not LIKE '%.xls'
AND s.filename not LIKE '%.gif'
AND s.filename not LIKE '%.jpeg'
AND s.filename not LIKE '%.jpg'
AND s.filename not LIKE '%.png'
AND s.filename not like '%index.cfm'
AND CAST(s.publicreleasedate AS datetime) < GETDATE()
AND (
(CAST(s.expdate AS datetime) > GETDATE())
OR (s.expdate is null)
)
AND s.title <> ''
AND ss.subsiteurl not LIKE '%internal-apps%'
AND ss.subsiteurl not LIKE '%/web-development/documentation/%'
AND ss.subsiteurl not LIKE '%/news-media/newsgram/%'
and df2.fieldvalue = 'News and Announcements'
ORDER BY publicreleasedate DESC
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
1
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| TABID |
987715
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
pageID
|
| VALLIST |
[empty string]
|
| VALSOURCE |
query
|
| VALUEFIELDID |
[empty string]
|
|
|
select
|
24
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
News
|
987715
|
news
|
524591
|
| 25 |
[empty string]
|
6
|
1
|
25
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_relatedNewsItem2
|
524494
|
BOE Election
|
524494
|
2022-10-06 13:17:59
|
987717
|
2022-10-06 13:17:59
|
[empty string]
|
| wddx encoded |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
pageTitle
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| DLGTYPE |
customelement
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
987717
|
| LABEL |
Related News Item 2
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
SELECT DISTINCT TOP 10 df.pageID,
df2.fieldValue AS type,
LEFT(CAST(s.PublicReleaseDate AS varchar), 10) + ' - ' + s.title AS pagetitle,
s.publicreleasedate,
CAST(s.description AS varchar(max)) AS description,
ss.subsiteurl + s.filename AS pageurl
FROM dbo.data_fieldvalue df
INNER JOIN dbo.sitePages AS s
ON df.pageID = s.id
INNER JOIN dbo.SubSites AS ss
ON s.subsiteID = ss.id
LEFT JOIN (
SELECT fieldValue, pageID
FROM dbo.data_fieldvalue df1
WHERE df1.fieldid=6885
AND df1.formid=6844
) AS df2
ON df2.pageID = df.pageID
WHERE df.fieldid=6855
AND df.formid=6844
AND (
(',' + RTRIM(df.fieldValue) + ',') LIKE '%,306,%'
)
AND (s.isPublic = 1 OR s.isPublic = 9)
AND s.approvalStatus=0
AND s.filename not LIKE '%.pdf'
AND s.filename not LIKE '%.doc'
AND s.filename not LIKE '%.xls'
AND s.filename not LIKE '%.gif'
AND s.filename not LIKE '%.jpeg'
AND s.filename not LIKE '%.jpg'
AND s.filename not LIKE '%.png'
AND s.filename not like '%index.cfm'
AND CAST(s.publicreleasedate AS datetime) < GETDATE()
AND (
(CAST(s.expdate AS datetime) > GETDATE())
OR (s.expdate is null)
)
AND s.title <> ''
AND ss.subsiteurl not LIKE '%internal-apps%'
AND ss.subsiteurl not LIKE '%/web-development/documentation/%'
AND ss.subsiteurl not LIKE '%/news-media/newsgram/%'
and df2.fieldvalue = 'News and Announcements'
ORDER BY publicreleasedate DESC
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
1
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| TABID |
987715
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
pageID
|
| VALLIST |
[empty string]
|
| VALSOURCE |
query
|
| VALUEFIELDID |
[empty string]
|
|
|
select
|
25
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
News
|
987715
|
news
|
524591
|
| 26 |
[empty string]
|
6
|
1
|
26
|
[empty string]
|
[empty string]
|
[empty string]
|
2016-03-14 13:42:03
|
2026-04-15 16:20:13
|
[empty string]
|
FIC_relatedNewsItem3
|
524494
|
BOE Election
|
524494
|
2022-10-06 13:18:30
|
987718
|
2022-10-06 13:18:30
|
[empty string]
|
| wddx encoded |
| struct |
| ALLOWOTHER |
no
|
| AUTOFOCUS |
0
|
| COOKIEFIELD |
[empty string]
|
| DEFAULTVALUE |
[empty string]
|
| DESCRIPTION |
[empty string]
|
| DISPCOL |
pageTitle
|
| DISPLAYFIELDID |
[empty string]
|
| DISPLAYVALUEDELIM |
[empty string]
|
| DLGTYPE |
customelement
|
| ELEMENTID |
[empty string]
|
| FIELDID |
[empty string]
|
| FILTER |
[empty string]
|
| FILTERTYPE |
0
|
| ID |
987718
|
| LABEL |
Related News Item 3
|
| MULT |
no
|
| OTHERVALSIZE |
[empty string]
|
| PEDIT |
[empty string]
|
| PLACEHOLDER |
[empty string]
|
| PREAD |
[empty string]
|
| QUERY |
SELECT DISTINCT TOP 10 df.pageID,
df2.fieldValue AS type,
LEFT(CAST(s.PublicReleaseDate AS varchar), 10) + ' - ' + s.title AS pagetitle,
s.publicreleasedate,
CAST(s.description AS varchar(max)) AS description,
ss.subsiteurl + s.filename AS pageurl
FROM dbo.data_fieldvalue df
INNER JOIN dbo.sitePages AS s
ON df.pageID = s.id
INNER JOIN dbo.SubSites AS ss
ON s.subsiteID = ss.id
LEFT JOIN (
SELECT fieldValue, pageID
FROM dbo.data_fieldvalue df1
WHERE df1.fieldid=6885
AND df1.formid=6844
) AS df2
ON df2.pageID = df.pageID
WHERE df.fieldid=6855
AND df.formid=6844
AND (
(',' + RTRIM(df.fieldValue) + ',') LIKE '%,306,%'
)
AND (s.isPublic = 1 OR s.isPublic = 9)
AND s.approvalStatus=0
AND s.filename not LIKE '%.pdf'
AND s.filename not LIKE '%.doc'
AND s.filename not LIKE '%.xls'
AND s.filename not LIKE '%.gif'
AND s.filename not LIKE '%.jpeg'
AND s.filename not LIKE '%.jpg'
AND s.filename not LIKE '%.png'
AND s.filename not like '%index.cfm'
AND CAST(s.publicreleasedate AS datetime) < GETDATE()
AND (
(CAST(s.expdate AS datetime) > GETDATE())
OR (s.expdate is null)
)
AND s.title <> ''
AND ss.subsiteurl not LIKE '%internal-apps%'
AND ss.subsiteurl not LIKE '%/web-development/documentation/%'
AND ss.subsiteurl not LIKE '%/news-media/newsgram/%'
and df2.fieldvalue = 'News and Announcements'
ORDER BY publicreleasedate DESC
|
| QUERYDSN |
commonspot-site-stlouis
|
| READONLY |
0
|
| REQ |
No
|
| SELECTOPTION |
1
|
| SIZE |
1
|
| SORTCOL |
[empty string]
|
| TABID |
987715
|
| UDEF |
[empty string]
|
| USESECURITY |
0
|
| USEUDEF |
0
|
| VALCOL |
pageID
|
| VALLIST |
[empty string]
|
| VALSOURCE |
query
|
| VALUEFIELDID |
[empty string]
|
|
|
select
|
26
|
[empty string]
|
[empty string]
|
1000283
|
| wddx encoded |
| struct |
| COLLECTIONNAME |
[empty string]
|
| DEFAULTSORT |
524506
|
| DESCFIELD |
0
|
| FIELDLIST |
524497,524498,524499,524506,524509,524508,524510,524511,525073
|
| INDEXELEMENT |
0
|
| MAXRESULTS |
0
|
| REMOTEEDIT |
none
|
| TITLEFIELD |
0
|
|
|
0
|
News
|
987715
|
news
|
524591
|
|
| QUERYBYEXAMPLE |
0
|
| RANDOM |
0
|
| RECORDLIMIT |
0
|
| RENDERMASKID |
0
|
| SELTYPE |
1
|
| SHOWADDDATA |
0
|
| SHOWAPPENDDATA |
0
|
| SHOWREUSEADDDATA |
0
|
|