Resources

Define the filter on resource level here. This is active if at least one entry has been selected.

The resources are displayed by resource group + resource ID or resource optimization sorting if this function is enabled for this resource group.

Display all WO positions if the resource was stored somewhere in the WO on routing level.

Column	Meaning
OK	Activate to select this resource.
Resource	Resource ID.
Description	Resource ID.
Group	Resource belongs to the indicated resource group .
Resource Group	This resource is a resource group.
Employee	Responsible employee.

All Mark: By clicking on this button, you can easily select all resources to be considered for the scheduling.
Delete flag: Click on this button to clear all the existing checks for resources.

•The belonging resources also have to be selected if a resource group has been selected

Example:
Order 1, assembly 10: includes resource A1
Order 1, assembly 20: includes resource A2

Filter on resource A2:

Display assembly 10 and assembly 20 in this case.

Reason: A structure search would be alternatively, so check if this resource is stored somewhere in the assembly structure. This can also be in the subassembly. But a structure search per SQL is not possible. The speed would be greatly reduced.

This problem appears only if multiple assemblies are inserted in a WO on top level (Summarized order). Should be avoided.

The function of the filter changed completely (beas 9.2 PL: 02)

windowevent setresourcefilter
// value -> the new sql statement
// e_resourcefilter -> all choosed resources, example 'A001','A002'

Default SQL Statement for this Filter

(SELECT count(*)
FROM "BEAS_FTAPL" a
INNER JOIN "BEAS_FTPOS" p on a."BELNR_ID"=p."BELNR_ID" and a."BELPOS_ID"=p."BELPOS_ID" and isnull(p."ABGKZ",'N')<>'J'
WHERE a."BELNR_ID"="BEAS_FTPOS"."BELNR_ID" and isnull(a."ABGKZ",'N')<>'J' and isnull(a."AKTIV",'J')='J' and a."APLATZ_ID" in (<e_resourcefilter>)) >0

Example:
Check only current work order position and not all work order positions from current work order

windowevent setresourcefilter

#define value

(SELECT count(*)

FROM "BEAS_FTAPL" a

WHERE a."BELNR_ID"="BEAS_FTPOS."BELNR_ID" and a."BELPOS_ID"="BEAS_FTPOS."BELPOS_ID"

and isnull(a."ABGKZ",'N')<>'J' and isnull(a."AKTIV",'J')='J' and a."APLATZ_ID" in (<e_resourcefilter>)) >0

#end

end event