Hi, I would like to know the link between a converted idea and the project or investment it is converted to. Is there any query or related gel script that someone can share? The database tables and column names will also help.
Here is an example query which will return the linked investments created from the idea.
Very straightforward, I've ruined the fun and learning though by sharing
--idea static data
--investment static data
(SELECT u.last_name||', '||u.first_name FROM cmn_sec_users u WHERE inv.created_by = u.id) investment_created_by,
to_char(inv.created_date, 'dd/mm/yyyy') investment_created_date
FROM inv_investments inv
INNER JOIN inv_investments idea ON idea.id = inv.idea_id
inv.idea_id = YOUR_IDEA_ID
Thanks for ruining the fun.
I will check this and update the thread.
Hi Uruj - Did am1's response help answer your question? If so please mark as Correct Answer. Thanks!
Retrieving data ...