Queues Management with DQL

1. FullText Queue

Objects in FullTextIndex queue (requsts for fulltext indexing):

select name,task_state,count(r_object_id),min(date_sent) from dmi_queue_item where name like '%index%' and dequeued_date is nulldate group by name,task_state order by name,task_state

Object types registered for indexing:

select name from dm_type where r_object_id in (select distinct registered_id from dmi_registry where user_name like '%fulltext%')

Resubmit items to FullTextIndex queue:

update dmi_queue_item objects set task_state=' ', set sign_off_user=' ', set message=' ', set dequeued_by=' ', set date_sent=DATE(NOW) where name like 'dm_fulltext_index_user%' and task_state='failed'

Remove items with warnings from FTI queue:

delete dmi_queue_item objects where name like 'dm_fulltext_index_user%' and task_state='warning'

2. Renditions (Content Transformation) queue

Objects in CTS queue (requests for rendition creation):

select * from dmi_queue_item where event='rendition'

Documents which don’t have a rendition:

select * from dm_document where r_object_id not in (select parent_id from dmr_content where rendition>0)

Renditions generated today:

select * from dmr_content where rendition>0 and set_time > DATE(TODAY)