AnsweredAssumed Answered

eSearch Widget

Question asked by rdunn723 on Feb 3, 2016
Latest reply on Feb 3, 2016 by rscheitlin

Robert Scheitlin, GISP

 

Can I put this code in my config.json file so that my IncDate field would return the year only? Current it's 20160203.

 

"name": "IncDate",

            "alias": "IncDate",

            "sqltext": "IncDate = Left('[value]',4)"

 

I am trying to change:

 

alias": "{IncNum}",

            "disablelinksifnull": true,

            "disableinpopup": false,

            "popuptype": "text",

            "content": "http://phqrpt01/ReportServer/Pages/ReportViewer.aspx?%2fPatrol%2fCAD%2fCallsForService&rs:Command=Render&rc:Parameters=false&Year=2016&IncNum={IncNum}",

 

To this:

So that any year that is available, a report would pop up when the link is clicked.

%2fPatrol%2fCAD%2fCallsForService&rs:Command=Render&rc:Parameters=false&Year={IncDate)&IncNum={IncNum}",

Outcomes