https://community.splunk.com/t5/Splunk-Search/Greater-and-less-than/m-p/522620#M147371 Can you switch “ to ‘ as “ means value and ‘ means field. Next what you could try is change search to where.<BR />r. Ismo Fri, 02 Oct 2020 04:46:16 GMT isoutamo 2020-10-02T04:46:16Z https://community.splunk.com/t5/Splunk-Search/Greater-and-less-than/m-p/522619#M147370 <P>Hi, I'm trying this search and it seems to be working as i'm not getting anything outside the range.&nbsp; The issue is I've created an event that should get picked up by the below search, so I'm obviously doing something wrong here.</P><P>&nbsp;</P><LI-CODE lang="markup">| search "fooResponse.bets{}.legs{}.propositionId"&gt;=150000 AND "fooResponse.bets{}.legs{}.propositionId"&lt;=180000</LI-CODE><P>&nbsp;</P><P>Any help would be greatly appreciated.</P><P>Cheers,<BR />Steve</P> Fri, 02 Oct 2020 04:00:18 GMT https://community.splunk.com/t5/Splunk-Search/Greater-and-less-than/m-p/522619#M147370 stevelfc 2020-10-02T04:00:18Z https://community.splunk.com/t5/Splunk-Search/Greater-and-less-than/m-p/522620#M147371 Can you switch “ to ‘ as “ means value and ‘ means field. Next what you could try is change search to where.<BR />r. Ismo Fri, 02 Oct 2020 04:46:16 GMT https://community.splunk.com/t5/Splunk-Search/Greater-and-less-than/m-p/522620#M147371 isoutamo 2020-10-02T04:46:16Z https://community.splunk.com/t5/Splunk-Search/Greater-and-less-than/m-p/522622#M147372 <P>i think I've worked out why, some of my numbers are coming in an array, so not getting picked up by the search.<BR />EDIT: mvexpand worked to search in the array</P> Fri, 02 Oct 2020 05:28:51 GMT https://community.splunk.com/t5/Splunk-Search/Greater-and-less-than/m-p/522622#M147372 stevelfc 2020-10-02T05:28:51Z