{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"minLevel":{"value":"1"},"maxLevel":{"value":"2"},"type":{"value":"flat"}},"macroMetadata":{"macroId":{"value":"d315f97da4d267e9f2155f1cece6d047"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"6806c1b0-9c4e-42ad-b13b-47aa6d8b8536"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"What permissions do I need?","type":"text"}]},{"type":"paragraph","content":[{"text":"To run a LINQ query using the free text of the ","type":"text"},{"text":"Data search","type":"text","marks":[{"type":"strong"}]},{"text":" → ","type":"text"},{"text":"Explore your data → Free text query","type":"text","marks":[{"type":"strong"}]},{"text":" area you need to have the ","type":"text"},{"text":"manage","type":"text","marks":[{"type":"strong"}]},{"text":" level of the ","type":"text"},{"text":"Free text queries","type":"text","marks":[{"type":"strong"}]},{"text":" permission, otherwise you will not see the tab in this area. Take into account that you need to activate any level of the parent permission (Finders)","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"to enable the permission checkbox.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":751,"id":"c1b25dd0-4965-4e37-b8d9-b83bf3dfcfdf","collection":"contentId-313865025","type":"file","height":422}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Running the LINQ free-text query","type":"text"}]},{"type":"paragraph","content":[{"text":"If you are familiar with LINQ scripting, the free-text query can be a convenient option to query data. Using this option, you can access a data table and build your query directly, without using the search window tools.","type":"text"}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-ui-steps-macro","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"81d4c648-9563-462a-836f-fa1a1123caca"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/steps.png"}}],"title":"UI Steps"}},"localId":"0f6fe30f-5ac1-4322-8f0f-c5142c280851"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"6b06fdfa-0021-430e-9ac8-717b025b55f9"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"faccb8d4-81a5-462d-959c-0428452b9893"}},{"type":"paragraph","content":[{"text":"Go to ","type":"text"},{"text":"Data search → Explore your data","type":"text","marks":[{"type":"strong"}]},{"text":", then open the ","type":"text"},{"text":"Free text query","type":"text","marks":[{"type":"strong"}]},{"text":" tab. ","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"decc1473-2ebf-4791-a3d3-461a39ee3a2d"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"452febb0-7efb-4487-a1c5-471c448804fc"}},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"section below","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":" for more info).","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":312,"id":"2f20618d-0cf1-4ee7-9004-7f80815891b4","collection":"contentId-313865025","type":"file","height":92}}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"3c399c4a-bc5a-48fb-97d5-5bbf36ff55f1"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"6bb5240d-ec43-4668-bb28-b0a625d1a942"}},{"type":"paragraph","content":[{"text":"Enter your LINQ query. Click on ","type":"text"},{"text":"Show table fields","type":"text","marks":[{"type":"strong"}]},{"text":" 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.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1857,"id":"49bfc389-de10-4067-bff2-4a6c3901d66a","collection":"contentId-313865025","type":"file","height":752}}]},{"type":"paragraph","content":[{"text":"To learn more about the LINQ syntax and how to build a query using this language, go to","type":"text"},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}}]},{"text":"Build a query using LINQ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}},{"type":"link","attrs":{"href":"/wiki/spaces/713/pages/313865957"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#bf2600"}}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"014fca86-6067-417d-8629-ccd562abf9ad"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"b7e11e1e-fffd-4c91-8099-58e618370d3f"}},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Select all fields","type":"text","marks":[{"type":"strong"}]},{"text":" 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.","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"fc58cdc3-454e-40e9-9cac-fd84d0f9f4c1"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"4dff48b1-bedd-4da6-ac20-6506db45c01d"}},{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Run ","type":"text","marks":[{"type":"strong"}]},{"text":"when you are ready or use the shortcut keys ","type":"text"},{"text":"CTRL+Enter","type":"text","marks":[{"type":"strong"}]},{"text":" in PC and ","type":"text"},{"text":"CMD+Enter","type":"text","marks":[{"type":"strong"}]},{"text":" in Mac (hover over the ","type":"text"},{"text":"Run","type":"text","marks":[{"type":"strong"}]},{"text":" button to see the shortcuts).","type":"text"}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"LINQ examples","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Some LINQ examples are displayed in the ","type":"text"},{"text":"Help","type":"text","marks":[{"type":"strong"}]},{"text":" area on the right side of the window. Click the question mark icon to open this up.","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":1798,"id":"183394ae-ee00-401d-8ab6-6be3adc16ae6","collection":"contentId-313865025","type":"file","height":419}}]}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"time-settings"}},"macroMetadata":{"macroId":{"value":"74c8933a3aa04d92cf0d5f57511548c7"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"9b227cb7-f5c7-4334-952f-6fdc77c615f1"}}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Setting time ranges for LINQ free-text query","type":"text"}]},{"type":"paragraph","content":[{"text":"When setting time ranges, it is important to consider different aspects related to the type of time range specified and the method chosen to do it. You can use the interface to set ","type":"text"},{"text":"absolute","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"relative","type":"text","marks":[{"type":"strong"}]},{"text":", or ","type":"text"},{"text":"snap-to","type":"text","marks":[{"type":"strong"}]},{"text":" dates:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Absolute","type":"text","marks":[{"type":"strong"}]},{"text":": a specific interval with fixed start and end dates to see data from a specific time period.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Relative","type":"text","marks":[{"type":"strong"}]},{"text":": a period of time relative to the current date (last 5 minutes, last day, etc.) to see data progression up to the present.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Snap to","type":"text","marks":[{"type":"strong"}]},{"text":": a period of time that goes back to the starting point of the selected time frame to see data without unrepresentative data samples resulting from analyzing incomplete periods. For example, if it is 10:53:17 on a Tuesday:","type":"text"}]}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":3}}],"content":[{"text":"Snap to the day: you will see data beginning at 00:00 on that same Tuesday.","type":"text"},{"type":"hardBreak"},{"text":"Snap to the hour: you will see data beginning at 10:00.","type":"text"},{"type":"hardBreak"},{"text":"Snap to the minute: you will see data beginning at 10:53:00.","type":"text"}]},{"type":"paragraph","content":[{"text":"You can set a time range using the interface or manually introduce time expressions. Select the corresponding tab below to see the desired method.","type":"text"}]},{"type":"bodiedExtension","attrs":{"layout":"full-width","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-ui-tabs-macro","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"3273b8fc-f13a-4f89-b3a9-d6ac912b8a56"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/tabs.png"}}],"title":"UI Tabs"}},"localId":"4d6afa44-5e2f-4555-ad5c-eccb4684d825"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-tab","parameters":{"macroParams":{"title":{"value":"Using the interface"}},"macroMetadata":{"macroId":{"value":"3e53bea9a1de0bb6da70598814225df7"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/tab.png"}}],"title":"UI Tab"}},"localId":"3e0f56c0-ee71-4f38-b594-26113b937979"}},{"type":"paragraph","content":[{"text":"You can set a time interval following the steps described in the picture below.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":100.0},"content":[{"type":"media","attrs":{"width":766,"id":"1a2a42dc-b60e-4962-9be8-679c85cf0a64","collection":"contentId-313865025","type":"file","height":205}}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-tab","parameters":{"macroParams":{"title":{"value":"Using date language expressions"}},"macroMetadata":{"macroId":{"value":"36253043809e66b2296999d1877a3c24"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/tab.png"}}],"title":"UI Tab"}},"localId":"a29f9a80-b86d-48ae-b176-8a65df8c5451"}},{"type":"paragraph","content":[{"text":"You can also introduce time ranges manually using ","type":"text"},{"text":"date language expressions","type":"text","marks":[{"type":"strong"}]},{"text":", 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 ","type":"text"},{"text":"Apply","type":"text","marks":[{"type":"strong"}]},{"text":" when you finish. When the and the expressions will be translated into the corresponding dates.","type":"text"}]},{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"Your ","type":"text"},{"text":"from","type":"text","marks":[{"type":"strong"}]},{"text":" date cannot be after your ","type":"text"},{"text":"to","type":"text","marks":[{"type":"strong"}]},{"text":" date and your ","type":"text"},{"text":"to","type":"text","marks":[{"type":"strong"}]},{"text":" date cannot be in the future.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"You can use a mix of both absolute and date language expressions in any given time range (for example, the ","type":"text"},{"text":"to","type":"text","marks":[{"type":"strong"}]},{"text":" date can be relative and the ","type":"text"},{"text":"from","type":"text","marks":[{"type":"strong"}]},{"text":" date absolute, and vice versa). For date language expressions, the current moment \"now()\" is used as the reference point.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Operators","type":"text"}]},{"type":"paragraph","content":[{"text":"You can establish absolute dates in the required format:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"e85156f8-54c1-46ec-822f-55e3af9c84b4"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"yyyy-MM-dd hh:mm:ss","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Establishes the specified absolute date","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"2021-06-30 15:35:23","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"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:","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","localId":"71c1a77f-38df-4075-8ce4-91f152fa51e9"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"Operator","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Action","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"Snap to (@) or |<","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Rounds the date to the beginning of a time unit. Note that this operator only works with 1m, 1d, 1h, 1w, 1W, 1M and 1y.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1m or now() |< 1m","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"Arithmetics (+/-)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Applies an offset to the date (date + offset or date - offset)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"now() - 3h","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"Replace (^)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Replaces part of the date by a time unit (date ^ time_unit)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"now() ^ 6d","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"Backward & forward (>>/<<)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Shifts the date to the next/past time unit (date >> time_unit or date << time_unit)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"now() << 11M","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Time Expressions","type":"text"}]},{"type":"paragraph","content":[{"text":"Let's suppose the current time (which we refer to as \"now()\") is ","type":"text"},{"text":"Sunday, 05 February 2017, 13:37:05. ","type":"text","marks":[{"type":"strong"}]},{"text":"The table below shows the resulting time when different expressions are applied. Note that this isn't an exhaustive list:","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","localId":"9f9c6d26-ea15-4cee-845b-a88c2058c461"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"Time expression","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Resulting time","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() - 60m","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"60 minutes ago","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Sunday, 05 February 2017, ","type":"text"},{"text":"12","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":":37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1h","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Now (rounded to the beginning of the hour)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Sunday, 05 February 2017, 13:","type":"text"},{"text":"00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() - 24h","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"24 hours ago","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Saturday, ","type":"text"},{"text":"04","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"(now() - 1d) @ 1d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Yesterday (rounded to the beginning of the ","type":"text"},{"text":"day","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Saturday, ","type":"text"},{"text":"04","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"(now() - 2d) @ 1d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"2 days ago (rounded to the beginning of the ","type":"text"},{"text":"day","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Friday, ","type":"text"},{"text":"03","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"(now() - 2d) @ 1m","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"2 days ago (rounded to the beginning of the ","type":"text"},{"text":"minute","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Friday, ","type":"text"},{"text":"03","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, 13:37:","type":"text"},{"text":"00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"((now() - 2d) @ 1d) - 2h","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"2 days ago (rounded to the beginning of the ","type":"text"},{"text":"day minus 2 hours","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":")","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Thursday, ","type":"text"},{"text":"02","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, ","type":"text"},{"text":"22:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1w","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Locale week","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Sunday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 05 February 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() @ 1W","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"ISO week","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Monday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", ","type":"text"},{"text":"30 January","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" 2017, ","type":"text"},{"text":"00:00:00","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() ^ 6d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Replace the day with 6","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Monday, 06","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":" February 2017, 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() ^ 2018y3M6d15h30m20s","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Replaces the year with 2018","type":"text"},{"type":"hardBreak"},{"text":"Replaces the month with 3","type":"text"},{"type":"hardBreak"},{"text":"Replaces the day with 6","type":"text"},{"type":"hardBreak"},{"text":"Replaces the hour with 15","type":"text"},{"type":"hardBreak"},{"text":"Replaces the minutes with 30","type":"text"},{"type":"hardBreak"},{"text":"Replaces the seconds with 20","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Tuesday, 06 March 2018, 15:30:20","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() >> 2M","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Forward to ","type":"text"},{"text":"next","type":"text","marks":[{"type":"strong"}]},{"text":" second month","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Monday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 05 February ","type":"text"},{"text":"2018","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() << 2M","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Backward to ","type":"text"},{"text":"previous","type":"text","marks":[{"type":"strong"}]},{"text":" second month","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Friday","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 05 February ","type":"text"},{"text":"2016","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":", 13:37:05","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() >> 2M6d15h20m10s","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Forward to ","type":"text"},{"text":"next","type":"text","marks":[{"type":"strong"}]},{"text":" second month, sixth day, fifteenth hour, twentieth minute and 10 seconds","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Tuesday, 06 February 2018, 15:20:10","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[220.0]},"content":[{"type":"paragraph","content":[{"text":"now() << 1h/1d","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Goes back to the first hour of the current day. Minutes and seconds don't change.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[213.0]},"content":[{"type":"paragraph","content":[{"text":"Sunday, 05 February 2017, 01:37:05","type":"text"}]}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Edit LINQ queries in the search window","type":"text"}]},{"type":"paragraph","content":[{"text":"After opening a data table, users can access the ","type":"text"},{"text":"Query code editor","type":"text","marks":[{"type":"strong"}]},{"text":" tool available on the search window toolbar to keep on querying data using LINQ:","type":"text"}]},{"type":"bodiedExtension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-ui-steps-macro","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"8bcf2501-d068-4bc3-9db6-932801af77d9"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/steps.png"}}],"title":"UI Steps"}},"localId":"0407e7d1-80f5-4246-a2f9-104959a0f09d"},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"f9749cb5-a5b2-490e-a2cf-8e0cb5b31970"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"3bca9b74-f8ce-4616-bbec-1b20c8dcb17a"}},{"type":"paragraph","content":[{"text":"After opening a data table, you can find the query code editor at the top right area of the window.","type":"text"}]},{"type":"paragraph","content":[{"text":"If it is not there, select the ","type":"text"},{"text":"Query code editor","type":"text","marks":[{"type":"strong"}]},{"text":" button in the search window toolbar to display it. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":222,"id":"6df99871-4727-48e1-ac63-0b071c822bd3","collection":"contentId-313865025","type":"file","height":28}}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"42789d76-324f-47d5-a257-b6a7237b69ca"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"88622069-4464-4fcf-a37e-76551f5af508"}},{"type":"paragraph","content":[{"text":"Write or edit your query in the editor. If you need to check the available fields on the table, click on ","type":"text"},{"text":"Show table fields ","type":"text","marks":[{"type":"strong"}]},{"text":"and the list will appear on the right.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":347,"id":"83e86b9b-ce05-41fe-8815-cc06f759ee2a","collection":"contentId-313865025","type":"file","height":244}}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"rw-step","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"16fdcaf3-76f6-4595-a31b-0279ab4b48d0"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://d1bgdtsfe1sjdg.cloudfront.net/refinedtheme-for-cloud/macro-icons/step.png"}}],"title":"UI Step"}},"localId":"350dd491-b87e-4ee0-9fd8-3e335d68eaae"}},{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Run","type":"text","marks":[{"type":"strong"}]},{"text":" to retrieve the results of the query.","type":"text"}]}]},{"type":"paragraph","content":[{"text":"If you are not familiar with LINQ you can learn how to query using this language in ","type":"text"},{"text":"Build a query using LINQ","type":"text","marks":[{"type":"link","attrs":{"href":"https://docs.devo.com/space/latest/95191261/Build+a+query+using+LINQ"}}]},{"text":". ","type":"text"}]}],"version":1}

Browser not supported