Skip to Content
author's profile photo Former Member
Former Member

Alert management

Hi all,

I had to make an alerts for purchase order with an orange linking to the document .

The output of the query, I have made for alert, is giving the correct output with an orange link. But on message and alerts screen at the reciever's end for the same query the orange link does not appear.

  • Query written for the alert **********************************************************

WITH ABC AS

(

SELECT

ADOC.DocNum [A_DocNum], ADOC.[U_POAmendmentNo][A_POAmendmentNo], ADOC.UpdateDate

FROM ADOC

WHERE

ADOC.ObjType=22

AND

ADOC.LogInstanc = (SELECT MAX(T1.LogInstanc) FROM ADOC T1 WHERE ADOC.DocEntry=T1.DocEntry)

GROUP BY ADOC.DocNum,ADOC.[U_POAmendmentNo],ADOC.UpdateDate

)

SELECT T0.[DocNum], T0.[CardName], T0.[U_PO_No],T0.[U_POAmendmentNo] [PO Amendment No.] FROM OPOR T0

INNER JOIN ABC ON (T0.[DocNum] = ABC.[A_DocNum] AND ( ISNULL(T0.[U_POAmendmentNo],0)<> ISNULL(ABC.[A_POAmendmentNo],0)))

WHERE T0.[U_POAmendmentNo] >0 AND (DATEDIFF(DAY, T0.[UpdateDate],GETDATE())<1 )

***********************************************************************************************************************

Please guide me, if any one has an idea.

Regards

Sonil

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 27, 2011 at 02:20 PM

    Hi Sonil,

    You may try to add FOR Browse in the end of query. If not work, you will be out of luck.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 26, 2011 at 03:00 PM

    I have similar issues. I can not remember the key word off the top of my head but but I believe you add 'to browse' to the query. There is a wiki on how to write queries in business one. Also keep the joins and views to a minimal as orange arrows get lost.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Is there any thing related to history tables. As I have used ADOC history table.

      And if I make query using the SBO Query generator the logInstanc field for the table is not visible in the field list.

      and also i can not understand your staement 'add to browse ' my query. Please Elaborate.

      With Regards

      Sonil

      Edited by: sonilgarg on Sep 27, 2011 7:38 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.