Omit second group

[Ron Cates]

Hi all. This question is in reguards to formatting a find and omit request.

My script:

Enter Find Mode [ ]

Set Field [ Departments:_pk_department_id; Administration_Billing::xrepeat_dep ]

Set Field [ Jobs::year; Administration_Billing::xrepeat_year - 1 ]

New Record/Request

Set Field [ Departments::_pk_department_id; Administration_Billing::xrepeat_dep ]

Set Field [ Tickets::year; Administration_Billing::xrepeat_year ]

Omit Record

Perform Find [ ]

Now I would like to omit a second group but I'm not sure how. Would this be correct?

My script:

Enter Find Mode [ ]

Set Field [ Departments::_pk_department_id; Administration_Billing::xrepeat_dep ]

Set Field [ Jobs::year; Administration_Billing::xrepeat_year - 1 ]

New Record/Request

Set Field [ Departments::_pk_department_id; Administration_Billing::xrepeat_dep ]

Set Field [ Tickets::year; Administration_Billing::xrepeat_year ]

Omit Record

New Record/Request

Set Field [ Departments::_pk_department_id; Administration_Billing::xrepeat_dep ]

Set Field [ Tickets::year; Administration_Billing::xrepeat_year ]

Set Field [ Tickets::status; "Cancelled" ]

Omit Record

Perform Find [ ]

Thanks

[jamesducker]

Personally, I'd do:

enter find mode

set field [x ; 1]

set field [y ; 2]

perform find

# we've found all the records where x is 1 and y is 2... now let us narrow it down...

enter find mode

set field [z ; 3]

omit record

constrain found set

# found set is now x = 1 and y = 2, but z is not 3

enter find mode

set field [ a ; 4]

constrain found set

# found set is now x = 1 and y = 2, z is not 3 but a = 4

And so on...

Hope that helps.

James

[Ron Cates]

Thank you so much ;)