We haven't implemented sorting on the currency field type. It would be very useful.<br

I should be able to sort by amount about twenty HOT 1 CLOSED

FelixMalfait commented on August 18, 2024

I should be able to sort by amount

from twenty.

Comments (1)

greptile-apps commented on August 18, 2024

To implement sorting and filtering for the currency field type, follow these steps:

Update formatFieldMetadataItemInput:
- Path: /packages/twenty-front/src/modules/object-metadata/utils/formatFieldMetadataItemInput.ts
- Ensure the currency field type is correctly formatted.
Modify selectOptionsSchema:
- Path: /packages/twenty-front/src/modules/object-metadata/validation-schemas/selectOptionsSchema.ts
- Add validation for the currency field type if necessary.
Enhance getObjectRecordIdentifier:
- Path: /packages/twenty-front/src/modules/object-metadata/utils/getObjectRecordIdentifier.ts
- Ensure the currency field type is included in the identifier logic.
Update useGetRelationMetadata:
- Path: /packages/twenty-front/src/modules/object-metadata/hooks/useGetRelationMetadata.ts
- Ensure the currency field type is handled in relation metadata.
Implement Sorting and Filtering Logic:
- Identify where sorting and filtering logic is applied in the codebase (e.g., in hooks or components handling object metadata).
- Add cases for the currency field type to enable sorting and filtering.

Example Code Snippet for Sorting:

// Add this in the relevant sorting utility function
if (field.type === 'Currency') {
  // Sorting logic for currency
  return records.sort((a, b) => parseFloat(a[field.name]) - parseFloat(b[field.name]));
}

Example Code Snippet for Filtering:

// Add this in the relevant filtering utility function
if (field.type === 'Currency') {
  // Filtering logic for currency
  return records.filter(record => record[field.name] === filterValue);
}