Yeah, you'll find {jrCore_list} is the go-to tool for getting anything out of a datastore.
Jamroom has 2 types of storage tables inside the mysql database, a regular one, where you write normal SQL queries to access, and a special one called a 'datastore'
A datastore is a key => value storage system that each module can have up to 1 of.
The advantage of using a datastore in module development is that it allows for easy addition of database column types.
In a conventional mysql table, if the colums are
id | name | title
In order to add another column 'age' you need to alter the database structure
id | name | title | age
But with a datastore it just has
_item_id | key | value
So this allows other modules to add things to each others datastores without the need for alteration of the database.
An example of this is the Tags module, it adds things to any other modules datastore, without that module needing to know or care whether the Tags module exists or not.
An blog entry might look like this
_item_id | key | value
1 | blog_title | a blog for saturday
1 | blog_text | bla bla bla bla bla bla bla .......
1| blog_date | (time the blog was created)
Then the tags module can come along and add tags to that blog
1| blog_tags | ,saturday,racing,sunny,events,
This allows for complete separation of modules, but also integration of modules.
Then you can use the {jrCore_list} template function along with a search="" clause to retrieve whatever you want from a datastore
{jrCore_list module="jrBlog" search="blog_tags like %sunny%"}
This way you can get the only the blogs back that have the 'sunny' tag on them.
--edit--
The Tags module was an example of a module adding to another modules datastore, but you dont have to do it via a module.
If you want to add extra tags to a modules datastore just for your system, you can use the Form Designer.
Docs: "Using the Form Designer"
https://www.jamroom.net/the-jamroom-network/documentation/jamroom-admin-handbook/1275/using-the-form-designer
To add any extra fields you require.
updated by @michael: 02/26/17 01:59:41PM
JAMROOM
