⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Work with a subset of data in a table



echavez123

echavez123
  • profile picture
  • Member

Posted 10 May 2018 - 16:19 PM

I have a membership table which contains data for various organizations.  I would like to set a table, apply a where clause for a specific organization.  Then, all of the crud functions should apply to the data for the organization.  The work around would be to create a separate table for each organization, but only if necessary.  Ideally, when I use the "set_table" function, a where clause could be applied.  Is there another way to do this?  Maybe on the render() function?


echavez123

echavez123
  • profile picture
  • Member

Posted 20 May 2018 - 02:22 AM

I figured it out.  The where clause can be called before the set_table is called.  Simple, but if you dont know it takes time to figure it out on your own.