Welcome to the Fieldcode Manual

Tip: Start typing in the input box for immediate search results.

Search queries are all along work place used to find and filter for tickets you want to examine further. They can be used for a very fine search and allow you to find exactly the tickets you need. Search queries can even be combined with the use of logical operators and can help you to find a very specific cluster of tickets. When it comes to using search queries the right syntax is essential. In the paragraphs below you can find a lot of hands-on examples to learn more about the expert-search.

If you want to search for a text value (data type: TEXT) inside a ticket like eg. name of company, country code, city name, project etc. then normally you have to put it between quotation marks. If it’s just one word you don’t have to, you can instead use as described below:

 project:MyFirstCompany

You don’t have to use brackets if it’s one word without spaces. However, when you have spaces between the word, you need to use them:

project:”My first company”

If you want to insert a numeric value (data type: TEXT) like for example the CNI number of a ticket do as follows:

cni:”5″

Also important to know – always try to use the correct spelling for the aliases.

Incorrect spelling

inwarranty:”TRUE”

Correct spelling

inWarranty:”TRUE”

If you want to two or more  values you should use rounded brackets and a connector like AND or OR.

The OR operator displays results with at least one value fulfilled.

affectedCountryCode:(DE OR PL OR GR)

The AND operator displays results with all values fulfilled.

category:(“Break and fix” AND cni.sort:[5 to 8])

If you want to search for a range of tickets you have to use brackets and the word TO as a connector:

appointmentFixedTo:[202105 TO 202110]

The following format is used especially for the date data type fields:

YYYYMMDDHHMM

Year, Month, Day, Hours and Minutes

The shorter format YYYYMMDD or YYYYMM also works for searching

Be advised that searching for ranges only works with the data type date.

If you want to search for a ticket in a specific status you can just use the appropriate alias:

status:canceled

Searching for two status at once:

status: (CANCELED OR “PENDING WAIT ONSITE”)

You can also use NOT to search for specific filter elements according to the exclusion principle:

NOT status: canceled

You can also search for multiple status at once, just use the correct syntax:

NOT status: (CANCELED OR “PENDING WAIT ONSITE” OR APPOINTMENT)

You can use the simple lsdt query to find tickets for a particular date:

lsdt:20210602

If you want to search for tickets within specific dates you can use the time operators YEAR, HOURS, SECONDS and the query NOW to find the ticket:

lsdt:[NOW-1HOUR]

You can also use mathematical symbols to find a particular set of tickets:

lsdt:<20210602

Above alias will search for tickets that were last updated before the 02.06.2021. It will not display tickets after this date.

The following mathematical symbols are supported throughout search fields:

<; >; <=

Let’s say you want to find tickets with the help of mathematical symbols.

What you can do then in this case is to go by the data type date and using for example the alias lsdt to find tickets that are in the Ticket Pool before the LSDT.

lsdt:<=20220601

Absolutely! But just for text and numbers.

Let’s say you want to find tickets with contact persons, where you don’t know the exact spelling. You know the persons’ name starts with a “ki” and ends with a “y”. What you could do in this case is the following:

affectedUser:ki*y

This will display you all tickets with the variation of the name, doesn’t matter if our person is named: Kimchy, Kilaory or Kitty. The search will display them all.

The same principle goes for numbers. Let’s say you don’t know the last digit of the CNI’s so you decide to browse through all of them to find your right ticket.

cni:13*

This will display you all tickets with the CNI numbers between 130 and 139 and the ticket with CNI 13 (because the star doesn’t have to mean a number necessarily).

If you want to search for a ticket with multiple conditions you can use operators as OR, AND; TO or NOT etc. pp.

Be advised that the operator NOT is always put before the alias:

NOT category: “Break and fix”

More complex combined queries:

category:(“Standard” AND appointmentFixedFrom:[202105 TO 202110])

Next example:

category:(“Break and fix” AND cni.sort:[5 to 8])

We currently fully support the following data types in our search.

TEXT: The text data type stores any kind of text data (including numbers).

BOOLEAN: A Boolean value represents a truth value; that is, TRUE or FALSE.

DATE: Date fields have a predetermined size and format. They can be defined on the definition specification. We use the following specification inside our search: YYYYMMDDHHMM or the shorter one YYYYMMDD or YYYYMM

