These queries only work in "Advanced Mode". Using these queries allow searching/accessing specific values in specific fields on specific layers. Check the individual syntax per field.
-
Search: Search in Metadata and Document Fulltext (Solutions) — You can extend any search to document fulltext and/or metadata. You wish to find all of your companies' literature where a certain product is mentioned or any documents that mention the CEO, then simply add the searchType to the URL as a query string parameter.
//search in fulltext &searchType=FullText
-
Search: Find Users by Identity Provider (Solutions) — This will find all Users where the field is empty aka users where no Identity Provider is added.
_exists_:identityProviderId
This will find users of a specific Identity Provider.
identityProviderId:a3431095e9cc401ab65197ba12ecfccf
-
Search: Find Users by Creation Date Range (Solutions) — This will find all Users created in the last 60 days which are not Support Users. Adapt the date range to your specific case.
audit.creationDate:[now-60d TO now] AND isSupportUser:false
-
Search: Find Items with Layer not Assigned (Solutions) — This will find all Content Items where the value "Basic Information" is not present in the field that stores all assigned layers "layerSchemaIds".
-layerSchemaIds:BasicInformation
-
Search: Fuzzy Search (Proximity) (Solutions) — You can search for terms that are similar but a bit "fuzzy". Therefore you can use the "fuzzy” operator which is a Tilde following your search term in the advanced search.
quikc~ brwn~ foks~
-
Search: Find Users Not in Role A (Solutions) —
Find the ID of the role in the URL when opening the role in role detail view
Go to users > switch to advanced search mode
Add this code (adapt the ID)
-userRoles.userRoleId:1b611edb400c403498113523f1127580s
-
Search: Find Users by Role (Solutions) — This will find all Users where the field is empty (not exists) aka users where no roles are added.
-_exists_:userRoles.userRoleId
This will find all Users where the field is not empty (exists) aka users where roles are added.
_exists_:userRoles.userRoleId
This will find users of a specific role.
userRoles.userRoleId:49c5052617c849cf95de3a98d6408f4a
-
Search: Find Items by Permission Sets (Solutions) — This will find all Content Items where the field is available but has no value, where no Permission Sets are applied.
-_exists_:permissionSetIds
This will find all items of the specific Permission Set.
permissionSetIds:787eb87f4c914ec5ba359cc8d8a1d0af
-
Search: Find Items by Product Codes (Solutions) — You want to find all Items that have the Product Code: F_1000 applied.
Search:
1000 finds a product
F_1000 finds a product
F 1000 does not find a product
The results depend on the Analyzers used.
-
Search: Check if Field Product Description Exists (Solutions) — Searching for the description, which is a translated text field, in advanced search mode:
_exists_:productInformation.description.en
-
Search: Find Product Information in Translated Description (Solutions) — Searching for a value inside the description, which is a translated text field, works in advanced search mode with the syntax:
productInformation.description.en:Blueberry*
-
Search: Boost (Uplift) your Search Terms (Solutions) — Finds all contents that are tagged with dogs but are especially interested in large dogs. Use the boost operator ^ in the simple search to make one term more relevant than another e.g. boost large:
large^2 dogs
Apply the boost operator to multiple terms using quotation marks:
"large dogs"^2
-
Search: Find Items with Tagbox Values (Solutions) — This query looks for the fieldId "fullName" from the connected List in a Tagbox (persons) that is on the Layer Corporate Information. You must use this syntax to get a specific value from the tag assigned: layer.tagbox.listfieldid:value
corporateInformation.persons.fullName:Joe*
-
Search: Find Items with Checkbox Values (Solutions) — This will find all content items with the checkbox legally approved set to true.
_exists_:corporateInformation.legallyApproved:true
This will find all content items with checkbox legally approved set to false or checkbox not set.
_exists_:corporateInformation.legallyApproved:false
-
Search: Find Items by Ids (Solutions) — List Item Ids and Content Item Ids are not available in the search index, you can add them in the channel configuration as “Extended simple search fields”.
-
Search: Find Items with Geo values not possible (Solutions) — This is not working as Geo Point fields are not available in the search, but only in filters. You will also not find a setting for "search" in the geo point field configuration. The code itself is correct.
corporateInformation.location.lat:47
-
Search: Find Items with Fieldset values (Solutions) — This will find Content Items even if those items do not have the values Joe AND true available. This is a search limitation in Picturepark for multi-value fields from schemas. For the search, the values are flattened, so when a Fieldset of a Content Item contains somewhere a value "true" and somewhere a value "Joe" the search finds this as a result.
reviewingContent.reviews.reviewAccepted:true AND reviewingContent.reviews.reviewer.firstName:Joe
-
Search: Find Items with Date (Solutions) — Will find all Content Items which have the date-time value "2022-02-1x". This query does not work with exact match.
corporateInformation.embargoDate:2022-02-1*
-
Search: Find Items with Date in Range (Solutions) — Will find all Content Items which were created or modified in March 2020
audit.creationDate:[2020-03-01 TO 2020-03-31] audit.modificationDate:[2020-03-01 TO 2020-03-31]
-
Search: Find Items with a Specific Date. (Solutions) — Will find all Content Items which have the exact date time value "2022-02-15T23:00:00Z". You can find this value in the JSON of the Content Item. This query only works with an exact match.
corporateInformation.embargoDate:"2022-02-15T23:00:00Z"
-
Search: Find Items with specific values in text fields (Solutions) — Will find all Items with multiple specific values in text fields.
corporateInformation.note.simple:(lorem OR ipsum OR tmp)
-
Search: Find Items with values in translated fields. (Solutions) — Adding the text analyzer to the fieldpath allows finding values contained in the text field, ignoring capitalization. You can now also search for the plural values or stems e.g. berries, berr.
corporateInformation.title.en.language:berries
-
Search: Find Items with Exact Term in Translated Field (Solutions) — Will find all Content Items which have the exact term "red berry" in the English translation of the translated text field.
basicInformation.title.en.language:"red berry"
For (product) numbers in translated text fields you must search without quotes. This works with or without the analyzer:
basicInformation.title.en.language:2106445_1 basicInformation.title.en:2106445_1
-
Search: Find Items where Field in Layer is Empty (Solutions) — Will find all Content Items which have the Layer "Corporate Information" assigned, but there is no English value for the Title available aka this syntax finds all Content Items with an empty Title in the Layer.
-_exists_:fieldpath AND layerSchemaIds:LayerId
-
Search: Find Items with Value in a Field (Solutions) — This will find all Content Items where the field is available in the Layer and has a value.
_exists_:fieldpath
-
Search: Find Items where Field or Layer is Empty (Solutions) — This will find all Content Items where the field is not present, but also those without the Layer assigned, so you must additionally check if the Layer present.
-_exists_:fieldpath
-
Channel Setting: Show Search Advice in Empty Search Text (Solutions) — Goal: When your users will search for something they may expect fuzziness or corrections, which are not yet available to the full degree. Therefore you can help them by displaying a note which explains the correct syntax, as not all users may be fully familiar with ES Query Syntax.