Table of Contents | ||||||
---|---|---|---|---|---|---|
|
...
Rw ui steps macro | |||||||
---|---|---|---|---|---|---|---|
Go to Data search → Explore your data, then open the Free text query tab.
Click the time range box at the right area to open the calendar and select the time period over which you want to search (see the section below for more info).
Enter your LINQ query. Click on Show table fields next to the time range calendar to get a summary of the available fields for your query. Close this window by clicking on the X tab. To learn more about the LINQ syntax and how to build a query using this language, go toBuild a query using LINQ.
The Select all fields option is checked by default. This will show all the fields of the table no matter the ones you use in your query. Uncheck this option if you only want to see the fields specified in your query when you access the search.
Click Run when you are ready or use the shortcut keys CTRL+Enter in PC and CMD+Enter in Mac (hover over the Run button to see the shortcuts). If there are syntax errors, you will be alerted to make corrections. Otherwise, the data table will open to display the results of your query.
|
...
Rw ui tabs macro | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
You can set a time interval following the steps described in the picture below.
You can also introduce time ranges manually using date language expressions, which gives you more flexibility and precision when searching your data. Simply click on the date field and write the desired time expression or edit the existing one. The field turns red and an explanatory message appears until a valid date is entered. Click Apply when you finish. When the and the expressions will be translated into the corresponding dates.
You can use a mix of both absolute and date language expressions in any given time range (for example, the to date can be relative and the from date absolute, and vice versa). For date language expressions, the current moment "now()" is used as the reference point. OperatorsYou can establish absolute dates in the required format:
With date language expressions, use a series of mathematical operations to move away from the current time which is used as the reference point. You can use multiple operators at once and the execution order is from left to right:
Time ExpressionsLet's suppose the current time (which we refer to as "now()") is Sunday, 05 February 2017, 13:37:05. The table below shows the resulting time when different expressions are applied. Note that this isn't an exhaustive list:
|
...
Rw ui steps macro | |||||
---|---|---|---|---|---|
After opening a data table, you can find the query code editor at the top right area of the window. If it is not there, select the Query code editor button in the search window toolbar to display it. View file | | name | Invalid file id - f291bef4-50e1-4108-af2a-941062c2374d
Rw step |
---|
Write or edit your query in the editor. If you need to check the available fields on the table, click on Show table fields and the list will appear on the right.
Rw step |
---|
Click Run to retrieve the results of the query.
...