2 table query and results

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
going4code
Posts: 6
Joined: 2014-03-30 20:42

2 table query and results

Post by going4code » 2014-04-10 12:09

Is there a hook option that would get information from table_1 and would filter the other table_2 view acordingly.
Can I make this happen without altering table_view.php core?

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: 2 table query and results

Post by a.gneady » 2014-04-14 06:04

Hmm ... if table_2 has a lookup field whose parent is table_1, you can enable displaying children from table_2 under the detail view of table_1 ... This way, if you select a record from table_1, you can see its children from table_2. Please see this screencast: https://vimeo.com/81759390 (you could skip to minute 1:20 and watch from there)
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply