2. PHPRunner General questions
  3. Custom view
This topic is locked

Custom view

 		3/3/2008 3:30:06 PM
PHPRunner General questions
F
 futo author

hello,
i have table called JCD, with fields:

Date

Number

Procedure

Company

Description

Amount

Date2

Status

JCD_Id
field called Procedure have two options, EXPORT and IMPORT

field called _Status_have two options YES and NO
I WANT TO CREATE CUSTOM VIEW FOR TABLE JCD, AND DISPLAY ONLY RECORDS WITH FIELD PROCEDURE WITH VALUE IMPORT, AND FIELD STATUS WITH VALUE NO
PHP CODE FOR THIS SITUATION, AND WHERE TO PUT THEM
manny thanks for solution
J
 		Jane 3/5/2008

Hi,
create custom view of JCD table on the Datasource tables tab and edit SQL query for this view on the Edit SQL query tab.

Here is a sample:

select Date,

Number,

...

JCD_Id

from JCD

where Procedure='IMPORT' and Status='No'
F
 		futo author 3/5/2008

Hi,

create custom view of JCD table on the Datasource tables tab and edit SQL query for this view on the Edit SQL query tab.

Here is a sample:


manny thanks. it works fine :)