2023年4月1日 01:02:21go评论73阅读模式

英文:

Find JSON value based on Max date in another field

问题

Sure, here's the translated code snippet without the request for translation:

var jsonData = JSON.parse(responseBody);

var maxDate = null;
var experimentId = null;

for (var i = 0; i < jsonData.length; i++) {
  var createdDate = new Date(jsonData[i]["CreatedDate"]);

  if (maxDate === null || createdDate > maxDate) {
    maxDate = createdDate;
    experimentId = jsonData[i]["ExperimentId"];
  }
}

postman.setEnvironmentVariable("maxCreatedDateExperimentId", experimentId);

This code will find the maximum CreatedDate from your JSON response and store the associated ExperimentId in a Postman environment variable named maxCreatedDateExperimentId.

英文:

I have a JSON response body that looks like this:

[
    {
        &quot;ExperimentPlanningId&quot;: 20,
        &quot;ExperimentId&quot;: &quot;PT1011&quot;,
        &quot;AnalystId&quot;: 2,
        &quot;ExperimentTemplateId&quot;: 1,
        &quot;NumberoFPools&quot;: null,
        &quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
        &quot;NextProcess&quot;: &quot;234343&quot;,
        &quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
        &quot;NextStage&quot;: &quot;Stage 1 2&quot;,
        &quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
        &quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
        &quot;ProjectedOutcome&quot;: null,
        &quot;ExperimentalDesign&quot;: null,
        &quot;IsActive&quot;: true,
        &quot;CreatedDate&quot;: &quot;2022-10-14T20:10:42.8276862+00:00&quot;
		
	},
	{
	    &quot;ExperimentPlanningId&quot;: 20,
        &quot;ExperimentId&quot;: &quot;JD2994&quot;,
        &quot;AnalystId&quot;: 2,
        &quot;ExperimentTemplateId&quot;: 1,
        &quot;NumberoFPools&quot;: null,
        &quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
        &quot;NextProcess&quot;: &quot;234343&quot;,
        &quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
        &quot;NextStage&quot;: &quot;Stage 1 2&quot;,
        &quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
        &quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
        &quot;ProjectedOutcome&quot;: null,
        &quot;ExperimentalDesign&quot;: null,
        &quot;IsActive&quot;: true,
        &quot;CreatedDate&quot;: &quot;2023-03-31T16:23:19.5981913+00:00&quot;
	}
]

I want to loop through the response body in Postman, find the MAX CreatedDate and store the ExperimentId associated with it, in a variable. So in the example above I'd want to store JD2994 in a variable.

I started with this, but am getting a max is not defined error:

var jsonData = JSON.parse(responseBody)

for (var i=0, len = jsonData.length; i&lt;len; i++) {
  var value = max(jsonData[i][&quot;CreatedDate&quot;]);
}

答案1

得分: 2

以下是翻译好的内容：

Here is a better loop
这是一个更好的循环

let maxDate = 0;
let maxId = "";
data.forEach(({ CreatedDate, ExperimentId }) => {
  const d = new Date(CreatedDate).getTime();
  if (d > maxDate) {
    maxId = ExperimentId;
    maxDate = d;
  }
})
console.log(new Date(maxDate), maxId)

Reduce:
简化：

const maxId = data.reduce((savedMax, { CreatedDate, ExperimentId }) => {
  if (CreatedDate > savedMax.date) { // 日期格式可以进行字符串比较
    savedMax.date = CreatedDate;
    savedMax.id = ExperimentId;
  }
  return savedMax;
}, { date: "", id: "" }); // 初始化 savedMax
console.log(maxId);

英文:

Here is a better loop

let maxDate = 0;
let maxId = &quot;&quot;;
data.forEach(({CreatedDate, ExperimentId}) =&gt; {
  const d = new Date(CreatedDate).getTime();
  if (d &gt; maxDate) {
    maxId = ExperimentId;
    maxDate = d;
  }
})
console.log(new Date(maxDate), maxId)

