Posts by Israel Merljak • 943 points
56 posts
-
2
votes2
answers238
viewsA: Is it possible to reuse the parameters of a Query in JPA?
After investigating a little more to understand the functioning of Query and how this Object manages the parameters, I identified that when mounting the JPQL and create the object instance, is…
-
0
votes2
answers238
viewsQ: Is it possible to reuse the parameters of a Query in JPA?
Hello, I have a question regarding Parameters of the object Query in the JPA. I am implementing pagination of my tables using the Primefaces with LazyDataModel and in the function I use to make the…
-
2
votes1
answer584
viewsA: Self-relationship with Eloquent in Laravel 5:3
After breaking my head enough I decided. Besides I forgot to restart Tinker (my changes were not reflecting). The correct association for my case was $this->belongsTo() because FK is local (this…
-
2
votes1
answer584
viewsQ: Self-relationship with Eloquent in Laravel 5:3
I am building an immigrant control application and I own an imigrants table that has 3 self relationships. Its structure is as follows. id -> pk first_name -> varchar last_name -> varchar…
-
0
votes1
answer401
viewsA: Count with LEFT JOIN does not return when zero or null
I managed to solve the problem, apparently I needed to group the results. The query was like this: SELECT usuarios.nome AS nome_autor, pc_pesquisa.*, COUNT(pc_resposta_pesquisa.id) AS respostas FROM…
mysqlanswered Israel Merljak 943 -
3
votes1
answer401
viewsQ: Count with LEFT JOIN does not return when zero or null
I have a problem in a select where I need to get the data from 3 tables (search, users, and search). Where query can or n have data. The current query is: SELECT usuarios.nome AS nome_autor,…
mysqlasked Israel Merljak 943