הנה שאילתא שמתאים ל-SQL Server (לא להריץ בתוך פריוריטי!!)
נמצא בתוך נספח גם כן, כי אולי ישתבש כאן בהדבקה
[file name=DataExchangeErrors.txt size=2507]https://www.priority-forums.com/he/images/fbfiles/files/DataExchangeErrors.txt[/file]
אפשר להמיר את השאילתא הזה לסינטקס של פריוריטי אבל צריכים לוותר על השרשור של ההודעה בחברה המקבלת, דבר שעושה את השאילתא הזה כל כך שימושי
SELECT INTERMESSAGESS.MESSAGE MESSAGESENT, INTERMESSAGES.MESSAGE MESSAGERECEIVED,
dbo.tabula_hebconvert(dbo.INTERMESSAGES.SUBJECT) AS SUBJECT,
dbo.INTERMESSAGES.REFERENCE ,
dbo.INTERMESSAGES.COMPANY,
dbo.tabula_hebconvert(ENVIRONMENTS.TITLE) AS SENDINGCOMPANY,
ISNULL(BASEFORMLANGEXECS.TITLE,dbo.tabula_hebconvert(BASEFORMS.TITLE)) as SENDINGFORM,
dbo.tabula_dateconvert(INTERMESSAGESS.UDATE) AS UDATE,
INTERMESSAGESS.UDATE AS UDATE_PRI,
dbo.INTERMESSAGES.DNAME,
dbo.tabula_hebconvert(ENVIRONMENT.TITLE) AS RECEIVINGCOMPANY,
ISNULL(BASEFORMLANGEXEC.TITLE,dbo.tabula_hebconvert(BASEFORM.TITLE)) as RECEIVINGFORM,
dbo.tabula_hebconvert(dbo.T$EXEC.TITLE) AS TITLE,
dbo.tabula_hebconvert(ISNULL(dbo.INTERMESSAGES.USERLOGIN, N'')) AS SENT_BY,
USERSB.EMAIL AS SENT_BY_EMAIL,
dbo.tabula_hebconvert(dbo.INTERMESSAGES.ERROR) AS ERROR,
INTERMESSAGESTEXTALL.ALLTEXT AS ERRORTEXT
FROM dbo.INTERMESSAGES
OUTER APPLY ( SELECT stuff((SELECT ' ' + dbo.tabula_hebconvert(ISNULL(INTERMESSAGESTEXT.TEXT, N''))
FROM dbo.INTERMESSAGESTEXT
WHERE INTERMESSAGESTEXT.MESSAGE = dbo.INTERMESSAGES.MESSAGE
ORDER BY TEXTORD
FOR XML PATH(''),TYPE).value('text()[1]','nvarchar(max)'),1,1,N'') ) INTERMESSAGESTEXTALL(ALLTEXT)
INNER JOIN dbo.T$EXEC ON dbo.INTERMESSAGES.ENAME = dbo.T$EXEC.ENAME AND dbo.T$EXEC.TYPE = 'S'
INNER JOIN dbo.T$EXEC BASEFORM ON T$EXEC.T$TABLE = BASEFORM.T$EXEC
LEFT OUTER JOIN dbo.LANGEXEC BASEFORMLANGEXEC ON BASEFORM.T$EXEC = BASEFORMLANGEXEC.T$EXEC and BASEFORMLANGEXEC.LANG = 3
/* for the Sending INTERMESSAGES */
INNER JOIN dbo.INTERMESSAGES INTERMESSAGESS ON INTERMESSAGESS.MESSAGE = dbo.INTERMESSAGES.EXTMESSAGE
INNER JOIN dbo.T$EXEC EXECS ON INTERMESSAGESS.ENAME = EXECS.ENAME AND EXECS.TYPE = 'S'
INNER JOIN dbo.T$EXEC BASEFORMS ON EXECS.T$TABLE = BASEFORMS.T$EXEC
LEFT OUTER JOIN dbo.LANGEXEC BASEFORMLANGEXECS ON BASEFORMS.T$EXEC = BASEFORMLANGEXECS.T$EXEC and BASEFORMLANGEXECS.LANG = 3
INNER JOIN dbo.ENVIRONMENT ON INTERMESSAGES.DNAME = ENVIRONMENT.DNAME
INNER JOIN dbo.ENVIRONMENT ENVIRONMENTS ON INTERMESSAGESS.DNAME = ENVIRONMENTS.DNAME
LEFT OUTER JOIN dbo.USERS ON USERS.USERLOGIN = INTERMESSAGES.USERLOGIN
LEFT OUTER JOIN dbo.USERSB ON USERS.T$USER = USERSB.T$USER
WHERE (dbo.INTERMESSAGES.TYPE = 'R')
AND INTERMESSAGES.ERROR ''