&lt;script&gt;
data = [
    {
        &quot;ExperimentPlanningId&quot;: 20,
        &quot;ExperimentId&quot;: &quot;PT1011&quot;,
        &quot;AnalystId&quot;: 2,
        &quot;ExperimentTemplateId&quot;: 1,
        &quot;NumberoFPools&quot;: null,
        &quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
        &quot;NextProcess&quot;: &quot;234343&quot;,
        &quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
        &quot;NextStage&quot;: &quot;Stage 1 2&quot;,
        &quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
        &quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
        &quot;ProjectedOutcome&quot;: null,
        &quot;ExperimentalDesign&quot;: null,
        &quot;IsActive&quot;: true,
        &quot;CreatedDate&quot;: &quot;2022-10-14T20:10:42.8276862+00:00&quot;
        
    },
    {
        &quot;ExperimentPlanningId&quot;: 20,
        &quot;ExperimentId&quot;: &quot;JD2994&quot;,
        &quot;AnalystId&quot;: 2,
        &quot;ExperimentTemplateId&quot;: 1,
        &quot;NumberoFPools&quot;: null,
        &quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
        &quot;NextProcess&quot;: &quot;234343&quot;,
        &quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
        &quot;NextStage&quot;: &quot;Stage 1 2&quot;,
        &quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
        &quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
        &quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
        &quot;ProjectedOutcome&quot;: null,
        &quot;ExperimentalDesign&quot;: null,
        &quot;IsActive&quot;: true,
        &quot;CreatedDate&quot;: &quot;2023-03-31T16:23:19.5981913+00:00&quot;
    }
]&lt;/script&gt;

Reduce:

const maxId = data.reduce((savedMax, {CreatedDate, ExperimentId}) =&gt; {
  if (CreatedDate &gt; savedMax.date) { // the date format is string comparable
    savedMax.date = CreatedDate;
    savedMax.id = ExperimentId;
  }
  return savedMax;
}, { date: &quot;&quot;, id: &quot;&quot;}); // initialise savedMax
console.log(maxId);

&lt;script&gt;
  data = [{
      &quot;ExperimentPlanningId&quot;: 20,
      &quot;ExperimentId&quot;: &quot;PT1011&quot;,
      &quot;AnalystId&quot;: 2,
      &quot;ExperimentTemplateId&quot;: 1,
      &quot;NumberoFPools&quot;: null,
      &quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
      &quot;NextProcess&quot;: &quot;234343&quot;,
      &quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
      &quot;NextStage&quot;: &quot;Stage 1 2&quot;,
      &quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
      &quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
      &quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
      &quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
      &quot;ProjectedOutcome&quot;: null,
      &quot;ExperimentalDesign&quot;: null,
      &quot;IsActive&quot;: true,
      &quot;CreatedDate&quot;: &quot;2022-10-14T20:10:42.8276862+00:00&quot;

    },
    {
      &quot;ExperimentPlanningId&quot;: 20,
      &quot;ExperimentId&quot;: &quot;JD2994&quot;,
      &quot;AnalystId&quot;: 2,
      &quot;ExperimentTemplateId&quot;: 1,
      &quot;NumberoFPools&quot;: null,
      &quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
      &quot;NextProcess&quot;: &quot;234343&quot;,
      &quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
      &quot;NextStage&quot;: &quot;Stage 1 2&quot;,
      &quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
      &quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
      &quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
      &quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
      &quot;ProjectedOutcome&quot;: null,
      &quot;ExperimentalDesign&quot;: null,
      &quot;IsActive&quot;: true,
      &quot;CreatedDate&quot;: &quot;2023-03-31T16:23:19.5981913+00:00&quot;
    }
  ]
&lt;/script&gt;

答案2

得分: -1

这是提供的代码片段，我将提供翻译：

