• State Suggested Answer
  • Replies 9 replies
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 4553 views
  • Users 0 members are here
Options
Related

Mail Template scripts

Aramis
over 4 years ago

Hello! 

1IM 8.1

I need get XDateInserted from Department view in Mail Template. 

I wrote script: 

Public Function CCC_Department_Get_XDateInserted_1(ByVal dbDepartment As ISingleDbObject) As String
            Dim strLOGFileName = "C:\temp\logs\temp.txt"


            Dim obj As String = dbDepartment.GetValue("XDateInserted").ToString()

            VID_Write2Log(strLOGFileName, String.Format("{0}, ==> Date: {1}", Now.ToString(), obj))

            Return obj

        End Function

But I catch empty string. 

In the Mail Teplate I wrote: $Script(CCC_Department_Get_XDateInserted_1)$

Any ideas? 

Parents
  • 0 over 4 years ago

    In the example you are not passing a dbDepartment for the script. Maybe it would help.

  • 0 over 4 years ago in reply to Tomi Kääriäinen

    How can I passing dbDepartment for the script? 

  • 0 over 4 years ago in reply to Aramis

    I would not pass the whole ISingleDbObject, because it is unneeded overhead. Giving the UID of the department is enough as the object can be fetched in script as well.

    Public Function TK_GetXDateInsertDepartmet(ByVal UID_Dep As String) As DateTime

    Dim dep = Connection.Session.Source().Get("Department", UID_Dep)
    Return dep.GetValue("XDateInserted")

    End Function

  • 0 over 4 years ago in reply to Tomi Kääriäinen

    Not working. 

    2019-12-02 10:43:32 +05:00 - \T-ONEIM-DB-4 - VI.JobService.JobComponents.MailComponent - 65b62e34-be4e-422b-a799-84fa1d70e08a: Errors occurred
    [810254] Could not find a script with the correct signature.
       at StdioProcessor.StdioProcessor._Execute(Job job)
       at VI.JobService.JobComponents.MailComponent.Activate(String task)
       at VI.JobService.JobComponents.MailComponent._SendRichMail()
       at VI.Mail.MailComposer.<Compose>d__5.MoveNext()
       at VI.Mail.MailComposer.Compose(IEntity richMail, MailParameters parameters)
       at VI.Mail.MailComposer._RenderMessageBody(MailTemplate template, MailBodyFormat bodyFormat, MailParameters parameters, MailMessage msg)
       at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator)
       at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat)
       at VI.DB.Scripting.PlaceholderReplacer._Replace(Match m)
       at VI.Base.SyncActions.Do[T](Func`1 function)
       at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
       ---- Start of Inner Exception ----
       at VI.DB.Entities.EntityWalker.<GetRawAsync>d__21.MoveNext()
    Log written to Job_65b62e34-be4e-422b-a799-84fa1d70e08a_20191202_104330862.log
Reply
  • 0 over 4 years ago in reply to Tomi Kääriäinen

    Not working. 

    2019-12-02 10:43:32 +05:00 - \T-ONEIM-DB-4 - VI.JobService.JobComponents.MailComponent - 65b62e34-be4e-422b-a799-84fa1d70e08a: Errors occurred
    [810254] Could not find a script with the correct signature.
       at StdioProcessor.StdioProcessor._Execute(Job job)
       at VI.JobService.JobComponents.MailComponent.Activate(String task)
       at VI.JobService.JobComponents.MailComponent._SendRichMail()
       at VI.Mail.MailComposer.<Compose>d__5.MoveNext()
       at VI.Mail.MailComposer.Compose(IEntity richMail, MailParameters parameters)
       at VI.Mail.MailComposer._RenderMessageBody(MailTemplate template, MailBodyFormat bodyFormat, MailParameters parameters, MailMessage msg)
       at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator)
       at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat)
       at VI.DB.Scripting.PlaceholderReplacer._Replace(Match m)
       at VI.Base.SyncActions.Do[T](Func`1 function)
       at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
       ---- Start of Inner Exception ----
       at VI.DB.Entities.EntityWalker.<GetRawAsync>d__21.MoveNext()
    Log written to Job_65b62e34-be4e-422b-a799-84fa1d70e08a_20191202_104330862.log
Children
No Data