Reference manual

System Functions

Find System Function Usages… finds where built-in functions such as FINDSET, MODIFY or DELETE are applied to one object. It finds explicit calls on a variable, as in CustomerRec.FINDSET(FALSE, FALSE);, and implicit calls inside the object itself, as in FINDSET(FALSE, FALSE);.

Opening the System Functions window

  • Right-click an object in the Object index, or its heading in the Object view, and choose Find System Function Usages….
  • In Universal Search, select the object, press Tab and choose Find System Function Usages….

Your license must include finding usages. The System Functions window opens, listing the functions that apply to that object's type.

The System Functions window

Prism for C/AL System Functions window with DELETE and DELETEALL checked for table Sales Header
1 2 3 4 5 6 7 8
DELETE and DELETEALL checked for table Sales Header.
#NameDescription
1System function usages of objectThe object the functions are applied to.
2SearchNarrows the function list to the names that contain the text.
3Collapse all groupsCollapses every group.
4Expand all groupsExpands every group.
5GroupThe functions in groups: Create, Read, Update, Delete and Other.
6FunctionCheck each function to search for. You can check functions in several groups.
7SearchEnabled once a function is checked. Closes the window and finds the usages.
8CancelCloses the window without searching.

The results open in the Usages window. For a table, its filter panel can leave out usages on temporary records; see Temporary record filter.

Find where records of a table are deleted

Use this when records disappear and you need every piece of code that can delete them. The example uses sales documents.

  1. Press Ctrl+T, type t36 and press Enter to open table 36 Sales Header.
  2. Right-click the object heading in the object view and choose Find System Function Usages….
  3. Under Delete, check DELETE and DELETEALL, and select Search.
  4. In the Usages window, press Ctrl+O and choose Zoom in on physical usages to leave out deletes of temporary records.
  5. Type Invoice in the search box to narrow the list to the lines that mention it, or select each usage to read it in context.

Find where records of a table are inserted or modified

  1. Open the table and choose Find System Function Usages… from its context menu.
  2. Check the functions under Create and Update, such as INSERT, MODIFY and MODIFYALL, and RENAME under Other, and select Search.
  3. Press Ctrl+O and choose Zoom in on physical usages to leave out temporary records.

To find where one field is changed, use Find where a field is written instead.

Behavior

  • Window title: Find built-in function usages.
  • Search box: filters the function list a moment after you stop typing; it does not search code.
  • Functions offered: depend on the object's type, so a table lists the record functions.