使用不要为我的查询工作 [英] Using Let not working for my Query

问题描述

let start =前（ 5 h）;

let start = ago(5h);

推荐答案

嗨罗吉尔， 

Hi Rogier, 

如果目的是获取数据集的前101行（现在和最后5个小时之间的跟踪联合，
请求，pageViews，依赖项，customEvents，availabilityResults，exception）以及itemType上的where条件（就像你有上文） 您的查询应该有效。

If the intent is to fetch the top 101 rows of the data set (which is union of traces, requests , pageViews, dependencies , customEvents , availabilityResults, exceptions ) between now and last 5 hrs with a where condition on itemType (as you have above)  the query you have should work.

您只需使用以下查询查看结果，该查询应返回您要查找的整个数据集

To simply you can view the results with below query, which should return the entire data set you are looking for

let start = ago(5h); 
union traces, requests , pageViews, dependencies , customEvents , availabilityResults, exceptions
| where itemType == 'trace' or itemType == 'request' or itemType == 'pageView' or itemType == 'customEvent' or itemType == 'exception' or itemType == 'dependency' or itemType == 'availabilityResult' and timestamp >= start and timestamp <= ago(0d)

此外，您可以添加以下最佳结果 

Further you can add your top results as below 

let start = ago(5h); 
union traces, requests , pageViews, dependencies , customEvents , availabilityResults, exceptions
| where itemType == 'trace' or itemType == 'request' or itemType == 'pageView' or itemType == 'customEvent' or itemType == 'exception' or itemType == 'dependency' or itemType == 'availabilityResult' and timestamp >= start and timestamp <= ago(0d)

| top
101
by timestamp desc

希望以上信息有所帮助，如果您有进一步的疑问，请退回。 

Hope above information helps, please revert back if you have further queries. 

这篇关于使用不要为我的查询工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！