Sorry, I was away all week. Your function seems to work. However, I get an empty list for results—perhaps the record isn’t in my repository.
Here’s what I tried:
1. Add Tom’s new function in method, SQLServerPlatform>>initializeFunctions.
2. Connect to the SQL 2012 repository (which sends SQLServerPlatform new initializeFunctions).
3. Inspect the workspace code
Here is the query it generates.
SELECT TOP 1 t1.identityName
FROM NEWBERN2.BERN.TW_DatabaseIdentifier t1 OrderedCollection ()
SELECT t1.primaryKey, t1.name, t1.timeStamp, t1.version, t1.userName, t1.trace, t1.blessingLevel, t1.commentID, t1.propertiesID, t1.binFile, t1.parcelID
FROM NEWBERN2.BERN.TW_Package t1
WHERE (RIGHT(t1.version,5) = :1) OrderedCollection ('57540')
--- CONFIDENTIALITY STATEMENT ---
This e-mail transmission contains information that is intended to be privileged and confidential. It is intended only for the addressee named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited, please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.
You received this message because you are subscribed to the Google Groups "glorp-group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to glorp-group...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/glorp-group/94bb95cc-e5c5-4ddd-8751-8dac41d75595%40googlegroups.com.