RecordSortedList Class

Definition

The RecordSortedList class inserts multiple records in a single database trip.

public ref class RecordSortedList : Microsoft::Dynamics::Ax::Xpp::XppObjectBase
[Microsoft.Dynamics.Ax.Xpp.KernelClass]
public class RecordSortedList : Microsoft.Dynamics.Ax.Xpp.XppObjectBase
[<Microsoft.Dynamics.Ax.Xpp.KernelClass>]
type RecordSortedList = class
    inherit XppObjectBase
Public Class RecordSortedList
Inherits XppObjectBase
Inheritance
Microsoft.Dynamics.AX.KernelInterop.ProxyBase
RecordSortedList
Attributes

Remarks

Use RecordSortedList when you want a subset of data from a particular table, and you want it sorted in an order that does not currently exist as an index. A RecordSortedList object holds records from a single table. The list has a unique key that is defined by the fields listed by using the sortOrder method. Records are automatically sorted as they are inserted, they do not have to be inserted in sort sequence. RecordSortedList objects are particularly useful for passing a result-set as a parameter There is no limit to the size of a RecordSortedList object, but they are completely memory-based, so there are potential memory consumption problems. RecordSortedList objects must be server-located before the insertDatabase method can be called. Otherwise, an exception is thrown. Record level security (RLS) cannot be applied by the RecordSortedList class. RLS is applied by the RecordInsertList class). Use a RecordSortedList in preference to a temporary table in the following situations:

  • Only one sort order is needed.
  • The number of records is not too high (to avoid memory problems).

Compared to temporary tables, RecordSortedList objects:

  • Are faster.
  • Are not disk-based.
  • Only have one index.
  • Cannot be used in forms.
  • Require a call between the client and server per (grouped) read.

Constructors

RecordSortedList()
RecordSortedList(Int32)
RecordSortedList(Int32, Common)
RecordSortedList(IntPtr)

Fields

kernelClass (Inherited from XppObjectBase)

Methods

__shouldCallNew(Type)
addXppProxyReference(Type, Object) (Inherited from XppObjectBase)
Call(String, Object[], Type[], Object[]) (Inherited from XppObjectBase)
cancelTimeOut(Int32) (Inherited from XppObjectBase)
createKernelClass(Object[], Type[], Object[]) (Inherited from XppObjectBase)
del(Common)

Removes a record that has a key that matches the key fields in the recordBuffer from the recordSortedList.

equal(XppObjectBase) (Inherited from XppObjectBase)
finalize() (Inherited from XppObjectBase)
find(Common)

Sets the record buffer to the contents of the record that has a key that matches the key fields in the record buffer, and positions the list to the record returned.

first(Common)

Positions the list to the first record in the list, and copies its contents to the record buffer.

GetIntPtr()
GetKernelInstanceUniqueId() (Inherited from XppObjectBase)
getTimeOutTimerHandle() (Inherited from XppObjectBase)
getXppProxyReference(Type) (Inherited from XppObjectBase)
handle()
ins(Common)

Inserts a new record in a RecordSortedList, unless it is a duplicate.

ins(Common, Boolean)
insertDatabase()

Inserts multiple records on a single trip to the database.

insertDatabase(Connection)
IsManagedValid()
kernelhandle()
KernelInstanceDisposed() (Inherited from XppObjectBase)
len()

Returns the current number of records in a RecordSortedList object.

MakeReflectionCall(String, Object[]) (Inherited from XppObjectBase)
newmethod() (Inherited from XppObjectBase)
newmethod(Int32)

Initializes a new instance of the Object class.

newmethod(Int32, Common)
next(Common)

Sets the record buffer to the contents of the next record in the recordSortedList and positions the list to the record returned.

notify() (Inherited from XppObjectBase)
notifyAll() (Inherited from XppObjectBase)
objectOnServer()
Obsolete.
(Inherited from XppObjectBase)
setTimeOut(String, Int32)
Obsolete.
(Inherited from XppObjectBase)
setTimeOut(String, Int32, Boolean)
Obsolete.
(Inherited from XppObjectBase)
sortOrder(Int32, Object[])

Defines the fields on which the records are sorted.

sortOrderFromContainer(Object[])

Defines the fields on which the records are sorted.

usageCount() (Inherited from XppObjectBase)
VerifyKernelClass() (Inherited from XppObjectBase)
wait() (Inherited from XppObjectBase)
Xml() (Inherited from XppObjectBase)
Xml(Int32) (Inherited from XppObjectBase)

Applies to