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.