Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
What cell/s should be used for tags? ("tags" in the meaning of sets, not HTML/XML tags)
11/04/2013
10:29
Avatar
Eli
New Member
Members
Forum Posts: 1
Member Since:
11/04/2013
sp_UserOfflineSmall Offline

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

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information