Search results can be exported to MS Excel and many other available formats. A simple query in JQL (also known as a “clause”) consists of a eld, followed by an operator, followed by one or more values or functions. g. name. ro. Learn more about the power of JQL queries. It can be found on the Atlassian Marketplace and is compatible with Cloud, Server, and Data Center. In the JQL Cheat Sheet it says that the function "currentLogin ()" is associated with the data field type "People". Project = "xyz" AND Type = "Epic". Our app, JQL Search Extensions, solves JQL limitations. For example:e. Hi, I'm currently learning JQL and enrolled for the "Gain Project Insights through JQL" course in the Atlassian University. JQL, or Jira Query Language, is a powerful tool that allows users to search and filter issues in Jira. Status in the provided list. com Download the JQL (JIRA Query Language) Cheat Sheet 2 Pages //media. Edit the required workflow. Validate that all checklist items are. g. Benefits: JQL helps to find specific issues quickly, to be used for better overview, boards or reports. For example: project = Test field operator value. For example:MySQL is the most popular, Oracle backed, open-source Structured Query Language. So far so good. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. Keyboard Shortcuts for Sublime Text 2 for Windows. org on 2019-10-31 by guest Atlassian Jira makes it easier to track the progress of your projects, but it can lead to repetitive and time-consuming tasks for teams. If the basic search is shown instead of the advanced search, select Advanced (next to the Search button). g. 750. Get Unassigned Tasks assignee is EMPTY Groups. ; Start typing a search, or scroll through the on-screen options, and select the JQL. “Jira JQL Basics and Reference Guide” covers every element of a JQL search and will quickly get you writing complex JQL Issue searches (called queries). This extraordinary. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. For example: project = Test field operator value. pdf - Free download as PDF File (. . G subramanyam. Search results displays in the Issue Navigator. This course will get you started with how search works in Jira. fixVersion, issue type, date created, etc. JQL is an incredibly powerful tool when it comes to searching Jira – and being able to efficiently and effectively search through your Jira instance is key to not only maintain but also optimize your workflow. Queries on multiple fields. In Jira Software, the Kanban project gives you an out-of-the-box workflow with Backlog, Selected for Development, In Progress, and Done. Download Atlassian JIRA JQL Cheat Sheet PDF now. The documentation is available online and in downloadable format (PDF, XML for some versions, HTML for some versions). text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. You can also edit the sharing settings. roam~ Add ~and a number to the end of a phrase in quotes The advanced search is the most powerful and flexible way to search for your issues in Jira. rhorber. Set up your first project, build your board, and invite your team. g. Go to the Filters dropdown > select the “…” button for the filter you want to share > Edit. In a clause, a field is followed by an operator, which in turn is followed by one or more values (or functions). That process is already underway and I am joining mid-stream. g. <remote>, along with necessary commits and objects. g. Some things—like a product’s search function—are better left in a simple, familiar format that people already know how to use. g. Thank you @Nic Brough -Adaptavist- for the titles. Then, click on Create Filter. Atlassian_JQL Cheat SheetJQL Cheat Sheet JQL Cheat Sheet simple query in JQL (also known as a “clause”) consists of a eld, followed by an operator, followed by one or more values or functions. Field - Fields are different types of. On the ‘ Create issue ’ screen you’ll see a range of predetermined fields you need to fill in. Greetings. Hi, I'm currently learning JQL and enrolled for the "Gain Project Insights through JQL" course in the Atlassian University. Under “Issues” in the dropdown menu, you can find the “Search for Issues” option: This will open up the search screen. Generators are special rules that define how your structure should be built. 28. Jql Jira Cheat Sheet jql-jira-cheat-sheet 2 Downloaded from oldshop. g. Open navigation menu Whatever the reason, creating an issue in Jira is easy: 1. l y/ 3rFJxTl Operators = , != equals, not equals > , >= (strictly) greater than < , <= (strictly) lesser than ~ , !~ contains, do not contain A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira fields. py # Import convention >>> import streamlit as st Command line streamlit --help streamlit run your_script. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. JQL Cheat Sheet - Free download as Text File (. So the way JIRA is doing this is by looking at the Sprint field on these issues. For example:e. teses. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. g. org on 2019-10-11 by guest available. You can use the Jira issue integration developed by GitLab with Jira Cloud, Jira Data Center, or Jira Server. A quick reference of the possible text formatting options in Jira Descriptions and Comments. Learn how to create, search, and work with issues in software projects, manage your profile, and more. Slashes indicate options, AltBy doing advanced searches with Profields Query Language (PQL), you will find projects as you need, getting the key to a whole new world of advanced searches in Jira. For example:Here are the ways to import Jira data in a spreadsheet: 1. py streamlit hello streamlit config show streamlit cache clear streamlit docs streamlit --versionš ˘“ ˚˜• † ˘ ˘ †• †˘˝˘˚ ˇ• ˝˘˚• “• ˘ •†• ˚ ˝ ˜• “•˝ ˛ ˘† ˚• “ ˝˝ † ˘“ ˘“˘˚ ˘˚ ˚ git: ˛• ˝Jira issue integration. For example:ScriptRunner's scripted JQL functions are a life-saver to Jira admins performing many advanced search queries. I'm working with a customer who is migrating over from Zendesk to Jira Service Desk. Select a desirable text format, color, style, etc. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. View the guide. Some operators may use the NOT keyword. By learning JQL, you can save time and effort by quickly finding the issues that you need to work on or track. com/126118/cs/24324/ Rules classic query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functio‐ ns. Also, let us know if their are any webinars on this topic going forward. JQL Cheat Sheet Search syntax for text field Escaping special characters (It is a Jira Server 8 documentation, but for escaping characters, it is still valid for Cloud as well) JQL keywords Correct answer: 3 Explanation: 1. Journal: A log in JIRA that records changes made to an issue. Download atlassian-jql-cheat-sheet-2 PDF for free. Nested filters can have performance problems, and if uses as agile board filters Jira may not be able to work out which projects you need to have Manage Sprint permissions forView ACP-120. nopanel: Embraces a block of text within a fully customizable panel. Atlassian_JQL Cheat Sheet Atlassian JQL Cheat Sheet For full instructions on advanced searching in JIRA Software, please visit: Replace single character with ? e. The optional parameters you can define are the following ones: Example: preformatted piece of text so *no* further _formatting_ is done here. Writing Complex JQL Queries in Jira Software. Find API documentation and guides for developing apps and integrations. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. If you cannot switch to an advanced search, check out the following section. When I run this query using JQL in jira its working fine. JIRA 1 Example Paragraph. The operator. But from my understanding the correct. A function performs a calculation on either specific. project = TEST AND assignee in (currentuser())A classic query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functions. Advanced search is a powerful tool for getting project data. The dialog is divided into sections for the following information: Global shortcuts – shortcuts that can be used when you are in any. Tutorial #7: JIRA Agile Tutorial. startOfWeek ('-1d'). Find the item to be inserted and select it. Integrate your issues and development tools. For example:Staff, Following is my requirement. In the top navigation bar, select Filters dropdown. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. Click Edit (If you have a search in progress) Click Advanced Searching. g. JQL (JIRA Query Language) Cheat Sheet to justinbyrne. Sometimes you need to mix both AND and OR conditions. . I want to access all records in the JIRA database by UNIX command-line or browser-based CGI queries. . text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. JQL Cheat Sheet. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. This alias can be used to find issues that had a comment made on them on a particular date. g. Here’s what you need to do: 1. g. WebDec 19, 2017 · JQL (JIRA Query Language) Cheat Sheet by justinbyrne Cheatsheet for JIRA's Query Language Constructing JQL Queries A simple query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed. Click ‘ Create ’ in the top ribbon (alternatively, hit ‘C’ on your keyboard) 2. Tutorial #6: Administration and User Management. This Best Practice includes. Give the filter a meaningful name, such as “Open stories. 8h. Enter a keyword in the search bar or Switch to JQL and1. g. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. e. Component component is a sub-division of a JIRA Project, we use Components to refer to Build work Deployed The task has passed client acceptance and has been put onto the live site/s‐ ystem. Learn how Jira Query Language, or JQL works with JQL Cheat Sheet. When people talk about Jira, they usually mean “Jira Software”. JIRA JQL Cheat Sheet No. JQL query consists of a field, followed by an operator,. e. This book provides a comprehensiv e explanation covering all major components of Jira, including Jira Software, Jira Core, and Jira Service Desk. For example, you can use the ORDER BY clause in a JQL. If I use this in my restful API the library or underlying component uri encodes it, so when it gets to the Jira server. If you’ve made a custom field, you’ll be asked to name the field. Sometimes you need to mix both AND and OR conditions. But even their cheat sheet is confusing. g. whitney. You can use a JQL filter to make a board that shows the relevant issues based on whatever criteria you want. In Jira Software Cloud, you can set up different types of permissions and access rights for users. Download This Cheat Sheet (PDF) Comments; Rating: Home > Software > Jira Cheat Sheets. for example. Jira Jql Cheat Sheet Pdf Atlassian’s JIRA lets you work smarter, instead of harder. I need a query that list down all stories that are in Inception, discovery Elucidation, grooming statuses a. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. Atlassian also covers theSearch for jobs related to Jira jql cheat sheet or hire on the world's largest freelancing marketplace with 22m+ jobs. manage issue layout configurations. Click Help > Keyboard shortcuts. Use modified queries to locate unassigned issues. In Jira, define a search that retrieves exactly the set of issues you need; Use the “Save as” to save it as a filter. e. Keyword: A keyword in JQL is a word or phrase that does the following: Joins clauses together (for example AND)Adding the Jira Snapshots Macro to a Confluence Page. For example:JQL syntax can be broken down into five primary elements: fields, operators, values, keywords, and functions. atlassian-jql-cheat-ssdsheet-44433. If you're serious about JQL, you should look beyond standard Jira. Constructing JQL Request. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. Languages:. g. User features Related Atlassian documentation: JQL Cheat Sheet Search syntax for text field Escaping special characters (It is a Jira Server. Jira versions earlier than 8. Following query will get all issues and sub tasks related to the epic id "test-24" , please see the attached image. g. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. The XML export (which is not produced anymore) can be used to import the. While basic search provides high-level access to issues, advanced search in Jira uses JQL to create queries to form more complex questions. Education Cheat Sheets. pdfJIRA is used in Bugs, Issues and Change Request Tracking. summary}} Check out how we use smart values in our Jira automation template library. I am trying to use the Does Not Contain operator to identify any issues in my entire JIRA instance where the Summary does not contain the word "411"; So my JQL statement I use is (summary !~ "411"), while this seems straightforward, the search still generates results that have the "411" string in the. Atlassian_JQL Cheat Sheet. pdf. documentclass[10pt,a4paper]{article} % Packages usepackage{fancyhdr} % For header and footer usepackage{multicol} % Allows multicols in tables usepackage{tabularx} % Intelligent column widths usepackage{tabulary} % Used in header and footer usepackage{hhline} % Border under tables usepackage{graphicx} % For images. g. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. By learning JQL, you can save time and efort by quickly finding the issues that you need to work on or track. Download Atlassian JIRA JQL Cheat Sheet PDF now. Given below is the list of JIRA Agile Shortcuts. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. This Git cheat sheet saves you time when you just can't remember what a command is or don't want to use git help in the command line. A simple query in JQL (also known as a “clause”) consists of a field, followed by an operator, followed by one or more values or functions. NOT Negate a clause or JQL query EMPTY , NULL Field without a value ORDER BY Specify the sorting order Official cheat sheet A better version of our cheat sheet is available here : //b it. Learn about Atlassian Enterprise and its Data Center products. Reactivate the Excel export option from the Jira menu. Atlassian_JQL Cheat Sheet. It is a simple yet flexible language that enables users to create complex queries to find the exact information they need. You can use a JQL filter to make a board that shows the relevant issues based on whatever criteria you want. A field is a word that represents a Jira field (for example assignee) or is a custom field that has already been defined in your Jira applications. ME. 5. See full list on atlassian. 1. Keyword: A keyword in JQL is a word or phrase that does the following: Joins clauses together (for example AND) Adding the Jira Snapshots Macro to a Confluence Page. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. Using Jira's simple query builder (JQL), you can customize exactly which issues are displayed on your board. These fields vary depending on the project and issue type. JIRA JQL Cheat Sheet No. g. It is based on the official REST APIs of these products, as well as additional private methods and protocols. By downloading this e-book compiling seven use cases when integrating Automation for Jira and Projectrak, you will learn to: An explanation of how the grammar of the PQL. To find the userid: Jira → Filters → Advanced user search. JQL Cheate Sheet – Atlassian JIRA JQL Cheat Sheet PDF download Atlassian JIRA JQL Cheat Sheet PDF. issuetype = Epic AND "Development. JQL (JIRA Query Language): A proprietary language used in JIRA to search for and display issues. The basic search provides the possibility to do this search with the dropdown menu but sometimes it reaches its limit. Priority Used to determine how important a task is, not the order in which it should be worked on. Team, Following is mys requirement. Access it from the Issue Navigator by choosing “Issues. Save and Subscribe features are available to advanced searches. An advanced search uses the JIRA Query Language known as JQL. JQL is a flexible yet robust logic that can be used in a variety of different ways. Linux (214) Development (149) Python (148)Jira Query Language (JQL) is basically a text-based search language you can use in Jira to find the issues you’re looking for. These will be retrieved by adding a Level 2 to the report. Jira Query Language (JQL) is a powerful tool to search and filter issues in Jira. Jira Software is the #1 agile project management tool used by teams to plan, track, release and support world-class software with confidence. g. They relate the field to the The advanced search is the most powerful and flexible way to search for your issues in Jira. This post contains some of my tips and tricks for working with it. In the permission window, click Allow. One of the things we'll likely do. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. Help customers as a service project agent. Jira will automatically replace the user name with the user id → copy and paste the string from there. The book also covers workflows and business processes, and guides you in setting up incoming and outgoing mail servers. fixVersion, issue type, date created, etc. Advanced search reference - JQL functions. The Add ScriptRunner JQL Function dialog appears. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. Add a table to your checklist by clicking on the table icon or pressing Shift+Alt+T. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. I want to write a JQL query on the basis of custom field value,status of the issue and number of days the issue in the status. 4 Jira Jql Cheat Sheet 2023-10-01 biosensors sensor network sensor data fusion artificial intelligence deep learning mechatronics devices for sensors applications of sensors for robotics and mechatronics devices Strategic Monoliths and Microservices Packt Publishing Ltd Testing is a key component of agile development. If your use case is more dynamic than that, look beyond standard Jira. whitney. Navigate to the page and click the Edit icon, or just type E to open the editor. Cheat Sheets >. If any of the values in that field are closed sprints, then this issue itself should be returned by your query. Create Jira issues for vulnerabilities. from here simply input the JQL and import the data to the current sheet. All the optional parameters of {panel} macro are valid for {noformat} too. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. Then find out how to use Jira features to make it easier to write queries. ”. whitney. Question: is there a grammar-construct in the JIRA() function to reference the value of a cell?. Four short, self-paced courses to help Jira Software users efficiently use Jira Software features and functions to keep their focus where it counts. documentclass[10pt,a4paper]{article} % Packages usepackage{fancyhdr} % For header and footer usepackage{multicol} % Allows multicols in tables usepackage{tabularx. Home and Health Cheat Sheets. I know that closedSprints () gives ALL sprints that have been closed. Jira Query Language, or JQL, is a powerful way to search for issues in Jira. Scribd is the world's largest social reading and publishing site. Jql Cheat Sheet Atlassian 3 3 release, the Jira team has now expanded their user base to agile teams as well as business teams. net Setup Instru ctions Send e-mail to QA Team Lead to setup the project Provide the names, and user roles of QA team members or other users who would require access to the project. RELEASE Spring Data JPA - Reference Documentation 4 4. This Certification is only applicable to users of Cloud implementations of Jira. 0. Example JQL queries for board filters. win* Add ~to the end of a single term e. We’ve. atlassian_jql-cheat-sheet. In the JQL Cheat Sheet it says that the function "currentLogin ()" is associated with the data field type "People". For example:e. For example:demonstrate expertise in JQL, reports, dashboards, and gadgets. JQL life hacking Use a Jira filter. PDF (black and white) LaTeX Overview of Jira Query Language Interface. It also supports navigation with keyboard shortcuts (J = down, K = up, N = next column, and P = previous column). text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. g. Issue – An issue is simply a unit of work within Jira that will be traced through a workflow, from creation to completion. 1. Scribd is the world's largest social reading and publishing site. I'd also like to find an exhaustive JQL command reference online. g. Metadata. To change your default columns in Jira: 2. Jira Jql Cheat Sheet Jira Jql Cheat Sheet Book Review: Unveiling the Magic of Language In an electronic digital era where connections and knowledge reign supreme, the enchanting power of language has be apparent than ever. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. It can range from representing a single unit of work, like a simple task or bug, to a larger parent work item to. Tutorial #3: How to Use JIRA as a Ticketing Tool. Queries are a series of simple elements strung together to form a more complex question. JQL - Does not contain operator (!~) usage. 19 Oct 11, updated 12 Mar 20. Developed by the Australian company Atlassian in 2002, Jira Software receives regular updates. The operator compares the value of the field with one or more. g. A cheatsheet for using Jira JQL. Many Jira users or admins have to. Atlassian JIRA JQL Cheat Sheet Atlassian JIRA JQL Cheat Sheet hotkeys Atlassian JIRA JQL Cheat Sheet PDF jql cheat sheet jql cheat sheet Atlassian jql cheat sheet deutsch jql cheat sheet pdf jql search cheat sheet. For example:e. g. JQL is not SQL, and all it does is fetch the current list of issues matching the query. Reporting (15-20% of exam) Translate business requirements into appropriate JQL queries Determine an appropriate gadget and dashboard configuration Analyze information from agile reports and issue analysis reports Recognize how Jira can facilitate agile at scale . For example:please define productname in your docbook file! 1. JQL stands for JIRA Query Language, used for advanced issue filtering. 1 Page. A keyword in JQL is a word or phrase that does (or is) any of the following: joins two or more clauses together to form a complex JQL query. For example:This collection of 100 JQL queries is a result of a few years of collecting examples during my work as Jira Consultant and during my preparations for Atlassian ACP exams. You can use the Jira Query Language (JQL) to specify criteria that cannot be defined in the quick or basic searches. e. By default, this screen brings you to the basic search tool. This page describes information about functions that are used for advanced searching. pdf. It's free to sign up and bid on jobs. g. JQL (Jira Query Language) is a powerful tool which allows you to base your search on criteria that you can’t specify in the basic search. It is the single source of truth for your entire development lifecycle, empowering autonomous teams with the context to move quickly while staying connected to the greater business goal. atlassian_jql-cheat-sheet. Facebook Twitter Tumblr Pinterest WhatsApp Telegram Viber Print. e. atlassian^4 jira Fields A simple query in JQL (also known as a “clause”) consists of a ˜eld, followed by an operator, followed by one or more values or functions. justinbyrne. e. We supply documentation for previous versions of the documentation, including Jira, Jira Service Desk, and Jira Agile. However this query is not working. In this new window, you can edit details such as the filter name, the filter description and favorites settings. From the project sidebar, select Reports. A quick reference of the possible text formatting. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. These fields vary. text ~ '"Atlassian jira"~10' Add ^ with a boost factor (a number) to the end of a search term e. I tried the below but the JIRA still appears. CompanyDomains !~ "DomainC*" => but does not work So wanted to s. In a clause, a function is preceded by an operator, which in turn is preceded by a field. JQL Cheat Sheet – Atlassian JIRA JQL Cheat Sheet PDF; 50 City Car Driving Shortcuts – City Car Driving Game Shortcuts; Mouse without Borders Shortcuts – {10} Borders Shortcuts; Pixlr Editor Web Shortcuts – {45} Pixlr Editor Shortcuts PDFe. To generate a report: Navigate to the project you want to report on. teses. Cheat Sheets by Tag. Atlassian’s JQL Cheat Sheet (source). g. Jira Jql Cheat Sheet jira-jql-cheat-sheet 2 Downloaded from oldshop. From the main navigation, select Search and Go to all: Issues. 1 Mar 18. The Essential Spellbook to Unleash Advanced Jira Query Language (JQL) Magic | 01 If your company has been using Jira for some time, there may be thousands of issues in your Jira instance. These complex and sometimes. my new sprint starts from say 18th october. You must be a registered user to add a comment. Tutorial #7: JIRA Agile Tutorial. Definition: Jira search allows structured requests to find issues via Jira Query Langua ge (JQL). Jim Stewart Oct 21, 2020. Get the repository instance injected and use it. Tutorial #2: JIRA Download, Installation, and License Setup. I am trying to query using JIRA function. performs a specific function that alters the results of a JQL query. pdf from CS DD301 at BITS Pilani Goa. For example:Create an issue. One of the courses resources is the JQL Cheat Sheet. Native in Jira Permission Validate that the user has a permission Native in Jira Separation of duties Prevent a user to perform the transition, if the user has already performed a transition on the issue Native in Jira ProForma Forms: form(s) attached Validate that there is at least one form attached Native in JiraTerms defined in the Cheat Sheet: Agile methodology, Scrum approach to project management, Kanban approach, Sprints, Issues, Tickets, Jira Query Language (JQL) for issue search, Backlog and version search, Burndown reporting tool and charts and dashboard generation functionalities in JIRA tool. View the guide. JQL Cheat Sheet – Atlassian JIRA JQL Cheat Sheet PDF download Atlassian JIRA JQL Cheat Paper PDF. Towards the end, we explain JIRA's security model and introduce you to one of JIRA's new add-ons: JIRA Service Desk, which allows you to run JIRA as a computer support portal. By learning JQL, you can save time and effort by quickly finding the issues that you need to work on or track. This can be done with the use of braces. A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira fields. PDF (black and white) LaTeX Created By. Better version of the cheat sheet here > Rules A classic query in JQL (also known as a 'clause') consists of a field , followed by an operator , followed by one or more values or functions . Add ~ and a number to the end of a phrase in quotes e. g. Enter the JQL, using the actual user name, like this: worklogDate >= startOfWeek () and worklogAuthor = rina.