×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Component item ID in SQL field
Sean Dooley
New Member
Posts: 2
8 năm 2 tuần trước #1423
bởi Sean Dooley
Component item ID in SQL field was created by 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.
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.
Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.
Nicky Gernhardt
New Member
Posts: 1
6 năm 8 tháng trước #1724
bởi Nicky Gernhardt
Replied by Nicky Gernhardt on topic Component item ID in SQL field
Does anybody have an idea for that? Seems to be a nice feature I would also look for.
Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.
Fran
New Member
Posts: 5
6 năm 7 tháng trước #1733
bởi Fran
Replied by Fran on topic 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.
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.
Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.
Thời gian tải trang: 0.097 giây