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}",
Solved! Go to 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.
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.
Do you know of a method to do so? Would have an idea of the .js or .json that would do something like that?
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.