• Miscellaneous Functions
  • ASSIGNEDTO Function
  • B64TOGUID Function
  • BROWSTAT Function
  • CANSIGN Function
  • CELLCALC Function
  • CELLCOL Function
  • CELLLABEL Function
  • CELLNO Function
  • CELLROW Function
  • CELLSTR Function
  • CELLTABLE Function
  • COMPLETION Function
  • COMPLTBY Function
  • CUSTPROP Function
  • CUSTPROPAT Function
  • CUSTPROPR Function
  • CVDATA Function
  • CVDATAC Function
  • CVDATAL Function
  • CVDATALNG Function
  • CVDATAQRY Function
  • CVDOCPOS Function
  • CVFORM Function
  • CVGROUP Function
  • CVIDEA Function
  • CVINFO Function
  • CVMENUST Function
  • DOCENTSCP Function
  • DOCID Function
  • DOCLIBPATH Function
  • DOCMODE Function
  • EVAL Function
  • FIELD Function
  • GETHIDE Function
  • GUIDTOB64 Function
  • HASTAG Function
  • INITIALS Function
  • INPBLANK Function
  • INPBLANKRC Function
  • ISADMIN Function
  • ISCONS Function
  • ISINGROUP Function
  • ISLOCKED Function
  • ISPLHOLDER Function
  • ISSUECOUNT Function
  • ITEMPROP Function
  • KLIEXIST Function
  • KLIPROP Function
  • KLLPROP Function
  • LEVEL Function
  • LOOKUP Function
  • Miscellaneous Functions
  • MKPATH Function
  • NUMROLES Function
  • NUMSIGNED Function
  • RDYREVIEW Function
  • REPENT Function
  • ROLECOMPLT Function
  • ROLEINDEX Function
  • ROLELABEL Function
  • SCRNX Function
  • SCRNY Function
  • SIGNOFF Function
  • SIGNOFFCHK Function
  • SIGNOFFCVR Function
  • SIGNOFFDTE Function
  • SIGNOFFNME Function
  • WHOAMI Function

CVDATAQRY Function

Performs multiple queries until it returns a non null string data associated with the provided "Group", "Form1", "ID" .. "Group", "FormN", "ID" from a specified system database.

Syntax

CVDATAQRY("SystemID","Group","Form1",…, "FormN","ID")

Parameters

SystemID - The label applied to the system database specified in the document settings.

Group - The group of the data. This can be set to a null string.

Form1 .. FormN - The form of the data. This can be set to a null string.

ID - The identifier of the data. This can be set to a null string.

Note: The function can only take a maximum of 20 forms. The 21st form onwards will be ignored.

Example

CVDATAQRY ( "STRINGS","CNDPROV","FR-CA","FR-FR", "FR","ONTARIO")

Will make multiple retrieves of the data associated with "CNDPROV","FR-CA","ONTARIO" "CNDPROV","FR-FR","ONTARIO" and "CNDPROV","FR","ONTARIO" from "STRINGS" system database until it returns a non null string data.

Related Topics

• Miscellaneous Functions