Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
rachyharkov opened this issue Oct 27, 2023 · 2 comments
Labels
bug Something isn't working

Comments

@rachyharkov
Copy link

rachyharkov commented Oct 27, 2023

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 rachyharkov added the bug Something isn't working label Oct 27, 2023
@rachyharkov rachyharkov changed the title query builder datatable didnt correctly read alias string query builder datatable didnt correctly read alias string while data searching Oct 27, 2023
@rachyharkov
Copy link
Author

rachyharkov commented Oct 27, 2023

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
Copy link
Author

the fix is on PR #38

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant