Desktop productivity for business analysts and programmers

Implementation of Date Range Prompt in Query Builder

Reply
Contributor
Posts: 62

Implementation of Date Range Prompt in Query Builder

Can someone adivse how to implement a date range prompt via a filter in the query builder interface in EG 4.3? I understand how to use prompts in open code but it is not clear how the date range prompt macro variables of _MIN and _MAX should be setup via the filter setup screen. Any help would be greatly appreciated.

jdm
Contributor
Posts: 29

Re: Implementation of Date Range Prompt in Query Builder

I'm trying to do this as well.  QB adds a where clause like this:

 

WHERE %_eg_WhereParam( t1.CLCL_PAID_DT, Paid_Dates, EQ, TYPE=D, IS_EXPLICIT=0 );

 

but I haven't gotten it to work and it doesn't show Paid_Date_Min or _Max as available prompts.

 

I might have to get rid of the date range macro variable or add a redundant begin_paid_dt and end_paid_dt.

 

 

Contributor
Posts: 29

Re: Implementation of Date Range Prompt in Query Builder

I solved it!

 

use a 'between range' and you can use a date range macro variable.

 

it'll generate this filter:  WHERE %_eg_WhereParam( t1.CLCL_PAID_DT, Paid_Dates, BETWEEN, TYPE=D, IS_EXPLICIT=0 );

 

here's a video to explain it.  https://www.youtube.com/watch?v=zgk3lJzcIPo

Ask a Question
Discussion stats
  • 2 replies
  • 295 views
  • 0 likes
  • 2 in conversation