search

PxTools / PxWebApi

The api
Apache License 2.0
4 stars 3 forks source link

SSB: codelists link yields 500 #50

Open JohannesFinsveen opened 7 months ago

JohannesFinsveen commented 7 months ago

Describe the bug For SSB: Links to codelists in tables/07459/metadata?lang=no returns 500

To Reproduce Steps to reproduce the behavior:

  1. Enter url for first codelist in tables/07459/metadata?lang=no
JohannesFinsveen commented 1 month ago

Seems the problem must be solved in https://github.com/PxTools/PCAxis.Sql In pxwebapi: In GetGrouping in CnmmDataSource in PxWeb.Code.Api2.DataSource.Cnmm : PCAxis.Sql.Repositories.GroupingRepository repo = new PCAxis.Sql.Repositories.GroupingRepository(cnmmOptions.DatabaseID); PCAxis.Sql.Models.Grouping grouping = repo.GetGrouping(id, language);

The GetGrouping uses @ as parameter prefix, which is good for microsoft, but oracle need :