cancel
Showing results for 
Search instead for 
Did you mean: 

Alert doesnt work when the query is longer

Former Member
0 Kudos

Hi All,

I have created a query for an alert. The query works fine and gives the output. But when an alert is created from this query , the alert does not work. I could also find that the query is not getting stored completly in the OUQR Table. is there any solution for this?

Regards,

Priya

Accepted Solutions (0)

Answers (1)

Answers (1)

AdKerremans
Active Contributor
0 Kudos

Hi Priya,

You could create a stored procedure with this query and call the stored procedure from your alert

Regards

Ad

Former Member
0 Kudos

Hi,

Thanks for the reply. But this wont help me ( I tried this option ) since , the records displayed through a Stored Procedure will not have the link to the corresponding document (ie; the Yellow arrow button beside each field) . And this link is very important as the user has to open the document fro alert.

Thanks & Regards,

Priya

Former Member
0 Kudos

Hi Ad,

Is there any way to get the link to the documents for the records returned through a stored procedure?

Regards,

Priya

AdKerremans
Active Contributor
0 Kudos

HI Priya,

I have never used a stored procedure with an alert. I don't know if there is a way

Regards

Ad