Hi, I think you should take below point into consideration about command. Might be this could help you in some extent. Specify the number of results to return from the sorted results. If no count is specified, the default limit of 10000 is used. If 0 is specified, all results are returned. Thanks ... View more

Hi @deepashri , Thanks for your reply and help. I was using dedup already but I was missing a command which was advised by @HiroshiSatoh and that worked really well. Thanks once again! ... View more

Hi @HiroshiSatoh , I am thankful to you as you helped me a lot by providing me exact solution. I feel honored that I am part of such a great a community with high level of knowledge people and all helping hands here. Thanks once again! ... View more

Hi Vishal, Thanks for your reply but still I have not got answer for my question. With regards, Vikas baranwal ... View more

Hi John, I hope you must have got the answer but just for addition, You can also use addtotals in the last of your SPL so it will add a new column named "Total" as last of the columns. and for each row as a result, it will be sum of numeric values of every column in the table. Thanks ... View more

Thank you so much @niketnilay for resolution. Your solution was so accurate as per my result expectation. I apologies for, I did not provide much information in the question. I can say only that you are The Champ 🙂 and glad to see that you checked my question and answered on that. I always try to learn from your every posts. ... View more

Hi Renjith, Thanks for your quick resolution and it was very close to resolution. I seen that @niketnilay provided solution accurately so I am accepting his answer for the question. I will always seek your help in future for these kind of helps. Thanks once again! ... View more

Hi @macadminrohit Thanks for all your effort and help but I got the solution from other answers in the post. ... View more

Hello Friend, I have seen one problem here. There are 3 panels in one row, If data is not available in 2nd and 3rd panel then it hide both the panels. But when data not available in all the 3 panels then again message is showing as "No results founds" for each 3 panels. I have given 3 different token names in panel tags like depends="$panel_show1$",depends="$panel_show2$", depends="$panel_show3$" and made other required changes. Hope you understand my point. I will be needed your help to resolve this ... View more

Thanks for your help..In Initial level testing, its working fine. Will let you know if I will be missing anything here. ... View more

Hi Everyone, Please advise on this request. Thank you! ... View more

Hello Everyone, Please help me with the solution. If explanation is not much clear then I can try more. Thanks ... View more

Hi, I am looking for the date\time when any key value status changed 2nd time in "In Dev" status which is "11-07-2018 09:09:56" in the screenshot. It is required to show metric as how many keys was failed when then crossed "In Dev" status and when status was changed from "In Dev" to 'In QA" and done testing again and it got failed. Now again status moved to "In Dev " status from "In QA" status. Thank you for your help on this. ... View more

Hi Hari, In screenshot, If you can which I have highlighted in yellow and red. https://ibb.co/rdvQXvy Normally process is for any key value status change is "Ready for Dev" ---> "In Dev" ---> "In QA' ---> Done But when any issue find out in "In QA" status then again key status roll-back into "In Dev" and complete cycle again. Ready for Dev ---> In Dev ---> In QA ---> Ready for Dev ---> In Dev ---> In QA ---> Done I am here looking for date\time when status changes into "In Dev" status 2nd time. ... View more

Hi Frank, I am so happy after finding out solution and your valuable suggestions. I am able to extract desired output. Thanks once again. Please change solution as Accepted Answer. ... View more

Apologies writing incorrectly AS XML rather than JSON. Thanks for sharing your solution but that did work. I tried to use syntax and changed that. But still output is still not achieved correctly. I shared URL for you with sample data regex exp. [Test] SHOULD_LINEMERGE = false LINE_BREAKER = "([0-9?-]*)"[:.*$][^:\n^{]\"totalExecutions INDEXED_EXTRACTIONS = In my output I am getting like below, still numeric values are not showing as line breaker in output ":{"totalExecutions":56,"endDate":"","description":"","totalExecuted":56,"started":"","versionName":"Excalibur Web 1.4","expand":"executionSummaries","projectKey":"ESS","versionId":14176,"environment":"","totalCycleExecutions":0,"totalDefects":0,"build":"","createdBy":"JAllwood","ended":"","name":"Celebrity Web Test Cases","totalFolders":4,"modifiedBy":"jallwood","projectId":11700,"createdByDisplay":"Jesus Allwood","startDate":"","executionSummaries":{"executionSummary":[]}},"recordsCount":2}]} Sorry again for not able share my URL properly. https:// [ADD this] regex101.com/r/ulyMpO/1 ... View more

