on 01-11-2012 3:27 PM
Hi,
I am trying to write a query which returns all the master agreement names, id, date etc which are neither closed nor cancelled. I wrote the query given below. However it returned no results.
Select
<%RESULTS%>
From
<%SCHEMA%>.FCI_CONTRACT T1
Where
T1.CANCELED_AT = NULL
Please let me know where i am going wrong.
Regards,
Anshuman
Hi Anshuman,
In the WHERE clause you might want to add T1.INACTIVE=0. No need to check CANCELLED_AT. Also, I noticed you donu2019t have the CONTEXT token in your query. It is important to have the CONTEXT token in all queries. You need to add T1.CONTEXTID = <%CONTEXT(contracts.Contract)%> to the WHERE clause. For more details on the usage of the token see the help section.
Regards,
Vikram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.