Limitations or Rules for what is allowed within Builder?

MedicOneSystems / livewire-datatables

Advanced datatables using Laravel, Livewire, Tailwind CSS and Alpine JS

https://livewire-datatables.com/

MIT License

1.19k stars 258 forks source link

Limitations or Rules for what is allowed within Builder? #477

Open dyoh777 opened 2 years ago

dyoh777 commented 2 years ago

It appears that the builder has some limitations or restrictions. Maybe I'm doing something wrong. Can anyone point me to some examples of using 'where' or 'like' inside the builder? I'd like to query a subset of data in a few tables and then join them. I've viewed the examples within the project, but including conditionals is stumping me with some columns. Thanks!

dyoh777 commented 2 years ago

If anyone has information about this it would be useful to know. I worked around the issues via a combination of using Eloquent toSQL, SQL queries, and being specific about which 'table.field's were in use. The issues weren't causing many issues viewing data, but exporting seemed to have problems with the already displayed data. Hopefully this helps someone.