Confirm my attempt at converting Crystal reports selection criteria to Oracle SQL

Question

I have to create selection criteria for an Oracle SQL query based on a snippet from Crystal Reports.

I have no experience with Crystal reports so I have been trying to figure it out searching the web, but seem to be just wasting my time - Could not find anything helpful for this kind of task on the web.

This is the selection criteria that was provided:

{MATL_USED_VW.MAT_ID} = {?Material ID} and 
{@Use Date} in {?Previous Use} 
      //@UseDate = Date({MATERIAL_ACTIVITIES.MA_END})

The column data types are all date columns except for the numeric MAT_ID column

I think this would equate to the following:

where matl_used_vw.mat_id = :Material_id
  and use_date in (:previous_use, :usedate)

This is just a swag based on assumptions.

Here's my assumptions on the symbols:

? - probably is a parameter or prompt for input

@ - has something to do with formulas

// - is continuation of previous line

{} - encloses an object (text, date number or whatever)

I'm not sure of anything here, it's all just a guess.

If anyone could shed some light on this, I would really appreciate it!

Answer 1

Thanks for the help on this!

Here's the answer in case some other schmuck unfamiliar with Crystal reports needs a similar answer:

@ is a Formula. In this case, to convert text to date.

? is a Parameter In this case it represents a range

// is a remark. Same as # or ‘ in other languages.

{} - encloses an object (text, date number or whatever)