[?] missed join query for custom field in list view #977
Labels
No Milestone
No project
No Assignees
3 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: joomla/Component-Builder#977
Loading…
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Steps to reproduce the issue
create a custom field to get id (as key) and title (as value) from another db table
Expected result
in views (list view) title listed
Actual result
in views (list view) key only is listed
In the views model is missing the join-the-other-table query as it was in JCB until version 2.10.13 (that I know of, as I just upgraded to 3.1.13 from there).
System information (as much as possible)
Additional comments
So, have we to update all the query manually with custom code in the view?
Just to know what to do.
Where are you getting JCB3.1.13?
Only the versions listed here are to be used, and preferably the latest version.
Hello, still with the latest you given me the link of to test compiler issue.
Hello, any update?
If you are on the latest version? what is that version?
Then you will need to give me more details, screenshots as I am not fully able to follow what exactly is the issue and where and in what circumstances you arrived at this issue.
Hello, I'm using the version you given me the link of to test the "install all above extensions" button issue after the compiler.
Said that, add a custom field to demo component, look view, as follows:
Compile, install, add a new record to "look" selecting a component from this field.
I would expect to have the component's name shown in "looks" view instead only the "id" is listed.
If you check the model you can see is missing the "join" componentbuilder_joomla_component table in getListQuery method.
I hope this helps you to understand the issue.
I'm sorry, simply telling me what you did or did not do does not provide enough detail to help me diagnose the issue. To help me better understand the problem, I would need to see screenshots of your JCB GUI settings, as the details are critical.
Furthermore, stating that you are using a version of JCB that I gave you is not sufficient. In the opening of this issue, you mentioned using version 3.1.13, which we have deleted minutes after its release because it is broken. You should be using either version 3.1.17 or 3.1.18 - one being the last stable version and the other being the current beta version. Without knowing which version you are using, it is difficult to reproduce your environment.
To give you an idea of the complexity of the situation, I have over 100 large extensions, all with custom fields and front-end queries, and they all work on JCB 3.1.17 and 3.1.18. Therefore, there are three ways this could go: I may ignore the issue because I believe you are doing something incorrectly that is not related to JCB, I may ask for more details to better understand the issue, or we may identify an edge case that I have not encountered in the last five years and write a patch to resolve it.
ok, sorry for my lack of info.
In dashboard I have:
version: 3.1.18
date: 16th February, 2023
As far as I know it should be the latest.
Php: 7.4
Joomla: 3.10.11 fresh new installation
Not other components installed, just JCB.
There has been a major update on the beta branch, open this link to see the dates and updates. Also I need to see where you created the custom field and where you linked it.
Here are the list of updates: https://git.vdm.dev/joomla-beta/pkg-component-builder/commits/branch/master
When using the (nightly-build [which is version 3.1.18 at this time]) beta version you must stay at the tip of the branch as it is unstable and each update fixes what has been seen, or reported. This means you should update your version now.
So, updated JCB just now but still I get the same issue:
As you can see the join query to componentbuilder_joomla_component table (see the custom field described above) is still missing.
so, it seems once I fixed a custom field issue (see #978) I get the model compiled correctly. It seems like the compiler didn't complete the process(?) due to custom field issue.
Hello mate,
still I get the same missing join query in another view just created.
JCB version: 3.1.19
Joomla: 3.10.11
PHP: 7.4
What can I do?
and the compiled query:
Hello there, my friend. Allow me to impart some wisdom unto thee. If Llewellyn assures you that all is well, yet you persist in encountering difficulties, it is probable that you are not configuring it properly. My recommendation is to carefully scrutinize all of the tutorials before expending further time and energy on this task. In so doing, you shall save yourself a considerable amount of trouble in the long haul.
Have you indeed established a seamless connection between the field and the admin view, as I had previously suggested? Were the database values set up in strict accordance with the instructions? And have you thoroughly reviewed all of the tutorials pertaining to custom field creation? Judging from Llewellyn's recent JCB updates, it appears that he has yet to delve into these particular areas. Ergo, if you are encountering complications, it is quite likely that you have made an error.
@Llewellyn, my esteemed colleague, how may I be of assistance? I have returned and have perceived that you could benefit from a helping hand. Tell me what you require aid with?
Hello ro-ot,
Thanks for the time you took to reply.
The field was linked properly to the view but not checked to be listed in list view.
So, thanks for your hint!
you're welcome!