Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

First run a search full search on awarded grants (Disposition = Approved). If certain date range in mind, the filter for that needs to be applied as well (most likely this has to be done through advanced search module).that have Funded Project Status field set to either "Approved" or "Delivered". This is the advanced search script for it:

Requests.Disposition = 'Approved' AND (REQUESTS_EXT.Funded_Project_Status = 'Approved to be published' OR REQUESTS_EXT.Funded_Project_Status = 'Delivered')

The list viewer brings up the results.

...

Check the "Year Awarded" column. IF If empty, fill it based on "Disposition Date" column.

...