Jiwa

Trying to locate the SQL table & column where the 'Number of Days to Show History for' in the Sales Order Customer Panel is saved.

There is 1 user who I suspect has a large number here & is throwing an error SQLDateTime overflow error.
Disabling the plugin gets the user working OK.

Looking for ZZ_Table where UserID = "q7f7f84k4kd8dh3he7ej' and Column = 'sales order customer panel' (obviously not that exact string lol).

SY_UserProfile ?

SY_UserProfile ?

That was my first thought - very familiar with that table but I couldn't find the explicit row for the Customer Panel.
I still think that's the table but I just need to locate the correct row.

Code: Select all

        Contents = ""
        salesOrderForm.Manager.JLib.GetProfileKey(salesOrderForm.Manager.Database.JiwaLoginUserID, "Sales Order Customer Panel", "NumberDays", Contents)
        If Contents.Trim.Length > 0 Then
            If IsNumeric(Contents) Then
                panelForm.CustomerPanel_NumericEditor1.Value = CInt(Contents)
            End If
        End If


so you're looking for Section = "Sales Order Customer Panel" and IDKey = "NumberDays".

Code: Select all

SELECT [ProfileID]
      ,[LastSavedDateTime]
      ,[UserID]
      ,[Section]
      ,[IDKey]
      ,[Contents]
  FROM [dbo].[SY_UserProfile]
  where Section = 'Sales Order Customer Panel'
  and IDKey = 'NumberDays'