New Feature - Tree View Query
Now you can add a query to your tree view and return a result for each node. This post explains how.
Posted By
I was recently building an application to help me with a home remodeling project. I built one table, a todo list, with a tree view that had a Materials table related to it. The materials were items that I'd need to complete the task, such as paint, plywood, sand paper, etc.
So in my treeview, I had a list of tasks like this:
I wanted to see how much each level of the tree was going to cost to complete so I could make better decisions about where to start on my home remodelling project and where I would get the best bang for my buck. Each Qrimp app comes with a gettree operation which will return a table with a nicely organized structure showing how items relate to each other in a hierarchical manner, so I adapted it to calculate the sum of the estimated cost for the materials. I then added a share data to my detail view for a particular todo list item.
Then I realized that this information would be good on the tree view as well, so I added a feature to Qrimp that would allow me to run a query for each node, passing in the ID of the item to that query.
To access this feature, add &qid=QUERYNAME to your URL.
Here's what my tree view looks like now:
| 
| 
| 
| 
| 
Subscribe