hermawanramadhan / CodeIgniter4-DataTables

MIT License
92 stars 38 forks source link

query builder datatable didnt correctly read alias string while data searching #41

Open rachyharkov opened 10 months ago

rachyharkov commented 10 months ago

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):

rachyharkov commented 10 months ago

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 commented 10 months ago

the fix is on PR #38