Key Concepts

to create a carrot query, it helps to have a basic understanding of fields, operators, values, functions, and methods you can learn more about these key concepts below fields a field in carrot is a word that represents a built in field or a custom field that has already been defined in charthop all fields are case insensitive a field contains a reference to specific job, employee and organization data, allowing operations to be ran on it in order to perform calculations for example workaddress the workaddress field can be used as a reference to an employee's work address found in their employee profile fields may also posses properties which are unique members of data belonging to the field's particular data type for example workaddress city "oak park" city is a property of the workaddress field and has the value of "oak park" fields docid\ xyrlltzxie bv4zkzes g operators an operator in carrot is one or more symbols or words that compare the value of a field on its left with one or more values (or functions) on its right the valuation of the clause will always result as true for example 1 2 3 this query uses the (multiply) operator to evaluate the basic mathematical statement department="engineering" this query returns all records where department is engineering carrot operators understand "money math" and will automatically convert currencies when adding or subtracting two different currencies operators docid\ wn 9tvffgiwgqtde4ybmy keywords a keyword in carrot is a word or phrase that joins two or more clauses together to form a complex carrot query directs>0 && department\ engineering alters the logic of one or more clauses directs>0 && !department\ accounting alters the logic of operators department!="engineering" has an explicit definition in a carrot query department\ engineering where means "matches" workaddress city "oak park" where refers to the property city of the field work address field performs a specific function that alters the results of a carrot query tenure <= 3 carrot contains a limited number of reserved keywords keywords docid\ a3ypi3emfpjz9q 4t7vww functions a function in carrot appears as a word followed by parentheses, which may contain one or more explicit values or carrot fields all functions are case insensitive a function performs a calculation on specific carrot data or on the function's content (enclosed within its parentheses), such that the results retrieved by the function return as true, and then again by the clause in which the function is used for example basecompbetween('2017 07 01', '2022 08 01", 1 0) this query will return the base compensation of a person between the dates of january 7th, 2017 and january 8th, 2022 methods methods are special types of functions docid\ izsyklqfbetmslmltbmay that apply to a list docid\ xwh cukhj9waqaefb7h71 or sequence of data usually, methods are used to aggregate data – such as counting or summing list values for example, to count x learn more about functions aggregators (deprecated) aggregators were formerly used in charthop dashboards however, they are now deprecated and should be replaced with their corresponding method an aggregator in carrot appears as a word followed by curly brackets, which contains an expression all aggregators are case insensitive an aggregator performs a calculation on an expression and returns a number https //docs charthop com/uci5 number value based on the aggregator's logic for example count{department\ engineering} this query will return the total number of jobs in the engineering department in the charthop organization all non numeric values are discarded learn more about aggregators data types carrot understands many common data types, including standard data types such as number docid\ uci5tctfvbhonej6zqijg and string docid\ ujw2aqaktel5uuklup73s , as well as a number of charthop specific data types such as money docid ks5d2xbfor9d8wfrivny and comp docid\ h 73ylw2ustscc tjerlf learn more about data types reserved characters carrot has a list of reserved characters space (' ') + = ? | / % \[ ] these characters are reserved for use in operations and keywords if you wish to use these characters in queries, you need to surround them with quote marks y ou can use either single quote marks ' or double quote marks " for example title "' director'" search for sp reserved characters ecial characters in text fields is limited referencing fields in many of charthop's interfaces, you can use carrot to insert data into any rich text area for example, you can use carrot to insert data into automated actions docid 6k2uhp22mlgnhaovzq0yx , custom profile tabs docid\ kiuev47lof6qtlvjlujlr , configuring the home page docid 3bbprw egbg1yxia0fl0c , forms docid\ qr76gadoskc1rlc s0jes or resources docid\ jxotociq2ghvvbxyou6jp the carrot syntax for this is to start with {{ and then end with }} in between you can write a field name or an expression {{workaddress}} "it has been {{basecomp lastraise date monthssince}} months since {{name}} has received a raise "