List of Keywords

You can use some keywords for multiple scopes, namely the keywords id, name, owner, ownergroup and history.

The tables below give a summary of all possible keywords per scope, with a description of what you request exactly.

Attention

The date format selected for Yesplan in the system preferences doesn’t have any impact on the date format in the query language. If you enter a date that has been written out in words in a query, it must always have the following format: dd-mm-yyyy (i.e. ‘28-03-2013’ for 28 March 2013).

Keywords with Default Scopes

In the general finder, you can use some keywords without mentioning a scope in the query. In that case, Yesplan will apply the query to the default scopes for that keyword. For example, the query label:rental will search for the label ‘rental’ with the scopes resource, contact and event. The list of results will display the resources, contacts and events with the label ‘rental’. This is the list of keywords with default scopes:

Keyword	Default Scopes
activecontract	resource
assignedby	task
assignedto	task
contact	event
contract	resource
date	event
due	task
group	event, group, resource
id	event, group, location, contact, resource, task, taskgroup, contactbooking, resourcebooking, team
label	resource, contact, event
location	event, group, location
name	event, group, resource, contact, task
profile	event
progress	task
role	resource
status	event
statustype	event
team	task, resourcebooking
type	resource
unpublished	resourcebooking
zip	person, organization

Keywords for Events, Event Groups and Productions

The table below gives a summary of information that you can request with the scope event, group, event_or_group or production:

Keyword	Valid Scopes	Description
contact	event, group, event_or_group, production	The element’s contacts (excluding the contacts booked via custom data fields).
contactrole	event, group, event_or_group, production	The roles of the element’s contact bookings (excluding the contacts booked via custom data fields).
date	event, group, event_or_group, production	The date when the element takes place.
dateafter	event, group, event_or_group, production	All elements taking place on or after a given date.
defaultschedule	event, event_or_group	The description of the displayed start or end time of the element’s schedule.
document	event, group, event_or_group, production	The element’s attachments (documents and other things) (excluding the attachments added via custom data fields).
end	event, group, event_or_group, production	The element’s end date.
group	event, group, event_or_group, production	The event group that the element belongs to.
history	event, group, event_or_group, production	The items that were added manually to the element’s history. You search the description only, not the date or a period.
id	event, group, event_or_group, production	The element’s Yesplan ID.
inproduction	event, event_or_group, group	It has the value true if the element is in a production, otherwise it is false.
isproduction	event, event_or_group, group	It has the value true if the element is a production, otherwise it is false.
label	event, group, event_or_group, production	The element’s labels.
location	event, group, event_or_group, production	The locations where the element takes place.
name	event, group, event_or_group, production	The element’s name.
owner	event, group, event_or_group, production	The element’s owner.
ownergroup	event, group, event_or_group, production	The user group that owns the element.
production	event, group, event_or_group	The production that the element belongs to.
profile	event, group, event_or_group, production	The element’s profile. For group, event_or_group and production, the value will be n/a for an event group whose events have different profiles.
profiles	event, group, event_or_group, production	The element’s profile. For an event group this will yield a result if at least one event in the event group has this profile.
progress	event, group, event_or_group, production	The element’s status. For group, event_or_group and production, the value will be n/a for an event group whose events have different statuses.
schedule	event, event_or_group	The description of a schedule item of the element’s schedule.
start	event, group, event_or_group, production	The element’s start date.
status	event, group, event_or_group, production	The element’s status. For group, event_or_group and production, the value will be n/a for an event group whose events have different statuses.
statuses	event, group, event_or_group, production	The element’s status. For an event group this will yield a result if at least one event in the event group has this status.
statustype	event, group, event_or_group, production	The element’s status type. If an event group exists whose events have different statuses, this won’t yield a result.
subevent	group, event_or_group, production	The name of the events that are part of the event group.

Keywords for Resources, Placeholders, Locations and Teams

The table below gives a summary of information that you can request with the scope resource, resourceplaceholder, location or team:

