Hi Guys !
I have a legacy database and I can’t change the fields name
I’ve used the bake all for a table called “pdf_citacao”, then cake paginate did this:
SELECT * FROM (SELECT PdfCitacao.id AS [PdfCitacao__id], PdfCitacao.CDA AS [PdfCitacao__CDA], PdfCitacao.SERVENTIA AS [PdfCitacao__SERVENTIA], PdfCitacao.NOME DEVEDOR AS [PdfCitacao__NOME DEVEDOR], PdfCitacao.LOGRADOURO AS [PdfCitacao__LOGRADOURO], PdfCitacao.CEP AS [PdfCitacao__CEP], PdfCitacao.CIDADE/UF AS [PdfCitacao__CIDADE/UF], PdfCitacao.INSC-ESTAD AS [PdfCitacao__INSC-ESTAD], PdfCitacao.CNPJ/CPF AS [PdfCitacao__CNPJ/CPF], PdfCitacao.DATA DIVID AS [PdfCitacao__DATA DIVID], PdfCitacao.MOEDA AS [PdfCitacao__MOEDA], PdfCitacao.VALOR DIV ORIGEM AS [PdfCitacao__VALOR DIV ORIGEM], PdfCitacao.INFRINGENCIAS AS [PdfCitacao__INFRINGENCIAS], PdfCitacao.LOCAL-DATA AS [PdfCitacao__LOCAL-DATA], PdfCitacao.PROCURADOR AS [PdfCitacao__PROCURADOR], (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) AS [_cake_page_rownum_] FROM pdf_citacao PdfCitacao) _cake_paging_ WHERE _cake_paging_._cake_page_rownum_ <= 20
But the correct would be:
SELECT * FROM
(SELECT PdfCitacao.[id] AS [PdfCitacao__id],
PdfCitacao.[CDA] AS [PdfCitacao__CDA],
PdfCitacao.[SERVENTIA] AS [PdfCitacao__SERVENTIA],
PdfCitacao.[NOME DEVEDOR] AS [PdfCitacao__NOME DEVEDOR],
PdfCitacao.[LOGRADOURO] AS [PdfCitacao__LOGRADOURO],
PdfCitacao.[CEP] AS [PdfCitacao__CEP],
PdfCitacao.[CIDADE/UF] AS [PdfCitacao__CIDADE/UF],
PdfCitacao.[INSC-ESTAD] AS [PdfCitacao__INSC-ESTAD],
PdfCitacao.[CNPJ/CPF] AS [PdfCitacao__CNPJ/CPF],
PdfCitacao.[DATA DIVID] AS [PdfCitacao__DATA DIVID],
PdfCitacao.[MOEDA] AS [PdfCitacao__MOEDA],
PdfCitacao.[VALOR DIV ORIGEM] AS [PdfCitacao__VALOR DIV ORIGEM],
PdfCitacao.[INFRINGENCIAS] AS [PdfCitacao__INFRINGENCIAS],
PdfCitacao.[LOCAL-DATA] AS [PdfCitacao__LOCAL-DATA],
PdfCitacao.PROCURADOR AS [PdfCitacao__PROCURADOR],
(ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) AS [_cake_page_rownum_] FROM pdf_citacao PdfCitacao) _cake_paging_ WHERE _cake_paging_._cake_page_rownum_ <= 20
Is there a way to use the ORM in this situation?