querying a Table in WCC through idoc script

Hi,

i need some help with finding an example of idoc script in WCC which return data from a database table based on certain filter

We have a requirement to store a large number of category ids in a lookup Table in WCC. we are aiming to write an idoc script in WCC rules to retrieve the desired value from this table as:

select category id from lookup table

where document type = ?

and document class =?

is it possible to achieve the above logic in idoc -

i have seen few examples such as:

<$getViewValuesResultSet("doctagsView", "", "")$>

           <$loop SchemaData$>

                <$fieldValueName = getValue("SchemaData", "dDocName")$>