Keyword	Valid Scopes	Description
account	resource, resourceplaceholder, location, team	The accounting number in the element’s default price definition.
activecontract	resource	The active contract. This is only applicable to resources of type “Human”.
active	resource, resourceplaceholder, location, team	Has the value true if the element is active, otherwise it is false.
contact	resource, resourceplaceholder, location, team	The element’s contacts (excluding the contacts booked via custom data fields).
contract	resource	The contracts that are applicable to the resource. This is only applicable to resources of type “Human”.
costprofile	resource, resourceplaceholder, location, team	The event profile associated with the element’s default price definition.
costprofiles	resource, resourceplaceholder, location, team	The event profiles associated with an element’s price definition.
date	resource, location	The (purchase) date of the resource. This isn’t applicable to resource sets.
description	resource, location, team	A description of the element.
document	resource, resourceplaceholder, location, team	The element’s attachments (documents and other things), excluding the attachments added via custom data fields. This isn’t applicable to resource sets.
external	resource, resourceplaceholder, location, team	It is true if the element is external, otherwise it is false.
group	resource, resourceplaceholder, location, team	The resource group that the element belongs to.
history	resource, resourceplaceholder, location, team	The items that were added manually to the element’s history. You search the description only, not the date or a period.
id	resource, resourceplaceholder, location, team	The element’s Yesplan ID.
invoice	resource, resourceplaceholder, location, team	Has the value true if the default price definition is to be billed, otherwise it is false (refers to the field “To Be Billed”).
label	resource, resourceplaceholder, location	The element’s roles. Identical to the keyword role.
member	team	The human resources that are part of the team.
name	resource, resourceplaceholder, location, team	The element’s name.
owner	resource, location, team	The element’s owner.
ownergroup	resource, location, team	The user group that owns the element.
productcode	resource, location	The element’s product code. This isn’t applicable to resource sets.
resourcespecies	resource, resourceplaceholder, location, team	The type of resource. Possible values are set, adhoc, bulk, placeholder and instantiatable.
rented	resource, resourceplaceholder, location, team	It is true if the element is rented, otherwise it is false.
role	resource, resourceplaceholder, location	The element’s roles.
serialnumber	resource, location	The element’s serial number. This isn’t applicable to resource sets.
team	resource, team	The element’s team. This is only applicable to resources of type “Human”.
type	resource, resourceplaceholder, location	The element’s type. Possible values are human, material, service or financial.

Keywords for Resource Bookings

The table below gives a summary of information that you can request with the scope resourcebooking:

Keyword	Valid Scopes	Description
account	resourcebooking	The accounting number in the booking’s price definition.
accountableto	resourcebooking	The contact to which the booking was awarded for the price calculation (refers to the field “Billable to”).
actualstart	resourcebooking	The actual start date of the booking. This is only applicable to bookings on events with an “Allow Actuals” status type.
actualend	resourcebooking	The actual start date of the booking. This is only applicable to bookings on events with a status type “Allow Actuals”.
comment	resourcebooking	The value of the booking’s comment field.
contact	resourcebooking	The resource’s contacts (excluding the contacts booked via custom data fields).
date	resourcebooking	The date when the booking takes place.
description	resourcebooking	The description of the resource of the booking. This isn’t applicable to bookings of placeholders.
end	resourcebooking	The end date of the booking.
event	resourcebooking	The event of the booking.
external	resourcebooking	Has the value true if the resource of the booking is external, otherwise it is false.
group	resourcebooking	The group of the booked resource.
history	resourcebooking	The items that were added manually to the element’s history (the booking itself doesn’t have its own history). You search the description only, not the date or a period.
id	resourcebooking	The element’s Yesplan ID.
invoice	resourcebooking	Has the value true if the booking is to be billed, otherwise it is false (refers to the field “To Be Billed”).
label	resourcebooking	The labels of the resource, identical to the keyword role.
location	resourcebooking	The location where the event of the booking takes places.
name	resourcebooking	The element’s name.
owner	resourcebooking	The element’s owner.
ownergroup	resourcebooking	The user group that owns the element.
productcode	resourcebooking	The product code of the booked resource.
resourcespecies	resourcebooking	The type of booked resource. Possible values are set, adhoc, bulk, placeholder and instantiatable.
rented	resourcebooking	Has the value true if the booked resource is rented, otherwise it is false.
role	resourcebooking	All roles of the booked resource.
serialnumber	resourcebooking	The serial number of the booked resource.
start	resourcebooking	The start date of the booking.
team	resourcebooking	The bookings of the people who belong to a certain team. This is only applicable to resource bookings of type “Human”.
type	resourcebooking	The type of the booked resource.
unpublished	resourcebooking	Has the value true if the booking hasn’t been published (i.e. when the start of the booking takes place after the date “rosters published until”), has the value false if this is not the case. This is only valid for bookings of type “Human” if the roster publication has been activated in “System Settings” > “Teamplanner” > “Roster Publication” (or “Rosters & Timesheets” if you have the Teamplanner+ module).
usedrole	resourcebooking	The role used for the booking. This is only applicable to resource bookings of type “Human”.

Keywords for Contacts

The table below gives a summary of information that you can request with the scope contact, person, organization, person_or_organization or contactlink:

