• 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

CVIDEA Function

The CVIDEA function returns table information from a Caseware IDEA .imd file. The first parameter is required and determines the function and the number of extra parameters.

Syntax

• CVIDEA(0, Source, Flag, *Criteria, *Column heading or number, *Row number)
• CVIDEA(1, Source, Flag, *Criteria)
• CVIDEA(2, Source, Flag)
• CVIDEA(3, Source, Flag, *Column heading or number)

The first parameter (0, 1, 2, 3) represents the Command. Some parameters in the formula (marked with *) are only applicable depending on the Command that is specified. Criteria represents any valid criteria as defined in Caseware IDEA. For more information, see IDEA Support.

Parameters

Command:

• 0 or "field"
• 1 or "rows"
• 2 or "columns"
• 3 or "heading"

Source: The IDEA file or Document Number. The full path or relative path to the IDEA file, or the document number if the file is in the Document Manager. How this is interpreted depends on the Flag.

Flag:

• 0 - The Source is a path to an IDEA file.
• 1 - The Source is the document number of the IDEA file in the Document Manager.

Example	Description
CVIDEA(0, "C:\IDEA.imd", 0, 'BRANCH="A"', "NAME", 1)	Returns the value of the "NAME" column of the first filtered row. The filtered rows satisfy the criteria BRANCH="A".
CVIDEA("rows", "C:\\IDEA.imd", 0, "BRANCH="A")	Returns the number of rows in the table that match the criteria BRANCH="A".
CVIDEA("COLUMNS", "ID", 1)	Returns the number of columns in the table from the .imd file with document number "ID" in the Document Manager.
CVIDEA("Heading", "XL", 1, 3)	Returns the heading name of the third column of document "XL".

Related Topics

• Miscellaneous Functions