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?
Work with a subset of data in a table
- Single Page
Posted 10 May 2018 - 16:19 PM
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.