OOQL language unitmeasure


unit measure for field values


define - create new unitmeasure definition

  unitmeasure define  AdminName   type   UnitMeasure_Type {UnitMeasure_DefineOption} [force];

clone - duplicate a unitmeasure and set the properties for the new instance

  unitmeasure clone  AdminName define AdminName {UnitMeasure_EditOption} [force];

edit - update the unitmeasure properties

  unitmeasure edit   AdminName {UnitMeasure_EditOption} [force];

show - print the unitmeasure properties

  unitmeasure show   AdminName [UnitMeasure_GetOption] [Token_Option] [ExportFile_Option] ;

select - extract unitmeasures on the base of query filters

  unitmeasure select AdminPatternList {Filter_Option} [UnitMeasure_GetOption]
                                     [Token_Option] [ExportFile_Option] ;

undefine - remove a unitmeasure from the database [all related files will be deleted]

  unitmeasure undefine AdminName ;


UnitMeasure_DefineOption
description GenericValue
application AdminName
image  FileName
imagedata GenericString
convfactor GenericNumber
convadd GenericNumber
symbol GenericString
format GenericString
[! /not] hidden

UnitMeasure_EditOption
name AdminName
type UnitMeasure_Type
description GenericValue
application AdminName
svnrev NUMBER
image  FileName
imagedata GenericString
convfactor GenericNumber
convadd GenericNumber
symbol GenericString
format GenericString
[! /not] hidden

UnitMeasure_Type
-
length
area
volume
fluid_volume
plane_angle
solid_angle
mass
density
time
frequency
speed
flow
acceleration
force
pressure
torque
energy
power
dyn_viscosity
kin_viscosity
el_current
el_charge
el_dipole
el_potential_diff
el_resistance
el_capacitance
mag_flux
mag_flux_density
el_inductance
temperature
info_entropy
info_quantity
lum_intensity
luminance
lum_flux
illuminance
rad_source_act
rad_exposure
rad_absorbed_dose
rad_eq_dose
date_format
datetime_format
currency


UnitMeasure_GetOption
get [UnitMeasure_GetBasicOption]
   
  UnitMeasure_GetBasicOption
  { UnitMeasure_GetBasicToken [as IDENTIFIER] { UnitMeasure_GetBasicToken [as IDENTIFIER] } }
  UnitMeasure_GetBasicToken [as IDENTIFIER]
     
    UnitMeasure_GetBasicToken
    Common_GetBasicOption  
    type  
    convfactor  
    convadd  
    symbol  
    format  
    metricsystem [. MetricSystem_GetBasicOption]
    metricsystem[] [. MetricSystem_GetBasicOption]
    metricsystem[ AdminName ]  
    field [. Field_GetBasicOption]
    field[] [. Field_GetBasicOption]
    field[ AdminName ]  


KEYWORDs
application the associated application menu
convfadd coversion addendum respect to the SI unit
convfactor coversion factor respect to the SI unit
description the unitmeasure description
field list of fields which support this unitmeasure as alternative
force this flag allows to ignore errors during the creation/update
format the date format for type=date_format
hidden administration hidden objects are not visible/usable
image local path for the unitmeasure icon to upload
imagedata base64 code for the unitmeasure icon
metricsystem list of metric systems which include this unitmeasure
moddate last modification date
name the unitmeasure name
svnrev SVN repository revision number
symbol the unit measure symbol
type the unit measure family type


SAMPLES

unitmeasure define "square inch" type area description "1 in 1 in = 1/144 sq ft" !hidden symbol "sq in" convfactor 6.4516E-4 ;

unitmeasure edit 'square inch' symbol 'in2' convfactor 0.000645112;

unitmeasure show 'square inch' get { name convfactor type } token { "|" };

unitmeasure show 'square inch';

unitmeasure show 'square inch' get { name symbol field[].{ name range } } token { "|" "," ";" } ;

unitmeasure select * get { name description symbol convfactor metricsystem } token "xml" ;



common syntax

Common_GetBasicOption
Common_GetBasicToken [ as IDENTIFIER ]

Common_GetBasicToken
id  
name  
origdate  
moddate  
moduser  
description  
svnrev  
hidden  
image  
imagedata  
feature[ AdminName ] [. Feature_GetBasicOption]
feature[] [. Feature_GetBasicOption]
feature [. Feature_GetBasicOption]
application [. Menu_GetBasicOption]
super  
admintype  

