Adrian Simpkins Posted February 28, 2020 Share Posted February 28, 2020 Hi All I am trying to setup a basic report to report on Cancelled requests, and including the Cancellation reason. When trying to run the report it is failing to pull any data in, and at the moment the only thing setup is the Select Filter logic which is set to Requests -> Status value equals Cancelled, and this returns no values. I know we have a large amount of cancelled requests from before we went live, and I can see this data in a Request List Filter I have setup which is set to just show Cancelled requests. Any idea why the report is failing at all please? Many thanks Link to comment Share on other sites More sharing options...
Steve Giller Posted February 28, 2020 Share Posted February 28, 2020 @Adrian Simpkins Are you matching on "Cancelled" or "status.cancelled"? I suspect the latter is required to pull back cancelled requests from the database. Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted March 2, 2020 Author Share Posted March 2, 2020 Hi Steve Ah yes that works fine, I will try to remember the Status.currentstatus logic going forward Many thanks ! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now