eSearch Widget

[RudoDuncan]

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}",

[RobertScheitlin__GISP]

Rudo,

No the SQL query text will not manipulate the returned vales of a field like that. The SQL text will only affect which features are returned and not the attribute values returned.

[RudoDuncan]

Do you know of a method to do so? Would have an idea of the .js or .json that would do something like that?

[RobertScheitlin__GISP · Accepted solution]

Rudo,

   Sure I think this thread will get you going on this. You may have to read some of the earlier traffic between Kevin and I to get the context though.

https://community.esri.com/docs/DOC-1731#comment-20232