Standard lists

This topic contains definitions of all standard Case lists, Document lists, and Contact lists supplied by WorkZone as of release 2023.3. You can, for example, use the definitions as a starting point for customizing standard lists.

The table below shows QueryBuilder queries and the corresponding OData URLs. Note that only the last part of the URL is shown. You will have to add server name and OData endpoint for it to work in your WorkZone installation, for example the URL for “Followed Contacts” list is shown as

/Contacts?$filter=Mru/User_Value eq '%40Me' and MruChanged/Follow

If you want to execute this query, you need to add the server name and OData endpoint as shown in this example:

https://test.workzone.cloud/odata/V3/Contacts?$filter=Mru/User_Value eq '%40Me' and MruChanged/Follow.

Case lists

Name

Definition

Open cases

Open cases with me as case handler

Graphical user interface, text, application, email

Description automatically generated

/Files?$filter=Officer_Value eq '%40Me' and Closed eq null and FileClass_Value ne 'SJ-DOK' and FileClass_Value ne 'SJ-AGENDA'

Cases currently placed with me

Cases placed with me at the moment

Graphical user interface, application

Description automatically generated

/Files?$filter=Closed eq null and FileLocationCurrent/NameCode eq '%40Me'

Cases with reminders

Cases with reminders for me within the next week

Graphical user interface, application

Description automatically generated

/Files?$filter=Reminders/any(a: a/ReminderDate lt datetime'2021-07-09T00:00:00' and a/NameCode eq '@Me' and a/Marking_Value ne 'P') &dateRelativeness=@Day+8

Cases with no case handler and unit

Cases without case handler and unit

Graphical user interface, text, application

Description automatically generated

/Files?$filter=Officer_Value eq null and ResponsibleOu_Value eq null and Rej eq null

Unit's open cases

Unit's open cases

Graphical user interface, text, application

Description automatically generated

/Files?$filter=ResponsibleOu_Value eq '%40Unit' and Closed eq null

Unit's cases with no case handler

Unit's cases with no case handle

Graphical user interface

Description automatically generated

/Files?$filter=ResponsibleOu_Value eq '%40Unit' and Officer_Value eq null and Closed eq null and Rej eq null

Unclassified cases

My cases requiring final classification

Graphical user interface, text, application

Description automatically generated

/Files?$filter=Officer_Value eq null and Closed eq null and FileClass_Value eq 'SJ-TEMP'

Changed cases

Changed cases that I follow

Graphical user interface, text, application

Description automatically generated

/Files?$filter=MruChanged/User_Value eq '%40Me' and MruChanged/Follow

Recent cases

My recent cases

Graphical user interface, text, application

Description automatically generated

/Files?$filter=Mru/User_Value eq '%40Me' and Mru/EntityUpdated ne null

Favorite cases

My favorite cases

Graphical user interface, application

Description automatically generated

/Files?$filter=Mru/User_Value eq '%40Me' and Mru/Favorite

Followed cases

Cases that I follow

Graphical user interface, text, application

Description automatically generated

/Files?$filter=Mru/User_Value eq '%40Me' and Mru/Follow

Reading list cases

Cases on my reading list

Graphical user interface, text, application

Description automatically generated

/Files?$filter=Mru/User_Value eq '%40Me' and Mru/ReadingList

Meetings organized by me

Meetings that I am responsible for

Graphical user interface, application

Description automatically generated

/Files?$filter=Officer_Value eq '%40Me' and Meeting/End ge datetime'2021-07-02T00:00:00%2b02:00'&dateRelativeness=@Day

Meetings

Meetings that I attend

Graphical user interface, application

Description automatically generated

/File?$filter=Meeting/End ge datetime'2021-07-02T00:00:00%2b02:00' and Meeting/State_Value ne 'CANCELED' and Parties/any(a: a/NameKey_Value eq '%40Me')&dateRelativeness=@Day

Document lists

Name

Definition

Documents

My documents, mails etc. not archived or closed

Graphical user interface

Description automatically generated with medium confidence

/Records?$filter= Officer_Value eq '%40Me' and Pax ne 'A' and (State_Value eq 'UP' or State_Value eq 'U%C3%85' or State_Value eq 'UL')

Drafts

My documents that are stilldrafts

Graphical user interface, text, application

Description automatically generated

/Records?$filter= Officer_Value eq '%40Me' and (State_Value eq 'UP' or State_Value eq 'U%C3%85')

Documents with reminders

