Carrot reference
Getting started with Carrot
carrot (carrot query language) is the most powerful way to search, create and reference data across your charthop organization using custom or built in functions and filters with carrot you can create powerful calculations using company data to evaluate financial performance and capture valuable employee data analytics using smart fields filter your employee data for customizable visualizations using the map , datasheet , and dashboards quickly reference employee data almost anywhere in the charthop platform including in the org chart docid\ bepxedmk2n5noxoitxf7x , data sheet docid\ xtd4dg4i 4 nmwjfesq0s , map docid\ jfytgidgyywmyay5p0lnb , dashboards docid\ ka8 kvt0aui ekf7mecld , field data types & smart fields docid\ xnd9irlwshfcexmwwksba , and app configurations using carrot one of carrot's greatest values comes from its ability to enable users to build advanced structured queries, filters, and smart fields that perform calculations constructing carrot queries a simple query in carrot consists of a field , followed by an operator , followed by one or more values or functions for example title="director of engineering" this query will find all charthop users in the organization with the job title of "director of engineering" in this case, the query uses the title field , the equals operator , and the value director of engineering for more complex queries, operators can be used to filter data by more than one criteria for example title "director" && startdate<'2020 01 01' this query will find all charthop users in the organization with "director" somewhere in their job title and who started working before the date of january 1st, 2020 in this case, the query uses the title field , the operator which functions as a fuzzy search, and the value director as the first half of the query then, followed by the && (and) operator the query includes the startdate field , followed by the less than operator , and then the value '2020 01 01' dive deeper into carrot's structure in our key concepts docid\ evs2ndshvsn 6 9flx7vc article some carrot examples the below examples illustrate how you might use carrot when creating filters, queries, custom fields, and more example searches for title\ director everyone with "director" somewhere in their title title="director of engineering" the exact title "director of engineering" startdate<'2020 01 01' everyone who started before the date january 1st 2020 is\ manager all people managers !department\ sales,marketing everyone who is not in the sales or marketing departments is\ open daysopen>90 open jobs that have been open for more than 90 days data access and security all data access in carrot is permission controlled, according to charthop access levels , and so query results may vary between users depending on their level of permissions