Company

By Danny Bols
ZNAPZ B.V.
Ceresstraat 1, 4811 CA Breda
The Netherlands
www.znapz.com

Popular posts from this blog

How labels work in Maximo 7

By
How it is stored: Maximo stores labels in multiple places. When you add a label to a field, tab or section in Application Designer, Maximo stores this in the application XML in the MAXPRESENTATION table and in the MAXLABELS table. For fields, there are also labels stored in Database Configuration, in the title field on the attribute.
Read more

Crossover Domains explained

By
Image
A crossover domain in Maximo 7 is a value list that copies not only the selected value, but also related data to the record you opened the value list from. An easy example is the Asset field on a work order. When you select an asset, Maximo also copies the priority from the asset to the Priority field on the work order. This happens because there is a crossover domain for this. Take a look at it: in the application Domains, search for ASSET2WO.
Read more

Oracle escaping special characters

By Danny Bols
In a nutshel Turn of special meaning of chars -- The ampersand has no special meaning anymore SET DEFINE OFF; SELECT 'V&D' FROM dual; Escaping characters in LIKE -- The meaning of the underscore is escaped SET ESCAPE ON; SELECT * FROM maxtable WHERE tablename LIKE 'A\\_%' ESCAPE '\\';
Read more