NEW4.01.00 · Released 29 April 2024
NEWfinPOWER Connect
Released in
4.01.00
29 April 2024
  1. Opened1 Oct 2021
  2. Closed22 Jan
  3. Released29 Apr
Article 21033 Job J027501

ISQueue table; add additional columns

The following columns have been added to the ISQueue table to enhance the message queue facility.

  • Reference1
    • 50 characters text.
    • Indexed
  • Reference2
    • 50 characters text.
    • Indexed
  • Reference3
    • 50 characters text.
    • Indexed
  • RetryUtcDate
    • Date in UTC time
    • Indexed
    • Used to delay processing until the retry UTC date and time specified.

The ISMessageQueueItem object now includes the additional properties:

  • Reference1
  • Reference2
  • Reference3
  • RetryUtcDate

New/ Updated functions in ISMessageQueueUtilities:

  • New overloaded CreateItem function, with additional parameters.
    • Reference1
    • Reference2
    • Reference3
    • RetryUtcDate
  • New overloaded GetItems function, with additional parameters:
    • FilterReference1
    • FilterReference2
    • FilterReference3
  • GetItemsForProcessing parameters updated.
    • New parameter retryUtcDate
      • If specified, only Queued Items with a RetryUtcDate on or before this date/ time are included.
  • ProcessingEnd parameters updated.
    • NewReference1
    • NewReference2
    • NewReference3
    • NewRetryUtcDate
      • Will be upodated if NewStatus is Queued, otherwise Nulled on the database.

Allow these database fields to be updated.