Edit_Operator
add
remove

Edit_RefOperator
addbefore AdminName set
addafter AdminName set
add
remove
movebefore
moveafter

Edit_AddOperator
addbefore AdminName define
addafter AdminName define
append

Edit_MoveOperator
movebefore
moveafter

Event_Type
action
check

AdminPatternList
AdminNamePattern {, AdminNamePattern}

AdminNamePattern
*
PATTERNIDENTIFIER
STRINGVAL
AdminName

GenericPatternList
GenericPattern {, GenericPattern}

GenericPattern
*
IDENTIFIER
PATTERNIDENTIFIER
GenericValue

AdminActor
user AdminName
team AdminName
assignment AdminName

AdminName
IDENTIFIER
QUOTED_STRING
SQUOTED_STRING

GenericValue
DATETIME
GenericNumber
GenericString
BOOLEANVAL

GenericString
STRINGVAL
QUOTED_STRING
SQUOTED_STRING

GenericNumber
NUMBER
REALNUMBER

Filter_Option
moddate Date_Range
application AdminNamePattern

Date_Range
=  DATETIME  
!= DATETIME
 
<  DATETIME
 
>  DATETIME
 
<= DATETIME
 
>= DATETIME
 
in [ DATETIME , DATETIME ]
 
in ( DATETIME , DATETIME ]
 
in [ DATETIME , DATETIME )
 
in ( DATETIME , DATETIME )  

Token_Option
token { Token_Separator { Token_Separator } }
token Token_Separator

Token_Separator
QUOTED_STRING
SQUOTED_STRING
IDENTIFIER
STRINGVAL
json
json-
json+
xml
xml-
xml+

ExportFile_Option
exportfile FileName [append] [xml | json ]

ImportFile_Option
importfile FileName [xml | json |emxxml]

LogFile_Option
logfile FileName [append]

FileName
QUOTED_STRING
SQUOTED_STRING

basic elements
grammar rules
[ ] = optional element - only one item is allowed : ( 0 or 1 )
{ } = optional element - more than one is allowed : ( 0 or N )
/ = alternative
= one of ...
   
  all bold texts represent keywords or command syntax

IDVAL
#<5 dec digits [ 0-9 ]>-<8 hex digits [ 0-9 A-F ]>
  example:
  #00020-34F2A80E

COMMENT
// <any character until the end of the line(\n \r)>
  example:
  // My single line comment

LONGCOMMENT
/* <any character> */
 

example:
  /* My multi line comment starts here
  continue here
  and finish here */


DATETIME
<year 4 digits>[ - /. ]<month 2 digits>[ - /. ]<day 2 digits>
  examples:
   2009-12-23    2009/03/19   2009.11.14
<year 4 digits>[ - /. ]<month 2 digits>[ - /. ]<day 2 digits> <hours>:<minutes>:[<seconds>]
  examples:
   2009-12-23 10:23   2009/03/19 16:03:34  2009.11.14 00:20:04

NUMBER
[+-]<decimal digits [ 0-9 ]>
  examples:
   -1203   +276   25

BOOLEANVAL
true / false

REALNUMBER
[+-]<decimal digits [ 0-9 ]>.<decimal digits [ 0-9 ]>[E(+-)<esponent [0-9]>]
  example:
   -37.837   +2.3874   13.887   1.4862E-04

QUOTED_STRING
"<any character>"
  example:
   "my quoted string"

SQUOTED_STRING
'<any character>'
  example:
   'my single quoted string'

IDENTIFIER
<one or more of [ a-z A-Z ]><zero or more of [ a-z A-Z 0-9 _ ]>
  example:
   Var1    object_Name_02

VARIABLE
$<one o more of [ a-z A-Z 0-9 ]><zero or more of [ a-z A-Z 0-9 _ ]>
 

example:
   $1   $var_02    $1b


STRINGVAL
<one or more of [ a-z A-Z 0-9 -_ $ ? @ | ~ % & / = : + \ # ' ]>
  a string not recognized as identifier

PATTERNIDENTIFIER
<a string with * (match 0 or more characters) and ? (match 1 character) wildcards>
  example:
   mypa*er?_ide?ti*

© 2008-2015 MS Enterprise Solutions | Website Templates by IceTemplates.com
Please Read: Privacy Policy and Terms of Use