Article Details
Id:21033
Product:finPOWER Connect
Type:NEW
Version:4.01.00
Opened:01/10/2021
Closed:22/01/2024
Released:29/04/2024
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.