1 person found this helpful
This is because the query is excluding the current site you are trying to modify since it is actually in the report.
You can include in your query:
or site_id = :Pxx_SITE_ID
Where Pxx_SITE_ID is the item holding the site_id value and xx is your page number.
Would that statement be included in the first where clause or the second one?
The second (LOV):
SELECT SITE_NAME, SITE_ID FROM SITES WHERE SITE_ID NOT IN (SELECT SITE_ID FROM ACTIVATION WHERE this = that) OR SITE_ID = :PXX_SITE_ID
Thanks @ediazjorge !!!! That worked like a charm