but it is not showing what all asset types a tag is assigned against, isn’t it? Only when you click on the tag from the ‘Tags’ page, you see in the search results page, on the left hand side navigator, the asset type.

OMRE doesn’t extract assets as assets since it would be simply duplication of the data. Regarding the request about tags, I’m not 100% sure I understand the purpose of the modification. Are you looking for the way how to show all the assets which have been tagged with some specific tag? In this case there are few options - search filters and global views. Or there is a necessity to add something on top? Could you please guys elaborate a bit on this? How the request from the end-user will look like?

That’s fair, I think the platform would benefit greatly from an uplift in the current way of managing tags. Sounds like the OMRE isn’t the answer to that need.

Few things I’d love to be see:

• Tag count by Asset Types
• Tag Count by Community
• What Tags have been merged from other Tags?
• Who is creating New Tags?
• Who is adding existing Tags? (Different to Created By and Last Modified By)
• Last date at which an instance of a Tag was added (different to last modified)

Dmytro,
I am trying to see which tags are being used often and which are not being used often. Those that are not being used often will be combined/eliminated. The creation of tags is controlled by the DGC to minimize duplicates and semi-duplicates (ie car v cars). The use of the the new Asset Type eliminates Collibra’s inability to accept blank spaces in tags and the lack of migration.

To get a result like (pivot table)

You can do the following:

Use the search API

1. get all the tags from the /tags endpoint
2. iterate over all the tags and query the search API. The search API being very efficient, you could send 100,000 requests per hour I guess (one request per tag)

In this example, I’m asking the search API: “How many assets per asset type for the tag some.tag?” It limits to 0 results (I don’t care for the raw results) and the top 1000 asset types (I hope you have less asset types than that.)

data = {
  "keywords": "*",
  "filters": [{"field": "tags","values": ["some.tag"]}],
  "aggregations": [{"field": "assetType","limit": 1000}],
  "limit": 0
}
r = c.post('search', json=data)

{'total': 164,
 'results': [],
 'aggregations': [{'field': 'assetType',
   'values': [{'id': '00000000-0000-0000-0000-000000031302', 'count': 164}]}]}

Use a workflow

Restore a database backup

select t."name", at2."name", count(*)
from terms_tags tt 
join tags t on tt.tag_id = t.id
join representations r ON tt.term_id = r.id
join asset_types at2 on r.asset_type = at2.id
group by t."name", at2."name"