This procedure retrieves information about the table and field used for a column in the SmartList object. The information is used in the query generated while searching the data for the SmartList object.
The procedure must have the following parameters:
in integer IN_Object_Dict_ID; in integer IN_Object_Type; in integer IN_Field_Dict_ID; in integer IN_Field; inout string IO_Table_Name; inout integer IO_Table_Dict_ID; inout integer IO_DDL_Type;
IN_Object_Dict_ID – An integer specifying the ID of the dictionary that defines the SmartList object.
IN_Object_Type – An integer specifying the type of SmartList object. For SmartLists defined in the core application, the value corresponds to one of the constants defined in SmartList objects.
IN_Field_Dict_ID – An integer specifying the ID of the dictionary that defines the field for which information is being retrieved.
IN_Field_ID – An integer specifying the resource ID of the field for which information is being retrieved.
IO_Table_Name – A string that must be set by the procedure to indicate the technical name of the table that contains the specified field.
IO_Table_Dict_ID – An integer that must be set by the procedure to indicate the dictionary ID of the product that defines the field and table.
IO_DDL_Type – An integer that must be set by the procedure to indicate the type of list field used for the field. The value 0 indicates a 0-based list, while the value 1 indicates a 1-based list. If the field isn’t a list, specify the value 1.