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

Component item ID in SQL field

8 yıl 2 ay önce #1423 Yazan: Sean Dooley
Component item ID in SQL field, Sean Dooley tarafından oluşturuldu
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.

Lütfen sohbete katılmak için Giriş ya da Hesap açın.

6 yıl 10 ay önce #1724 Yazan: Nicky Gernhardt
Nicky Gernhardt tarafından Component item ID in SQL field konusunda yanıtlandı
Does anybody have an idea for that? Seems to be a nice feature I would also look for.

Lütfen sohbete katılmak için Giriş ya da Hesap açın.

6 yıl 9 ay önce #1733 Yazan: Fran
Fran tarafından Component item ID in SQL field konusunda yanıtlandı
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.

Lütfen sohbete katılmak için Giriş ya da Hesap açın.

Sayfa oluşturma süresi: 0.052 saniye
Geliştiren: Kunena Forum