Skip to main content

General discussion

IDEA Lab

You may have noticed that there is a new tab on the site to access something called the IDEA lab.  This is something I have been working with CaseWare IDEA on and will hopefully open up in full in the near future.  It will allow all users to upload and share their scripts in which other users can then comment, make suggestions and rate them.  If anyone has any suggestions on what they would like please comment or send me a message.

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