Feature Idea: As clause not working in result seen in JSON format

SELECT count(*), filter(count(httpResponseCode), WHERE httpResponseCode >= ‘400’ ) FROM Transaction WHERE (appName LIKE ‘something’ AND request.uri LIKE ‘%/api/login’) SINCE 1 days ago.

in the above query the result in JSON contains {
“count”: 423
“count”: 79


How to rename that particular count key word.


New Relic Edit

  • I want this too
  • I have more info to share (reply below)
  • I have a solution for this

0 voters

We take feature ideas seriously and our product managers review every one when plotting their roadmaps. However, there is no guarantee this feature will be implemented. This post ensures the idea is put on the table and discussed though. So please vote and share your extra details with our team.

You can use the AS keyword which functions the same as any other SQL based query.

@stefan_garnham - I think the point is that AS doesn’t work for JSON outputs; as seen here:

I think this is anomalous behaviour - I’ll get it reported up to the right team @vinaybhat :smiley:


ya exactly that’s the issue i am facing and thanks

1 Like

Thanks for confirming @vinaybhat - I’ve got that sent over to the Insights team - I’ll try to update you here as I know more.

1 Like

Sure thanks for the help. :slight_smile:

1 Like

No problem :smiley: @vinaybhat