CodeIgniter4-DataTables icon indicating copy to clipboard operation
CodeIgniter4-DataTables copied to clipboard

query builder datatable didnt correctly read alias string while data searching

Open rachyharkov opened this issue 2 years ago • 2 comments

It looks like the string inside SELECT function was not converted correctly, showing an error that the column does not exist as a result

here is my code image

Here is the error WhatsApp Image 2023-10-27 at 08 51 01

but if output it with findAll(), looks fine image

This is only happen on search

Version (please complete the following information):

  • PHP Version: 7.4
  • CodeIgniter version: 4.x
  • Library version: 0.6.1
  • Db: Postgresql

rachyharkov avatar Oct 27 '23 02:10 rachyharkov

The number of strings deleted was too large, so the "e" was also deleted. I modified a bit how the string deleted by adding 1 position

image

image

here is the fix image

soo here is the result that should be looks like

image

soo i can get u.name correctly

rachyharkov avatar Oct 27 '23 03:10 rachyharkov

the fix is on PR #38

rachyharkov avatar Oct 27 '23 03:10 rachyharkov