DQL versus Advanced Search incompatibility

athati

Hi,

My DQL below does not give any results:

select object_name, russell_order_nbr, ack_nbr, r_creation_date from ecm_bill_of_lading where document_type like 'Spald VICS BOL-Supplement Carrier Info%' and r_creation_date > date('01/01/2010', 'mm/dd/yyyy') ORDER BY r_creation_date DESC

 

When I searched in Advanced Search I get Results (44 rows). Please see the attachment. I also tried the DQL with -

document_type like '%Spald VICS BOL-Supplement Carrier Info%'. Still I get zero results. Any clue?



Please share your knowledge and experiences for figuring this out.

Thanks.

ta

Spald_VICS.docx

KSMatson

As you know that the Documentum works with case sensitive DB so your predicate where you speicfy the document_type value needs to be adjusted to reflect the exact case, so modify your query as follows, note "Vics" in the query

select object_name, russell_order_nbr, ack_nbr, r_creation_date

from ecm_bill_of_lading

where document_type like 'Spald Vics BOL-Supplement Carrier Info%'

and r_creation_date > date('01/01/2010', 'mm/dd/yyyy')

ORDER BY r_creation_date DESC