Forum
10:29
11/04/2013
Sorry if this is a FAQ, I'm new to jqgrid and this is my first day with it, so please be kind with me... 😉
I want to view tags in a cell of jqgrid; how should I do it?
When I write "tags", it means a set of boolean attributes.
There are two types of tagging: free-style (where the user may add any tag he thinks about), and limited.
The first type is easier to implement, and less popular, so my question is about the second.
A good example can be "contact list":
For each contact, possible tags are (for example) Neighbours, Family, Customers, Suppliers, Employees.
For each contact, you may turn on one of them, two, all, or even none of them (depending on the person and his connection to you).
The turned-on tags of each record should be displayed as a list, with only a delimiter between each other (usually "|"), and with an "X" in the up corner of each tag (to turn it off). You can turn on more tags, and it is usually done by popping-up a lookup-table with the tags that are not yet turned on.
Creation of new tags: In some implementations, everybody can do it, and in other implementations - it's limited to privileged users. Sometimes it's done from the above lookup-table, and sometimes it's done from a separate screen.
The server side implementation (in DB) is usually with "join table"; for example, in the above example of contacts, you have one table of contacts where each contact has a unique "contact-ID", a second table of tags (where the tag name is unique), and a third table with two fields - one for the above "contact-ID" and the other for a tag name; to know if a specific tag should be displayed for a specific contact, we check if the third table contains a pair with the contant ID of this contact and the specific tag.
Theoretically, tags can be displayed in jqgrid (or any other table) also as separate boolean columns, where there is a column for any tag (even if it is turned off); But it's not practical, either because there are many tags, and/or because the list of them is dynamic, and/or the ratio between the number of the total tags and the number of the turned-on tags is high.
I'm not afraid to build everything from scratch, but before doing it - I want to check if there is any existing feature for it or anything else which may help me.
Before ending my message, I want to use this opportunity to thank the developers of this amazing software!
Thanks in advance for anybody who responds!
Eli
Most Users Ever Online: 715
Currently Online:
30 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66