Resources

Resources filter

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.

The filter has the following meaning:

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

APS_sched_standard_Res

Window fert_xgantt_planing_ressource.psr

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.

Note:

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

•	Parallel or alternative resources are not considered

•	Always searched on WO level

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

Help URL: https://help.beascloud.com/beas202102/index.html?resources.htm