Add table: List of contracting processes for buyer

sabahfromlondon commented 9 months ago

Table details:

[ ] Title: List of contracting processes for buyer
[ ] Description: A full list of the buyers' contracting processes and the red flags associated with it. Use this to identify which buyers have more risk.

Filters:

[ ] Ocid
[ ] Date range
[ ] Procurement method
[ ] Supplier name
[ ] Status

Columns:

Column Heading | Field Description | Requirements -- | -- | -- OCID | The OCDS field ocid. The globally unique identifier for this Open Contracting Process. | Tender title | The title for the contracting process as per the OCDS field tender/title. | Users can click the tender title and go to the Individual Contracting Processes Dashboard. Date | The OCDS field tender/startDate. | Users can filter the contracting processes by selecting a date range. Procurement method | The method used to procure the goods/services. The OCDS field is tender/procurementMethodDetails. | Users can sort by procurement method Tender value | The value of the contract and the currency. OCDS fields tender/valueAmount and tender/valueCurrency. | Users can sort by value amount e.g. highest to lowest. Supplier name | The name of the entity supplying the goods/services. The OCDS field supplier/name. | Users can click on the supplier name to go to the Individual Suppliers Dashboard. Users can filter for a specific supplier Can be multiple suppliers. Have all suppliers in one row, semi colon separated Count of red flags | The total number of red flags for the contracting process | Users can sort by value e.g. highest to lowest. Red flag name | The name of the red flags indicators, | All red flag names in one row, separated by a semi-colon Status | The current status of the tender, from the tender/status codelist, using the OCDS field tender/status. | Users can filter by status using a dropdown with the different options.

sabahfromlondon commented 9 months ago

@Camilamila are you sure you want to use te column heading "Procurement method" for this table, since we are using the field tender/procurementMethodDetails?

Camilamila commented 9 months ago

Yes we can leave "procurement method" for the heading.

sabahfromlondon commented 9 months ago

Ok thanks, I've updated the filter as well

Camilamila commented 4 months ago

The procurement method column should use the field tender/procurementMethodDetails

vgeryarbc commented 1 month ago

Done

jpmckinney commented 1 month ago

Camilamila commented 2 weeks ago

Instead of tender/title can we use the field tender/description?

open-contracting / bi.open-contracting.org

Add table: List of contracting processes for buyer #84