Examples of Additional SQL
You can add your own additional SQL for advanced filtering, to be appended to the current filter, if the resulting filter on the List block is insufficient.
This is possible in almost every list block in Web Configuration , except for fixed lists such as the communication logs of a business object.
This chapter provides examples of additional SQL.
On Request list:
AND MAIN_TABLE.NAAM LIKE '%aa%'
AND MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE CODE = '100001')
AND MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE SYSCODE = [&PERSON])
AND (MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE SYSCODE = [&PERSON]) )
OR (MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE NAAM LIKE '%bars%'))>
Fixed filter: ( (InternalCoordinatorPersonRef = 100011, Ahuis, T.J.) )
OR (MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE SYSCODE = [&PERSON]))
OR (MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE NAAM LIKE '%bars%'))
AND (MAIN_TABLE.SYSMELDER IN (SELECT SYSCODE FROM PERS WHERE NAAM = MAIN_TABLE.NAAM )
On Publisher list of spaces:
The Join query should be replaced by subselect as shown in the following example:
Normal query:
select * from RMT Inner Join RMTGBR
On RMT.SYSCODE=RMTGBR.SYSRMT
where 1=1 and (RMT.SYSCODE IN (SELECT SYSRMT FROM RMTGBR WHERE ( (EINDDATUM > CURRENT_TIMESTAMP))))
Additional SQL query:
AND (MAIN_TABLE.SYSCODE IN (SELECT SYSRMT FROM RMTGBR WHERE (EINDDATUM > CURRENT_TIMESTAMP) AND (RMTGBR.SYSRMT = MAIN_TABLE.SYSCODE)))
On parking area utilization:
AND TABLE_1.SYSCODE IN(SELECT FK_PARKINGAREA FROM PLN_PARKINGAREAOFPROPERTY WHERE PLN_PARKINGAREAOFPROPERTY.DISTANCE='1')
For linked properties:
AND TABLE_1.SYSCODE IN(SELECT FK_PARKINGAREA FROM PLN_PARKINGAREAOFPROPERTY WHERE PLN_PARKINGAREAOFPROPERTY.DISTANCE='1' AND FK_PROPERTY = TABLE_3.SYSCODE)