Classifications in a query

Hello,

I have made a query to make a list of all terms (table wmjellywebterm). Now a want to get the classification of a term.
Where can I find the classifications in the database?

Hi,

maybe something like this (in WM9) is useful to you:

select top 10 t.value as term, g.grouping as classification
from wmJellyWebTerm t
left join wmJellyWebTermGrouping tg on tg.webterm = t.id
left join wmJellyTermGrouping g on g.id = tg.grouping

Hi John,

Thanks, that's what I need.

Just wondering, but you do know you can use the api to do this? Otherwise your code may be broken if the data-model changes.

Uhm... John..

This is what we formally named a Closed Core Violation...or...

Though shall not query directly from internal GX Webmanager tables if there's an api that can give you the same result. And if no API, Any GX project has to have special approval before you can go down this path... Let's for instance assume you'd save an id from wmJellyContent in pre GX Webmanager 9.9. There comes versions in the Media Repository (GX Webmanager 9.9) and stuff probably won't work anymore...

So please... don't..;)

You can bet your WCB won't get certified bij GX if you do (see the WCB Guidelines why)

Regards,

Michel

He's not telling us he want's to use it in a JSP. Maybe he just want an overview (for now)...

[quote=johnd]He's not telling us he want's to use it in a JSP. Maybe he just want an overview (for now)...

It's a common rule that quick fixes and dirty hacks somehow always make it to production code, to break the application at the least suitable time, ;).