× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Component item ID in SQL field

pred 8 rokmi 1 mesiacom #1423 od Sean Dooley
Component item ID in SQL field bolo vytvorené Sean Dooley
Is it possible in an SQL field to include the current component item ID in the SQL query? For example, I would like to display a list of Employees assigned to a Business

SELECT * FROM _cc_employees e
WHERE e.business_id = [current business id]

[current business id] would be replace with the ID of the current item.

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 6 rokmi 9 mesiacmi #1724 od Nicky Gernhardt
Odpoveď od Nicky Gernhardt na tému Component item ID in SQL field
Does anybody have an idea for that? Seems to be a nice feature I would also look for.

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

pred 6 rokmi 8 mesiacmi #1733 od Fran
Odpoveď od Fran na tému Component item ID in SQL field
Hello Sean,

It is not currently possible to do this in Component Creator. You could easily do it by modifying the code generated for your component.

Thank you for pointing this out, we are going to investigate whether it's a possible future as it sounds like a good improvement to Component Creator.

Regards.

Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.

Čas vytvorenia stránky: 0.051 sekúnd
Funguje na Kunena fórum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.