Documents with reminders for me within the next week

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Reminders/any(a: a/ReminderDate lt datetime'2021-07-09T00:00:00' and a/NameCode eq '@Me' and a/Marking_Value ne 'P') &dateRelativeness=@Day+8

 

Today

My documents, mails etc. stored today

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Officer_Value eq '%40Me' and RecordType_Value ne 'EMBED' and Created lt datetime'2021-07-02T00:00:00'& dateRelativeness=@Day

Documents with no case handler and unit

Documents with no case handler and unit

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Officer_Value eq null and ResponsibleOu_Value eq null and Rej eq null and Pax ne 'P'

Scanned today

Todays scanned mail for the organisation

Graphical user interface, application

Description automatically generated

/Records?$filter=Source_Value eq 'SKAN' and Created ge datetime'2021-07-01T00:00:00' and Created lt datetime'2021-07-02T00:00:00'&dateRelativeness=@Day

Unit's documents with no case handler

Unit's documents with no case handler

Graphical user interface, application

Description automatically generated

/Records?$filter=ResponsibleOu_Value eq '%40Unit' and Officer_Value eq null and Rej eq null

Recycle Bin

Recycled documents

Graphical user interface, text, application

Description automatically generated

/Records?$filter=ThrashedBy_Value eq '%40Me'

Changed documents

Changed documents that I follow

Graphical user interface, text, application

Description automatically generated

/Records?$filter=MruChanged/User_Value eq '%40Me' and MruChanged/Follow

Favorite documents

My favorite documents

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Mru/User_Value eq '%40Me' and Mru/Favorite

Recent documents

My recent documents

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Mru/User_Value eq '%40Me' and Mru/EntityUpdated ne null

Followed documents

Documents that I follow

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Mru/User_Value eq '%40Me' and Mru/Follow

Reading list documents

Documents on my reading list

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Mru/User_Value eq '%40Me' and Mru/ReadingList

Unanswered documents

My unanswered documents

Graphical user interface, text, application

Description automatically generated

/Records?$filter=Officer_Value eq '%40Me' and ReplyTimeLimitDate ne null and Replied eq null

Public mail list for today

Public mail list for today

Graphical user interface, application

Description automatically generated

/Records?$filter=PostList_Value eq 'OP' and RecordType_Value eq 'I' and Created lt datetime'2021-07-02T00:00:00'&dateRelativeness=@Day

Internal mail list for today

Internal mail list for today

Graphical user interface, application

Description automatically generated

/Records?$filter=PostList_Value eq 'LP' and RecordType_Value eq 'I' and Created lt datetime'2021-07-02T00:00:00'&dateRelativeness=@Day

All unconverted – total

All documents that cannot be converted to another format, regardless of who has saved the document (all states)

/Records?$filter=(RenderInfo/State_Value eq 'FAILED' or RenderInfo/State_Value eq 'SKIPPED' or RenderInfo/State_Value eq 'REVIEW')

Unconverted

Documents I have saved that cannot be converted to another format due to errors in the documents (REVIEW, Action required)

Graphical user interface, application

Description automatically generated

/Records?$filter=RenderInfo/State_Value eq 'REVIEW' and DocUser_Value eq '%40Me'

All unconverted

All documents I have saved that cannot be converted to another format (all states)

Graphical user interface, application

Description automatically generated

/Records?$filter=(RenderInfo/State_Value eq 'FAILED' or RenderInfo/State_Value eq 'SKIPPED' or RenderInfo/State_Value eq 'REVIEW') and DocUser_Value eq '%40Me'

Contact lists

List name

Definition

Changed contacts

Changed contacts that I follow

Graphical user interface, text, application

Description automatically generated

/Contacts?$filter=MruChanged/User_Value eq '%40Me' and MruChanged/Follow

Followed contacts

Contacts that I follow

Graphical user interface, text, application

Description automatically generated

/Contacts?$filter=Mru/User_Value eq '%40Me' and MruChanged/Follow

Reading list contacts

Contacts on my reading list

Graphical user interface, text, application

Description automatically generated

/Contacts?$filter=Mru/User_Value eq '%40Me' and MruChanged/ReadingList

Recent contatcs

My recent contacts

Graphical user interface, text, application

Description automatically generated

/Contacts?$filter=Mru/User_Value eq '%40Me' and Mru/EntityUpdated ne null

Favorite contacts

My favorite contacts

Graphical user interface, text, application

Description automatically generated

/Contacts?$filter=Mru/User_Value eq '%40Me' and MruChanged/Favorite