Search for projects (DTREE type 202) with categories containing unique attribute values.

We need a LiveReport that replicates what the Advanced Search can do when searching for values contained in one or more category attributes. Specifically we have projects with attached categories containing an attribute that has specific project ID values. We want to find there projects base on these unique IDs and return the project node ID. Only projects (type 202) have this specific attached category. See the attached.

Can anyone help with this?

Thanks in advance.

Sample ATEC Project Category.JPG

Find more posts tagged with

Comments

Nick Goddard

Hi Loren

Check out the following page in your environment ?func=attributes.dump

This provides info on Categories and is a good place to understand the data in the LLAttrData table

I don't know if you use SQL or Oracle backend.

I only do SQL so your query would look something like:

SELECT DataID
FROM DTree
inner join LLAttrData on DTree.DataID = LLAttrData.ID
Where Dtree.SubType = 202
and LLAttrData.DefID =

Where you populate the LLAttrData.DefID with the info from ?func=attributes.dump

You may also need to include other stuff (possibly LLAttrData.DefVerN) that would depend on your environment.

Hope this helps.

Best regards

Nick