2. PHPRunner General questions
  3. DYNAMIC SEARCH
This topic is locked

DYNAMIC SEARCH

 		6/16/2010 2:30:56 PM
PHPRunner General questions
J
 JColtro author

I have a large Oracle table containing records with year, month, day, hour, minute and second each one. I need create one page to my client to show how many records (just the qtty) was between two criteria fields: inicial date_time and final date_time. My client don´t want see the records (that´s easy using advanced search options) but just the total qtty of records of the query. How can I do this?
Tks in advance.
A
 		ann 6/18/2010

Hi,
you can do it in on the Visual Editor tab. Move details_block to the grid_block and delete other content of the grid_block.
J
 		JColtro author 6/18/2010

Hi, Ann. Thanks for your reply. Sorry, but I don't know where can I find 'details_block' or 'grid_block'. Are you talking about reports or list page? Let me explain in details the table content:
MODEL_A STEP_A YYYYMMDDHHMISS

MODEL_A STEP_B YYYYMMDDHHMISS

MODEL_B STEP_A YYYYMMDDHHMISS

MODEL_B STEP_B YYYYMMDDHHMISS

MODEL_A STEP_A YYYYMMDDHHMISS

MODEL_A STEP_B YYYYMMDDHHMISS

MODEL_n STEP_n YYYYMMDDHHMISS
I need filter by:

a ) How many records has MODEL_A between ini_time and end_time?

MODEL_A STEP_A 15

MODEL_A STEP_B 10

MODEL_A STEP_n 12
b ) How many records has STEP_A between ini_time and end_time?

MODEL_A STEP_A 5

MODEL_B STEP_A 8

MODEL_n STEP_A 10
c ) How many records has MODEL_A OR MODEL_B OR... between ini_time and end_time?

d ) How many records has STEP_A OR STEP_B OR... between ini_time and end_time?
If possible, can you explain your answer in details, please?
Thanks in advance.
A
 		ann 6/18/2010

Hi,
use Advanced search page to obtain number of records for STEP_A (or MODEL_A) between ini_time and end_time.

This number is shown usually in the upper right corner (right above the grid) on the list page. To show it inside the grid proceed to the HTML mode the Visual Editor tab and move details_block inside the grid_block. Then delete other content of the grid_block.
J
 		JColtro author 6/18/2010

Hi, Ann.
Sorry again, but is most complicated. I need show a couple ou calculeted fields and not just the count of records. See below, please:
User filter:

MODEL_A, all steps, between ini_time and end_time...
List page must show:
MODELSTEPQTTY OK_QTTY NOK_YIELDQTTY TOTAL

A____A____20__2__98.5__22

A__B120__1296.5__132

ETC...
In other words, after the user pass the filter criterias, Oracle need recalculate all the calculeted fields before show the list page. Any idea?
Tks in advance and have a nice weekend.
J
 		Jane 6/22/2010

Hi,
just add calculated fields to the SQL query on theEdit SQL query tab.

Remove ini_time and end_time field from the list page, but add these fields on the advanced search page on theChoose fieldstab. Also add new calculated fields to the list page on this tab.

Number of records after search are calculated automatically (in the top left corner of the page).

That's all.