Advanced search formulae
- Monika Fiedorowicz
- Henryk Rybinski
To check the correctness and completeness of the entered records, the editor can use ready-made advanced search formulas in a special custom query language, entered to Custom query field.
The search formula can work in conjunction with other selected search criteria, e.g. selection of unit(s), range of years, type of publication, etc.
The list of search formulas in the Knowledge Base
Authors and employees:
(active='false') | indicate records where Active flag is not selected |
(active='true') | checking whether the author's status is checked - Active |
not(@email) | e-mail address of the author in the record is missing |
(@email) | the author's description contains an e-mail address |
not(@authorprofile-phone) | no phone number in the author's description |
(@authorprofile-phone) | the author's description includes a phone number |
not(@authorprofile-possitionPL) | the position author's description is missing in Polish. |
(@authorprofile-possitionPL) | the author's description includes the position in Polish. |
not(@authorprofile-possitionEN) | the position author's description is missing in English. |
(@authorprofile-possitionEN) | the author's description includes the position in English. |
not(@authorprofile-prefixEN) | no title in Polish in the author's description. |
(@authorprofile-prefixEN) | the author's description contains the title in Polish. |
not(@authorprofile-prefixEN) | no title in English in the author's description. |
(@authorprofile-prefixEN) | the author's description contains the title in English. |
not(@authorprofile-descriptionPL) | the author's description of his professional work in Polish is missing. |
(@authorprofile-descriptionPL) | the author's description includes the characteristics of professional work in Polish. |
not(@authorprofile-descriptionEN) | the author's description of his professional work in English is missing. |
(@authorprofile-descriptionEN) | the author's description includes the characteristics of his professional work in English. |
not(@authorprofile-consultations) | no consultation in Polish in the author's description. |
(@authorprofile-consultations) | the author's description includes consultations in Polish. |
not(@authorprofile-consultationsEN) | no consultation in English in the author's description. |
(@authorprofile-consultationsEN) | the author's description includes consultations in English. |
not(@authorprofile-homepage) | no author homepage |
(@authorprofile-homepage) | author's homepage exists |
not(@authorprofile-file) | no file (photos) |
not(@authorprofile-file) | the file (photo) exists |
@affiliation-id – given university affiliation |
|
not(@affiliation-id) | no university affiliation provided |
@externalAuthorAffiliation – the specified external affiliation |
|
not(@externalAuthorAffiliation) | no external affiliation provided |
@email and not(jcr:like(@email,'%@%')) | indicate records where e-mail does not contain the '@' sign |
@email and (jcr:like(@email,'%@%@%')) | indicate records in which e-mail appears in the e-mail address field at least twice |
Publications
@file-id>0 | show records with file |
@file/permission/access='PUBLIC' (or @file-permission-access='PUBLIC') | show records that have a set status to public access |
@file/permission/access='PROTECTED' (or @file-permission-access='PROTECTED') | show records that have the status set to protected access |
@file/permission/access='PRIVATE' (or @file-permission-access='PRIVATE') | show records that have the status set to private access |
@file/permission/id>0 (or @file-permission-id>0) | show records where access has been specified |
@file-id>0 and not(@file/permission/id>0) (or @file-id>0 and not(@file-permission-id>0) | show records where access has not been specified |
score=0 | show the list of publications with a score of 0 |
score > 0 and score < 10 | show the list of publications with scores from 1 to 9 |
Books and chapters
not(@language) | show books that are missing a language |
(@language) | show books in which the language appears |
not(@issueDate>0) | show books with missing year of publication |
not(@publisherInstitution) | show books that lack a publisher |
(@publisherInstitution) | show books in which the publisher appears |
not(@collation) | show books that are missing pagination |
(@collation) | show books that do not lack pagination |
not(@isbn) | show books that are missing an ISBN |
(@isbn) | show books that contain ISBNs |
not(@language) | show chapters from a book that are missing language |
(@language) | show chapters from a book that contain language |
(@book-issueDate>0) | show chapters from a book that do not miss the year of publication |
not(@book-publisherInstitution) | show chapters from books that lack a publisher |
(@book-publisherInstitution) | show chapters from books with a publisher |
not(@collation) | show chapters from books that are missing chapter pagination |
(@collation) | show chapters from books that do not lack chapter pagination |
Journal papers
not(@language) | show journal articles that are missing language |
(@language) | show articles from journals that contain language |
not(@journalissue-issueDate>0) | show articles from journals with missing publication year |
(@journalissue-issueDate>0) | show articles from journals with the same year of publication |
not(@collation) | show journal articles that lack article pagination |
(@collation) | show articles from journals that do not lack article pagination |
language-code='pl' | show publications in which the Polish language is specified |
language-code='en' | show publications in which English is specified |
PhD Theses
not(@titlePL) | show doctorates that lack a title in English. Polish |
(@titlePL) | show doctorates that include a title in English. Polish |
not(@titleEN) | show doctorates that lack a title in English |
(@titleEN) | show doctorates that include a title in English |
not(@supervisor) | show PhD theses that lack a supervisor |
(@supervisor) | show PhD theses that do not lack a supervisor |
not(@internalreviewers) | show PhD theses that lack an internal reviewer |
(@internalreviewers) | show PhD theses that have an internal reviewer |
not(@externalreviewers) | show PhD theses that lack an external reviewer |
(@externalreviewers) | show PhD theses that do not lack an external reviewer |
not(@certifyingUnit) | show doctorates that lack a diploma unit from the university |
(@certifyingUnit) | show doctorates that include a diploma unit from the university |
not(@certifyingOtherUnit) | show doctorates that lack a diploma unit from outside the university |
@certifyingOtherUnit) | show doctorates that include a diploma unit from the external university |
not(@discipline) | show doctorates that lack scientific discipline |
(@discipline) | show doctorates that do not lack scientific discipline |
not(@discipline20) | show PhDs that lack Discipline 2.0 |
(@discipline20) | show PhDs that include discipline 2.0 |
not(@language) | show PhDs that are missing a language |
(@language) | show PhD theses that include language |
not(@defenseDate) | show PhD theses that lack a defense date |
(@defenseDate) | show PhD theses with no missing defense date |
not(@collation) | show PhDs that lack pagination |
(@collation) | show PhD theses that do not lack pagination |