Hi all,
When my page loads (and possibly when it refreshes) I would like to populate my cards region with all records. When I type into the search region I would like the cards to change based on the input into the search field (letter by letter). I have the second part of this working fine using a DA but I cant work out how to initially show all records on page load.This is the SQL I am using as the source for the regions:-
select apex_util.prepare_url('f?p='||:APP_ID||':50:'||:APP_SESSION||':::50:P50_ID:'||XXXXXid) card_link,
XXXXXX_FULLNAME "CARD_TITLE",
XXXXXX_COMPANY "CARD_TEXT",
XXXXXX_SPECIALISM "CARD_SUBTEXT",
XXXXXX_INITIALS "CARD_INITIALS",
XXXXXXID "XXXXXX_ID"
from XXXXXX
WHERE XXXXXX_SURNAME = :P2_SEARCH or
instr(upper(XXXXXX_SURNAME), upper(:P2_SEARCH)) > 0;
Is there a way of substituting P2_SEARCH for a wildcard if it is null?
Thanks
GoApex