UUID: Universal Unique Identifier, commonly used for unique IDs
(eg. reportingUserId). 

INTEGER: The INTEGER data type stores whole numbers that range from -2147483647 to 2147483647 for 9 or 10 digits of precision.

DOUBLE: A double-precision floating-point number is a long floating-point number of 64 bits.

If you like a query and you want to use it more frequently you can save it for further usage. Find out more in the My queries topic.

Quick tips for using the search queries table

  • You can use the search inside the search query table to faster find your search query
  • You can sort ascending or descending by using the arrows inside the table
  • You can copy the search query and paste it inside the Fieldcode work place, just change the value to your needs
  • Ticket Pool = How the column is called inside the Ticket Pool (Learn more about these columns in Adjust Table View)
  • Items are our internal synonym for spare parts
  • DATE FIELDS (eg. if you check for a ticket with a particular fixed to time) usually use the UTC TIME ZONE as a reference point – therefore it is not a bug if other dates show up in the search result too – because technically for other people they are in exactly this time zone.
  • NULL means this search query hasn’t been updated with an example yet, however, it is still ready for usage as the elastic search has been updated just recently
Ticket PoolSearch GoalSearch QueryExample ValueData Type
Tickets with a specific address noteaffectedAddressNote:“Third Floor“Third FloorTEXT
CityTickets with a specific cityaffectedCity:“Wroclaw“WroclawTEXT
Tickets with a specific companyaffectedCompany:“Fieldcode Germany GmbH"Fieldcode Germany GmbHTEXT
Company NameTickets with a specific country codeaffectedCountryCode:“DE“PLTEXT
CountryTickets with a specific countryaffectedCountryName:“Germany“GermanyTEXT
Tickets with a specific primary end user emailaffectedMail1:"support@fieldcode.com"john.doe@yourcompany.comTEXT
Tickets with a specific secondary end user emailaffectedMail2:"support@fieldcode.com"doe.john@yourcompany.comTEXT
Tickets with a specific primary end user phone numberaffectedPhone1:“0039-1233456“0039-1233456TEXT
Tickets with a specific secondary end user phone numberaffectedPhone2:“0039-1233456“0039-1233456TEXT
Tickets with a specific onsite addressaffectedSite:“Company Ltd.“Test Company Ltd.TEXT
Tickets with a specific street name, insert without numberaffectedStreet:“Examplestreet“ExamplestreetTEXT
Tickets with a specific timezone IDaffectedTimezoneId:“Europe/Berlin"Europe/BerlinTEXT
End user nameTickets with a specific contact personaffectedUser:“John Doe“John DoeTEXT
Tickets with a specific ZIP codeaffectedZip:“90409“90409TEXT
Tickets with a specific appointment ID (check for it in Fieldcode admin panel)appointmentId:8ebd82e7-af64-440e-9bdf-cf0887eb0e608ebd82e7-af64-440e-9bdf-cf0887eb0e60UUID
Tickets with a specific asset tagassetTag:“example text“iPhone 12 ProTEXT
CategoryTickets with a specific category (eg. Break & Fix)category:"Installation, Move, Add, Change, and Disposal"StandardTEXT
Tickets with a specific close date or close date rangeclosed:20211010>20211010DATE
CNETickets with a specific CNE or CNE rangecne:“CNE1105“CNE1082TEXT
CNE ParentTicket with a specific CNE ParentcneParent:“ANYTEXT“AX57213TEXT
CNITickets which have a specific CNI or CNI rangecni:"129"12*INTEGER
Tickets with a specific condition config descriptionconditions.conditionConfig.constantDescription:"ANYTEXT"Due date is getting close!TEXT
Tickets with a specific condition config enumerationconditions.conditionConfig.constantEnumeration:"ANYTEXTCONDITION_APPOINTMENT_DISPATCHED_TO;
CONDITION_APPOINTMENT_DISPATCHED_FROM;
CONDITION_LSDT;
CONDITION_APPOINTMENT_FIXED_TO;
CONDITION_APPOINTMENT_FIXED_FROM;
CONDITION_TICKETSTATUS
TEXT
Tickets with a specific condition critical timeconditions.criticalTime:"2022-06-24T09:55:31.502Z"[NOW/DAY-10DAY TO NOW]DATE
Tickets with a specific condition warn timeconditions.warnTime:"2022-06-24T09:55:31.502Z"[NOW/DAY-10DAY TO NOW]DATE
Creation DateTickets with a specific creation datecreation:"2022-06-24T09:50:16.045Z"[NOW/DAY-10DAY TO NOW]DATE
currentIntervention:"Null"
Tickets with a specific appointment cancel comment (searches only the last appointments of all tickets)currentIntervention.appointment.cancelComment:"Null"Tornado warningTEXT
Tickets with a canceled appointment or opposite (searches only the last appointments of all tickets)currentIntervention.appointment.canceled:"Null"TRUEBOOLEAN
Tickets with a specific appointment cancel reason (searches only the last appointments of all tickets)currentIntervention.appointment.cancelReason:"Null"Canceled due to customer wishTEXT
Tickets with a specific appointment comment (searches only the last appointments of all tickets)currentIntervention.appointment.comment:"Null"ANYTEXTTEXT
Tickets with a dispatched appointment or opposite (searches only the last appointments of all tickets)currentIntervention.appointment.dispatched:"Null"FALSEBOOLEAN
Tickets with a specific appointment dispatched from time or range (searches only the last appointments of all tickets)currentIntervention.appointment.dispatchedFrom:"Null">=2021010DATE
Tickets with specific appointment to time or range (searches only the last appointments of all tickets)currentIntervention.appointment.dispatchedTo:"Null">=2021010DATE
currentIntervention.appointment.dispatchGroup:"Null"
Tickets with a specific appointment fixed from time or range (searches only the last appointments of all tickets)currentIntervention.appointment.fixedFrom:"Null">=2021010DATE
Tickets with a specific appointment fixed to time or range (searches only the last appointments of all tickets)currentIntervention.appointment.fixedTo:"Null">=2021010DATE
Tickets where the appointment is locked or opposite (searches only the last appointments of all tickets)currentIntervention.appointment.locked:"Null"FALSEBOOLEAN
Tickets with a specific appointment preferred from time or range (searches only the last appointments of all tickets)currentIntervention.appointment.preferredFrom:"Null">=2021010DATE
Tickets with a specific appointment preferred to time or range (searches only the last appointments of all tickets)currentIntervention.appointment.preferredTo:"Null">=2021010DATE
Tickets with a specific proposed from time or range (searches only the last appointments of all tickets)currentIntervention.appointment.proposedFrom:"Null">=2021010DATE
Tickets with a specific appointment proposed to time or range (searches only the last appointments of all tickets)currentIntervention.appointment.proposedTo:"Null">=2021010DATE
Tickets with a specific appointment status (searches only the last appointments of all tickets)currentIntervention.appointment.status:"Null"COMPLETEDTEXT
Tickets with undispatched appointment or opposite (searches only the last appointments of all tickets)currentIntervention.appointment.undispatched:"Null"TRUEBOOLEAN
Tickets with a specific appointment User ID (searches only the last appointments of all tickets)currentIntervention.appointment.userId:"Null"8ebd82e7-af64-440e-9bdf-cf0887eb0e60UUID
Tickets with a specific appointment user name (searches only the last appointments of all tickets)currentIntervention.appointment.userName:"Null""FirstName LastName"TEXT
Tickets with a specific duration (searches only the last appointments of all tickets)currentIntervention.duration:"Null"SecondsINTEGER
Tickets with a specific duration end (searches only the last appointments of all tickets)currentIntervention.durationEnd:"Null">=2021010DATE
Tickets with a specific duration start (searches only the last appointments of all tickets)currentIntervention.durationStart:"Null"<=2021010DATE
Tickets with a specific duration type (searches only the last appointments of all tickets)currentIntervention.durationType:"Null"WORKTIMETEXT
Tickets with a LSDT miss or opposite (searches only the last LSDT miss of all tickets)currentIntervention.lsdtMiss:"Null"TRUEBOOLEAN
Tickets with a successful reporting or opposite (searches only the last reporting succesful of all tickets)currentIntervention.reportingSuccessful:"Null"TRUEBOOLEAN
Tickets with a specific reporting user ID (searches only the last reporting of all tickets)currentIntervention.reportingUserId:"Null"8ebd82e7-af64-440e-9bdf-cf0887eb0e60UUID
Tickets with a specific reporting user name (searches only the last appointments of all tickets)currentIntervention.reportingUserName:"Null""FirstName LastName"TEXT
Tickets with a specific reporting work note (searches only the last reporting of all tickets)currentIntervention.reportingWorkNote:"Null"work done successfullyTEXT
Tickets with a specific description textdescription:“example text“Ticket is urgentTEXT
Tickets with a specific device categorydeviceCategory:"Null"TEXT
Tickets with a system connectiondirectConnectionStatus:"Active"ActiveTEXT
dispatchGroups:"Null"
dispatchGroups.id:"Null"
Error CodeTickets with a specific error codeerrorCode:“No error"ANYTEXTTEXT
Info/Alert/PartTickets which where escalated or oppositeescalation:"TRUE"FALSEBOOLEAN
Tickets which have a specific escalation reasonescalationReason:“example text“Ticket was escalated because customer could not be reachedTEXT
Tickets with a specific estimated duration in minutesestimatedDuration:"60"90INTEGER
geoloaction.lat:"51.0668695"
Tickets with a specific geolocationgeolocation:"Null"FILTER
geolocation.lon:"17.0078518"
Ticket with a specific device host namehostname:“www“wwwTEXT
Tickets with a specific IDid:"21988"51012INTEGER
Info/Alert/PartTickets which have a critical indication or oppositeindications.isCritical:"Null"FALSEBOOLEAN
Info/Alert/PartTickets which have a warning indication or oppositeindications.isWarning:"Null"FALSEBOOLEAN
interventions:"Null"
Tickets with a specific Appointment Cancel Commentinterventions.appointments.cancelComment:"Null"Appointment canceled because of bad weatherTEXT
Tickets which have the appointment canceledinterventions.appointments.canceled:"Null"True BOOLEAN
Tickets with a specific cancel reason constant display textinterventions.appointments.cancelReason:"Null"CONSTANT DISPLAY_TEXTTEXT
Tickets with a specific appointment commentinterventions.appointments.comment:"Null"Repair succesfulTEXT
Tickets which were dispatched or oppositeinterventions.appointments.dispatched:"Null"TRUEBOOLEAN
interventions.appointments.dispatchedFrom:"Null"
Tickets with a specific appointment from dateinterventions.appointments.dispatchedFrom:"Null"<=2021010DATE
Tickets with a specific appointment to dateinterventions.appointments.dispatchedTo:"Null"[202105 TO 202110]DATE
Tickets with a specific fixed from appointment dateinterventions.appointments.fixedFrom:"Null"<=2021010DATE
Fixed to dateTickets with a specific fixed to appointment dateinterventions.appointments.fixedTo:"Null"<20211010DATE
Tickets which are locked by the user or oppositeinterventions.appointments.locked:"Null"FALSEBOOLEAN
interventions.appointments.preferredFrom:"Null"
Tickets with a specific preferred to dateinterventions.appointments.preferredTo:"Null"[202105 TO 202110]DATE
Tickets with a specific proposed from timeinterventions.appointments.proposedFrom:"Null"<=2021010DATE
Tickets with a specific proposed to timeinterventions.appointments.proposedTo:"Null"<=2021010DATE
Ticket with a specific appointment statusinterventions.appointments.status:"Null"COMPLETEDTEXT
Tickets with a specific appointment user IDinterventions.appointments.userId:"Null"8ebd82e7-af64-440e-9bdf-cf0887eb0e60UUID
Tickets with a specific appointment user nameinterventions.appointments.userName:"Null"Marsha WilliamsTEXT
Tickets with a specific ticket duration (in minutes)interventions.durations:"Null"1800INTEGER
Ticket which were resolved successful or oppositeinterventions.reportingSuccessful:"Null"FALSEBOOLEAN
Tickets with a specific reporting User IDinterventions.reportingUserId:"Null"8ebd82e7-af64-440e-9bdf-cf0887eb0e60“UUID
Tickets with a specific reporting work noteinterventions.reportingWorkNote:"Null"Reporting without signoffTEXT
Tickets where the device is either in warranty or oppositeinWarranty:"TRUE"FALSEBOOLEAN
isInfoInProgress:"Null"
items:"Null"
items.audit:"Null"
items.audit.active:"Null"
items.audit.createdAt:"Null"
items.audit.createdBy:"Null"
items.audit.lastModifiedAt:"Null"
items.audit.lastModifiedby:"Null"
items.condition:"Null"
items.currentShipping:"Null"
items.description:"Null"
items.entryId:"Null"
items.externalStatus:"Null"
items.failureCode:"Null"
items.id:"Null"
items.manufacturer:"Null"
items.name:"Null"
items.orderNumber:"Null"
items.orderNumberLineItem:"Null"
items.partNumber:"Null"
items.quantity:"Null"
items.reference:"Null"
items.replacedSerial:"Null"
items.serial:"Null"
items.shippingHistory:"Null"
items.status:"Null"
items.ticket:"Null"
items.ticketCni:"Null"
items.type:"Null"
items.usage:"Null"
LSDTTickets with a specific LSDT timelsdt:"2022-06-24T02:50:16.000004296+02:00"<=2021010DATE
Tickets with a specific Mac Adressmac:“E4-B9-7A-DE-00-94"E4-B9-7A-DE-00-94TEXT
Tickets with a specific manufacturer namemanufacturerName:“example text“LenovroTEXT
DeviceTickets with a specific modelmodel:“example text“Lenovro Deskbook X12TEXT
Tickets with a specific notenote:“example text“ANYTEXTTEXT
Tickets with a specific device operating systemos:“MacOS“Windows 11TEXT
Partner nameTickets with a specific partnerpartner:"ABC Company"ABC CompanyTEXT
Partner nameTicket with a specific partner assignedpartnerName:"Partner Company"ABC Partner CompanyTEXT
Tickets with a specific prioritypriority:"1"3INTEGER
Tickets with a specific product lineproductLine:“Intel“AMDTEXT
ProjectTicket with a specific projectproject:“My Company“Test Company Ltd.TEXT
Tickets with a specific Project IDprojectId:"1934"2479INTEGER
ScoreTickets with a specific ticket scorescore:"7"1-10DOUBLE
Tickets with a specific device serialserial:“DEV-SER-2729“AJX-31X-21JTEXT
Tickets with a specific serial providedserialProvided:“34yxz-0812r-144“JKA-81U-081TEXT
Tickets with a specific device short descriptionshortDescription:“Smaller variant of the device“Bigger variant of the displayTEXT
skills:"Null"
skills.id:"Null"
skills.level:"Null"
skills.name:"Null"
skills.weight:"Null"
SLATickets with a specific service level agreementsla:"Null"CONSTANT ENUMERATIONTEXT
Tickets with a specific Specification referencespecificationReference:“32342“Size XLTEXT
StatusTickets with a specific statusstatus:“RESOLVED“NEWTEXT
SubcategoryTickets with a specific sub categorysubCategory:“Standard“Break & FixTEXT
Tickets with a specific suppliersupplier:“Demo Company“Example Company Ltd.TEXT
Tickets with a specific timezonetimezone:"Null"
Tickets with a specific device typetype:“desktop“mobileTEXT
Tickets which are undispatchedundispatched:"TRUE"FALSEBOOLEAN
Tickets with a specific User IDuserId:“8ebd82e7-af64-440e-9bdf-cf0887eb0e60“8ebd82e7-af64-440e-9bdf-cf0887eb0e60UUID
Grabbed byTickets grabbed by a specific personuserName:“John Doe“Marsha WilliamsTEXT
Info/Alert/PartTickets with a vip flag or oppositevip:"TRUE"FALSEBOOLEAN
Tickets which have a device with a specific warranty typewarrantyType:“Apple Care +“Apple Care +TEXT
Tickets with a wrong serial provided or oppositewrongSerialProvided:"TRUE"FALSEBOOLEAN
ESDTTickets with a specific ESDT timeesdt:"2022-06-24T02:50:16.000004296+02:00"<=2021010DATE
Was this article helpful?
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents