Hello Humberto, this should be:
select * from workflowitem where item_id='274a5c7c-8e5d-4ee2-8ca5-eae66cb6e6a3'; The item_id is an uuid not a string. You may cast it to varchar and use like. Hope this helps Claudia Jürgen Am 06.04.2017 um 14:40 schrieb Humberto Blanco Castillo:
hi, when i try to get workflow id from database with teh following sentence select * from workflowitem where item_id like '274a5c7c-8e5d-4ee2-8ca5-eae66cb6e6a3' get the following error '' Failed to execute SQL : SQL select * from workflowitem where item_id like '274a5c7c-8e5d-4ee2-8ca5-eae66cb6e6a3' failed : ERROR: operator does not exist: uuid ~~ unknown LINE 1: select * from workflowitem where item_id like '274a5c7c-8e5d... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. What is the correct casting to do the sentence. Really appreciate your help!
-- Claudia Juergen Eldorado Technische Universität Dortmund Universitätsbibliothek Vogelpothsweg 76 44227 Dortmund Tel.: +49 231-755 40 43 Fax: +49 231-755 40 32 [email protected] www.ub.tu-dortmund.de Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und vernichten Sie diese Mail. Vielen Dank. Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen Schriftstücks per Telefax erfolgen. Important note: The information included in this e-mail is confidential. It is solely intended for the recipient. If you are not the intended recipient of this e-mail please contact the sender and delete this message. Thank you. Without prejudice of e-mail correspondence, our statements are only legally binding when they are made in the conventional written form (with personal signature) or when such documents are sent by fax. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