{ "-1":[ { "-1":{ "totalExecutions":513, "totalExecuted":476, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "totalCycleExecutions":513, "name":"Ad hoc", "modifiedBy":"", "projectId":10101, "startDate":"", "executionSummaries":{ "executionSummary":[ ] } }, "29":{ "totalExecutions":0, "totalExecuted":0, "started":"", "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "totalCycleExecutions":0, "totalDefects":0, "name":"Full Regression - X.X.X (Android)", "totalFolders":0, "modifiedBy":"sudeepjames", "projectId":10101, "createdByDisplay":"Arnaldo Ramirez", "startDate":"", "executionSummaries":{ "executionSummary":[ ] } }, "73":{ "totalExecutions":332, "totalExecuted":22, "started":"", "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":332, "totalDefects":0, "build":"RCI ", "name":"Test cycle example", "totalFolders":0, "projectId":10101, "createdByDisplay":"Arnaldo Ramirez", "startDate":"", "executionSummaries":{ "executionSummary":[ ] } }, "83":{ "totalExecutions":1, "totalExecuted":1, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":1, "totalDefects":0, "createdBy":"ARamirez", "name":"test ", "totalFolders":0, "modifiedBy":"aramirez", "projectId":10101, "createdByDisplay":"Arnaldo Ramirez", "startDate":"", "executionSummaries":{ "executionSummary":[ ] } }, "167":{ "totalExecutions":984, "endDate":"", "description":"Test every TC written with a logged in user", "totalExecuted":34, "started":"", "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "totalCycleExecutions":984, "totalDefects":0, "name":"Full Regression integration", "totalFolders":0, "modifiedBy":"pedrogonzalez", "projectId":10101, "createdByDisplay":"Pedro Gonzalez", "executionSummaries":{ "executionSummary":[ ] } }, "373":{ "totalExecutions":75, "totalExecuted":2, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":0, "totalDefects":0, "name":"CORE-Commerce: Regression", "totalFolders":4, "modifiedBy":"jguerra", "projectId":10101, "createdByDisplay":"Jandry Guerra", "startDate":"", "executionSummaries":{ "executionSummary":[ ] } }, "891":{ "totalExecutions":174, "endDate":"", "description":"", "totalExecuted":0, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "totalCycleExecutions":174, "totalDefects":0, "name":"RCL - Silver - Test Automated Regression (Android)", "totalFolders":0, "modifiedBy":"aramirez", "projectId":10101, "createdByDisplay":"Arnaldo Ramirez", "executionSummaries":{ "executionSummary":[ ] } }, "892":{ "totalExecutions":184, "totalExecuted":0, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "totalCycleExecutions":184, "totalDefects":0, "build":"", "createdBy":"ARamirez", "ended":"", "name":"RCL - Silver - Test Automated Regression (iOS)", "totalFolders":0, "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "1219":{ "totalExecutions":99, "endDate":"", "description":"AEM-Regression", "totalExecuted":0, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "totalCycleExecutions":99, "totalDefects":0, "build":"", "createdBy":"DGhodke", "ended":"", "name":"AEM-Regression", "totalFolders":0, "modifiedBy":"dghodke", "projectId":10101, "createdByDisplay":"Dhananjay Ghodke", "startDate":"", "executionSummaries":{ "executionSummary":[ ] } }, "1281":{ "totalExecutions":69, "description":"AEM-Content", "totalExecuted":0, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":69, "totalDefects":0, "name":"AEM-Content", "totalFolders":0, "modifiedBy":"dghodke", "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "1282":{ "totalExecutions":37, "totalExecuted":0, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":37, "totalDefects":0, "createdBy":"DGhodke", "name":"AEM-Integration", "totalFolders":0, "modifiedBy":"dghodke", "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "1465":{ "totalExecutions":0, "totalExecuted":0, "started":"", "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":0, "totalDefects":0, "name":"Motley Crew", "totalFolders":2, "modifiedBy":"jwalker-clay", "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "1656":{ "totalExecutions":102, "totalExecuted":0, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":0, "totalDefects":0, "createdBy":"ARamirez", "name":"CORE - Regression 2.0", "totalFolders":6, "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "1739":{ "totalExecutions":42, "totalExecuted":22, "versionName":"Unscheduled", "expand":"executionSummaries", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":42, "totalDefects":0, "build":"", "createdBy":"KVonStorch", "ended":"", "name":"LaunchDarkly Test Cycle", "totalFolders":0, "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "2340":{ "totalExecutions":42, "totalExecuted":0, "started":"", "versionName":"Unscheduled", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":42, "totalDefects":0, "build":"", "createdBy":"AndrewWhite", "ended":"", "name":"LaunchDarkly Test Cycle- Build Blocks", "totalFolders":0, "modifiedBy":"andrewwhite", "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "2422":{ "totalExecutions":25, "endDate":"16/Aug/18", "description":"Create cycle with sprint", "totalExecuted":25, "started":"true", "versionName":"Unscheduled", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":25, "totalDefects":0, "build":"", "createdBy":"apiagent", "ended":"true", "name":"AEM Automation-ZAPI", "totalFolders":0, "modifiedBy":"apiagent", "projectId":10101, "createdByDisplay":"APIagent", "startDate":"16/Aug/18", "executionSummaries":{ "executionSummary":[ ] } }, "2423":{ "totalExecutions":0, "endDate":"16/Aug/18", "description":"Create cycle with sprint", "totalExecuted":0, "started":"true", "versionName":"Unscheduled", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":0, "totalDefects":0, "build":"", "createdBy":"apiagent", "ended":"true", "name":"AEM Automation-ZAPI", "totalFolders":0, "modifiedBy":"apiagent", "projectId":10101, "createdByDisplay":"APIagent", "startDate":"16/Aug/18", "executionSummaries":{ "executionSummary":[ ] } }, "2424":{ "totalExecutions":25, "endDate":"16/Aug/18", "description":"Create cycle with sprint", "totalExecuted":25, "started":"true", "versionName":"Unscheduled", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":25, "totalDefects":0, "build":"", "createdBy":"apiagent", "ended":"true", "name":"AEM Automation-ZAPI", "totalFolders":0, "modifiedBy":"apiagent", "projectId":10101, "createdByDisplay":"APIagent", "startDate":"16/Aug/18", "executionSummaries":{ "executionSummary":[ ] } }, "2434":{ "totalExecutions":157, "endDate":"17/Aug/18", "description":"Create cycle with sprint", "totalExecuted":157, "started":"true", "versionName":"Unscheduled", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":157, "totalDefects":0, "build":"", "createdBy":"apiagent", "ended":"true", "name":"RCL - ZAPI - Test Automated Regression (iOS)", "totalFolders":0, "modifiedBy":"apiagent", "projectId":10101, "createdByDisplay":"APIagent", "startDate":"17/Aug/18", "executionSummaries":{ "executionSummary":[ ] } }, "2436":{ "totalExecutions":163, "endDate":"17/Aug/18", "description":"Create cycle with sprint", "totalExecuted":163, "versionName":"Unscheduled", "projectKey":"CORE", "versionId":-1, "environment":"", "totalCycleExecutions":163, "totalDefects":0, "build":"", "createdBy":"apiagent", "ended":"true", "name":"RCI Silver & Gold - 1.10 -Test Automated Regression (Android)", "totalFolders":0, "projectId":10101, "startDate":"17/Aug/18", "executionSummaries":{ "executionSummary":[ ] } }, "recordsCount":20 } ], "10001":[], "14074":[ { "-1":{ "totalExecutions":0, "totalExecuted":0, "started":"", "versionName":"Excalibur 1.9.1", "projectKey":"CORE", "versionId":14074, "environment":"", "totalCycleExecutions":0, "name":"Ad hoc", "projectId":10101, "executionSummaries":{ "executionSummary":[ ] } }, "2400":{ "totalExecutions":166, "endDate":"14/Aug/18", "description":"Create cycle with sprint", "totalExecuted":166, "started":"true", "versionName":"Excalibur 1.9.1", "projectKey":"CORE", "versionId":14074, "environment":"", "totalCycleExecutions":166, "totalDefects":0, "createdBy":"apiagent", "ended":"true", "name":"RCI Silver & Gold - 1.9.1 -Test Automated Regression (Android)", "totalFolders":0, "modifiedBy":"mparra", "projectId":10101, "createdByDisplay":"APIagent", "startDate":"14/Aug/18", "executionSummaries":{ "executionSummary":[ ] } }, "2409":{ "totalExecutions":146, "endDate":"15/Aug/18", "description":"Create cycle with sprint", "totalExecuted":146, "started":"true", "versionName":"Excalibur 1.9.1", "expand":"executionSummaries", "projectKey":"CORE", "versionId":14074, "totalCycleExecutions":146, "totalDefects":0, "createdBy":"apiagent", "ended":"true", "name":"RCI Silver & Gold - 1.9.1 - Test Automated Regression (iOS)", "totalFolders":0, "modifiedBy":"mparra", "projectId":10101, "startDate":"15/Aug/18", "executionSummaries":{ "executionSummary":[ ] } }, "recordsCount":3 } ] } ... View more

My current SPL is like below in which currently weeks are hard -coded with values. | eval "06-04-2018" = if(P1C>0 OR P2C>0,"R",if(P3C>0,"Y","G")) | eval "05-28-2018" = if(P1P1>0 OR P2P1>0,"R",if(P3P1>0,"Y","G")) | eval "05-21-2018" = if(P1P2>0 OR P2P2>0,"R",if(P3P2>0,"Y","G")) | eval "05-14-2018" = if(P1P3>0 OR P2P3>0,"R",if(P3P3>0,"Y","G")) | eval "05-07-2018" = if(P1P4>0 OR P2P4>0,"R",if(P3P4>0,"Y","G")) | table "Project","05-07-2018","05-14-2018","05-21-2018","05-28-2018"," 06-04-2018" | sort Project Using above query in SPL, data is in showing in below structure(Project field is already exist in the event data). [Screenshot attached ] Now I want to display my header column with week’s date. I modified query as advised by you but it did not work. | eval current = strftime(relative_time(now(),"@w1"),"%m-%d-%Y") | eval A = if(P 1C>0 OR P2C>0,"R",if(P3C>0,"Y","G")) | eval {current} = A Thanks in advance for your help! alt text ... View more

I want to display column name with a date as an output of eval command and This date is also coming from a eval command output. Hope this information helps you to provide me solution. Thanks in advance! ... View more