Omit Records based on given criteria

[dervaish]

hello all

i have a portal showing results of drug tests. it works fine except that it show tests which do not have any results [clinic visits]. so when i load the layout, it shows patient info [parent layout and table], related tests [in portal one] and related results [in portal two]. i want to show all the tests in portal one [working fine] but i only want to show results of the tests which have anything but clinic visit in tests. how can i omit/filter out "clinic visit" result-rows from the portal.

for example

PATIENT ID : 7

==============

TEST PORTAL [shows these records]

===============

CLINIC-VISIT,DATE,ETC

CLINIC-VISIT,DATE,ETC

HEARING,DATE,ETC

ECG,DATE,ETC

===============

RESULTS PORTAL [should show these records only for patient # 7]

===============

HEARING,DATE,ETC

ECG,DATE,ETC

omitting / filtering out CLINIC-VISIT ROWS from RESULTS portal.

as you can see from the above example, i want to find and filter out/omit all the rows [from results portal] with CLINIC-VISIT listed in them

Edited May 3, 2008 by Guest

[LaRetta]

...it works fine except that it show tests which do not have any results [clinic visits].

If I understand correctly, and if you have the proper relationship, then you can place the Results portal on the Patient layout directly. Since your Results table doesn't have a record for CLINIC-VISIT, then they wouldn't appear in the portal anyway.

If there are fields from Tests table, you can place them within the Results portal as well (because Tests will be the parent to Results).

[dervaish]

thanx for ur help and input. much appreciated.