const jsonDataArray = [{
    "ExperimentPlanningId": 20,
    "ExperimentId": "PT1011",
    "AnalystId": 2,
    "ExperimentTemplateId": 1,
    "NumberoFPools": null,
    "ExperimentStatus": "InProgress",
    "NextProcess": "234343",
    "CurrentProcess": "Test Process 1",
    "NextStage": "Stage 1 2",
    "CurrentStage": "Stage 1 2",
    "NextProcessStartDate": "2022-10-15T14:00:00+00:00",
    "CurrentProcessEndDate": "2022-10-15T14:00:00+00:00",
    "ExperimentStartDate": "2022-10-14T15:00:00+00:00",
    "ProjectedOutcome": null,
    "ExperimentalDesign": null,
    "IsActive": true,
    "CreatedDate": "2022-10-14T20:10:42.8276862+00:00"
  },
  {
    "ExperimentPlanningId": 20,
    "ExperimentId": "JD2994",
    "AnalystId": 2,
    "ExperimentTemplateId": 1,
    "NumberoFPools": null,
    "ExperimentStatus": "InProgress",
    "NextProcess": "234343",
    "CurrentProcess": "Test Process 1",
    "NextStage": "Stage 1 2",
    "CurrentStage": "Stage 1 2",
    "NextProcessStartDate": "2022-10-15T14:00:00+00:00",
    "CurrentProcessEndDate": "2022-10-15T14:00:00+00:00",
    "ExperimentStartDate": "2022-10-14T15:00:00+00:00",
    "ProjectedOutcome": null,
    "ExperimentalDesign": null,
    "IsActive": true,
    "CreatedDate": "2023-03-31T16:23:19.5981913+00:00"
  }
];

let newObject = {};
let dates = jsonDataArray.map(function(obj) {
  const regEx = new RegExp(/-/g);
  const dateKey = parseInt(obj.CreatedDate.replace(regEx, ""), 10);
  newObject[dateKey] = obj;
  return dateKey;
});

console.log("Max", newObject[Math.max(...dates)].CreatedDate);

这是提供的 JavaScript 代码片段。

英文:

const jsonDataArray = [{
&quot;ExperimentPlanningId&quot;: 20,
&quot;ExperimentId&quot;: &quot;PT1011&quot;,
&quot;AnalystId&quot;: 2,
&quot;ExperimentTemplateId&quot;: 1,
&quot;NumberoFPools&quot;: null,
&quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
&quot;NextProcess&quot;: &quot;234343&quot;,
&quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
&quot;NextStage&quot;: &quot;Stage 1 2&quot;,
&quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
&quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
&quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
&quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
&quot;ProjectedOutcome&quot;: null,
&quot;ExperimentalDesign&quot;: null,
&quot;IsActive&quot;: true,
&quot;CreatedDate&quot;: &quot;2022-10-14T20:10:42.8276862+00:00&quot;
},
{
&quot;ExperimentPlanningId&quot;: 20,
&quot;ExperimentId&quot;: &quot;JD2994&quot;,
&quot;AnalystId&quot;: 2,
&quot;ExperimentTemplateId&quot;: 1,
&quot;NumberoFPools&quot;: null,
&quot;ExperimentStatus&quot;: &quot;InProgress&quot;,
&quot;NextProcess&quot;: &quot;234343&quot;,
&quot;CurrentProcess&quot;: &quot;Test Process 1&quot;,
&quot;NextStage&quot;: &quot;Stage 1 2&quot;,
&quot;CurrentStage&quot;: &quot;Stage 1 2&quot;,
&quot;NextProcessStartDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
&quot;CurrentProcessEndDate&quot;: &quot;2022-10-15T14:00:00+00:00&quot;,
&quot;ExperimentStartDate&quot;: &quot;2022-10-14T15:00:00+00:00&quot;,
&quot;ProjectedOutcome&quot;: null,
&quot;ExperimentalDesign&quot;: null,
&quot;IsActive&quot;: true,
&quot;CreatedDate&quot;: &quot;2023-03-31T16:23:19.5981913+00:00&quot;
}
];
let newObject = {};
let dates = jsonDataArray.map(function(obj) {
const regEx = new RegExp(/-/g);
const dateKey = parseInt(obj.CreatedDate.replace(regEx, &quot;&quot;), 10)
newObject[dateKey] = obj;
return dateKey;
});
console.log(&quot;Max&quot;, newObject[Math.max(...dates)].CreatedDate);

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

根据另一个字段中的最大日期查找JSON值。

问题

答案1

答案2

TailwindCSS styling not applied when passing prop value and using it in template literals (with Typescript)

使用模态框查看 @foreach 循环中的数据

打印多张发票只需一次点击 TypeScript

部分更新数据库通过补丁，Django REST框架。

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论