Skip to main content

General discussion

Caseware's Auditor Spotlight

Hey Brian!
 
I was browsing through Caseware's website looking for the link on the "What's New" on the latest version of IDEA for a coworker and found your AUDITOR SPOTLIGHT article.
 
I want to congratulate you on earning that place. AWESOME!!!
https://www.casewareanalytics.com/blog/auditor-spotlight-brian-element
 
Keep up the good work!  Bless you!
Cisco

Search function

I am currently writing a script that i would like to search the entire database for terms. I utilized the history of a current project  but the code manually adds each field. is there a shortcut to add all fields from the database?
 
task.AddFieldToInc "ACCOUNT_NUMBER"
task.AddFieldToInc "DESCRIPTION"task.AddFieldToInc "DATE"
task.AddFieldToInc "NAME"

Help with Formula

I need some assistaance with creating a script. Im trying to take the formula  below and replace it with variables based off an input box. i can get the code to run seperately but when i add the "or" it throws it off. Any help would be appreciated.
task.AddExtraction dbName, "", " CREDIT  >=  ( 1000000 )  .OR.  DEBIT  >=  ( 1000000)"
i have the following but am getting errors
task.AddExtraction dbName, "",   debit & " >= " & amount &  .or.    credit & " >= " & amount