search

Puzzlepart / prosjektportalen

Prosjektportal for SharePoint er et prosjektstyringsverktøy for SharePoint basert på prosjektveiviseren
Other
30 stars 16 forks source link

Sorting by valuta field in portfolio page #208

Closed olemp closed 7 years ago

olemp commented 7 years ago

Category

[ ] Enhancement

[x] Bug

[ ] Question

Summary

Sorting by valuta field in portfolio page doesn't work.

208-01

Version

1.16.0

olemp commented 7 years ago

No easy way to solve this.

tarjeieo commented 7 years ago

This would be really great to have implemented. What is the issue related to this?

olemp commented 7 years ago

The format of the data retrieved from search.

olemp commented 7 years ago

You could have a look @tarjeieo, but I'm not sure how to do this without hacking it up.

olemp commented 7 years ago

This is how the response looks

{
  "Rank": "16.6951484680176",
  "DocId": "462434362",
  "Title": "Lokalt veivalg",
  "Path": "https://olemp.sharepoint.com/sites/ppv2-01/lokalt-veivalg",
  "RefinableString52": "Konsept",
  "RefinableString53": "Administrasjon og IKT",
  "RefinableString54": "Annet",
  "GtStartDateOWSDATE": "2017-06-27T22:00:00Z",
  "GtEndDateOWSDATE": "2019-06-28T22:00:00Z",
  "RefinableString51": "Steffen R. Norby",
  "RefinableString50": "Tarjei E. Ormestøyl",
  "GtStatusTimeOWSCHCS": "På plan",
  "GtStatusBudgetOWSCHCS": "Mindre overskridelser",
  "GtStatusRiskOWSCHCS": "Høy",
  "GtProjectGoalsOWSMTXT": "Uavhengig av en vedvarende innovasjon stimuleres egenarten med henblikk på løsningen.",
  "Created": "2017-06-28T08:57:55.0000000Z",
  "LastModifiedTime": "2017-06-28T09:28:43.0000000Z",
  "GtProjectNumberOWSTEXT": "",
  "GtArchiveReferenceOWSTEXT": "",
  "OriginalPath": "https://olemp.sharepoint.com/sites/ppv2-01/lokalt-veivalg",
  "GtGainsResponsibleOWSUSER": "olemp@olemp.onmicrosoft.com | Ole Martin Pettersen | 693A30232E667C6D656D626572736869707C6F6C656D70406F6C656D702E6F6E6D6963726F736F66742E636F6D i:0#.f|membership|olemp@olemp.onmicrosoft.com",
  "GtStatusQualityOWSCHCS": "Mindre avvik fra spesifikasjon",
  "GtStatusGainAchievementOWSCHCS": "Foran plan",
  "GtOverallStatusOWSMTXT": "Med utgangspunkt i en helhetlig treffsikkerhet maksimeres erfaringsutvekslingen gjennom løsningen.",
  "GtProjectFinanceNameOWSTEXT": "lokalt-veivalg",
  "GtBudgetTotalOWSCURR": "44500000.0000000",
  "GtCostsTotalOWSCURR": "125000.000000000",
  "GtProjectForecastOWSCURR": "44487500.0000000",
  "GtBudgetLastReportDateOWSDATE": "2017-06-27T22:00:00Z",
  "PartitionId": "4ac53033-31c4-4ed5-b056-0a5cf7cc6a8d",
  "UrlZone": "0",
  "Culture": "nb-NO",
  "ResultTypeId": "0",
  "RenderTemplateId": "~sitecollection/_catalogs/masterpage/Display Templates/Search/Item_Default.js",
  "piSearchResultId": "0_1"
}
olemp commented 7 years ago
Key Value
GtBudgetTotalOWSCURR 44500000.0000000
GtCostsTotalOWSCURR 125000.000000000
GtProjectForecastOWSCURR 44487500.0000000
olemp commented 7 years ago

If we could parse these values to int using parseInt somewhere, that might solve this.

olemp commented 7 years ago

Pull https://github.com/Puzzlepart/prosjektportalen/pull/247 might solve this. I don't have enough project in my dev site at the moment to test this.

olemp commented 7 years ago

Tested, and confirmed working.