cancel
Showing results for 
Search instead for 
Did you mean: 

Query Definition

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

Former Member
0 Kudos

Dear Vikram,

Thanks a lot for the response. I have managed to generate the report.

I had not used the Context ID token as i was working on an on-premise version. Henceforth, as a best practice i shall include it in my query.

Thanks a lot once again!

Kind Regards,

Anshuman

Answers (0)