Keyword	Valid Scopes	Description
address	contact, person, organization, person_or_organization	The full default address of the element.
{address type}_address	contact, person, organization, person_or_organization	The full address of the element’s {address type} type.
city	contact, person, organization, person_or_organization	The city of the element’s default address.
{address type}_city	contact, person, organization, person_or_organization	The city of the address with the element’s {address type} type.
comment	contact, person, organization, person_or_organization, contactlink	The value of the element’s comment field.
contactinfo	contact, person, organization, person_or_organization, contactlink	The element’s contact information.
country	contact, person, organization, person_or_organization	The country of the element’s default address.
{address type}_country	contact, person, organization, person_or_organization	The country of the address with the element’s {address type} type.
countrycode	contact, person, organization, person_or_organization	The country code of the element’s default address.
{address type}_countrycode	contact, person, organization, person_or_organization	The country code of the address with the element’s {address type} type.
department	contact, person, organization, person_or_organization	The department of one of the links of a person or organization.
document	contact, person, organization, person_or_organization, contactlink	The element’s attachments (documents and other things) (excluding the attachments added via custom data fields).
duplicate	contact, person, organization, person_or_organization	The name of the contacts that are a possible duplicate of this contact.
firstname	person	The first name of a person.
history	contact, person, organization, person_or_organization, contactlink	The items that were added manually to the element’s history. You search the description only, not the date or a period.
id	contact, person, organization, person_or_organization, contactlink	The element’s Yesplan ID.
jobtitle	contact, person, organization, person_or_organization	The job title of one of the links of a person or organization.
label	contact, person, organization, person_or_organization, contactlink	The element’s labels.
language	contact, person, organization, person_or_organization	The element’s language.
languagecode	contact, person, organization, contact, person_or_organization	The language code of the element, cf. the ISO 639.2 list.
lastname	person	The last name of a person.
link	contact, person, organization, person_or_organization	The name of the element’s link.
name	contact, person, organization, person_or_organization, contactlink	The element’s name.
owner	contact, person, organization, person_or_organization, contactlink	The element’s owner.
ownergroup	contact, person, organization, person_or_organization, contactlink	The user group that owns the element.
street	contact, person, organization, person_or_organization	The street name and street number (the two lines with the label “Street”) of the element’s default address.
{address type}_street	contact, person, organization, person_or_organization	The street name and street number (the two lines with the label “Street”) of the address with the element’s {address type} type.
title	person	The title of a person.
type	organization	The business entity of an organization.
zip	contact, person, organization, person_or_organization	The ZIP code of the element’s default address.
{address type}_zip	contact, person, organization, person_or_organization	The ZIP code of the address with the element’s {address type} type.

Keywords for Contact Bookings

The table below gives a summary of information that you can request with the scope contactbooking:

Keyword	Valid Scopes	Description
contact	contactbooking	A contact booking for a certain contact—notice the difference with the keyword ofcontact.
contactrole	contactbooking	The roles of the booked contacts (including the contacts booked via custom data fields).
event	contactbooking	A contact booking for a certain event (including the contacts booked via custom data fields).
eventdate	contactbooking	A contact booking for an event that takes place on a certain date.
history	contactbooking	The items that were added manually to the element’s history (the booking itself doesn’t have its own history). You search the description only, not the date or a period.
id	contactbooking	The element’s Yesplan ID.
label	contactbooking	The contact’s labels. Identical to the keyword role.
name	contactbooking	The element’s name.
ofcontact	contactbooking	The booked contact—notice the difference with the keyword contact.
owner	contactbooking	The element’s owner.
ownergroup	contactbooking	The user group that owns the element.
resource	contactbooking	A contact booking for a certain resource.
role	contactbooking	The contact’s labels.
type	contactbooking	The business entity of the booked organization.

Keywords for Tasks and Task Groups

The table below gives a summary of information that you can request with the scope task and taskgroup:

Keyword	Valid Scopes	Description
assignedby	task, taskgroup	The person by whom the task is assigned.
assignedto	task, taskgroup	The person to whom the task is assigned.
date	task, taskgroup	The due date of the task. Identical to the keyword due.
description	task	A description of the task.
document	task, taskgroup	The element’s attachments (documents and other things).
due	task, taskgroup	The due date of the task.
event	task, taskgroup	The event the element is linked to.
history	task, taskgroup	The items that were added manually to the element’s history. You search the description only, not the date or a period.
id	task, taskgroup	The element’s Yesplan ID.
name	task, taskgroup	The element’s name.
owner	task, taskgroup	The element’s owner.
ownergroup	task, taskgroup	The user group that owns the element.
progress	task, taskgroup	The value for the element in the “Progress” column of the task finder.
start	task, taskgroup	The start date of the element.
status	task, taskgroup	The element’s status. Possible values are new, started, done on hold and obsolete.
team	task, taskgroup	The team to which the task is assigned.