python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - oracle-apex-5

APEX Column value to change based on LOV in IG

Screenshot of my settings. On Interactive Grid - I have column-a "TaskID" and other column-b is "Predecessors", which is LOV of “TaskID” column. Each TaskID has a start date in Co...
test-img

VamC

oracle-apex

oracle-apex-5.1

oracle-apex-5

Votes: 0

Answers: 1

Latest Answer

Yes, using a dynamic action will be the easiest way to do this. Create an on change dynamic action on your predecessors column: Then create a Set Value Action using the corresponding SQL query:
test-img

askMax - Maxime Tremblay

Column to update the sysdate/time in PST

I have two columns (Status & Updated Date) in IG. Everytime the status column is change with something, I want to log the time it is updated (in PST). Here is how I'm doing it but its not working ...
test-img

VamC

oracle-apex

oracle-apex-5.1

oracle-apex-5

Votes: 0

Answers: 1

Latest Answer

SYSDATE is already a date so you do not need to use CAST on it. Similarly, since it is already a date you do not need to use TO_DATE on it and this is likely to cause errors. So your code can just be:...
test-img

MT0

Oracle APEX - LOV on a column to show distinct values except one

On Interactive Grid - I have a column "TaskID" and other column is "Predecessors". I want Predecessors column to be LOV with the distinct values on TASKID except the current row TA...
test-img

VamC

oracle-apex

oracle-apex-5.1

oracle-apex-5

Votes: 0

Answers: 1

Latest Answer

perhaps something like this? with task as( select 'a' as task_id from dual union all select 'b' from dual union all select 'c' from dual union all select 'd' from dual) select x.task_id from task x w...
test-img

Oguen

How to enable submit button based on validate button in Oracle APEX

I am searching for this every where no one is able to help me. Only this is the one hope left for me Below is my scenario and components I have used * 1 file browse button - To select file * 2 butt...
test-img

nodehep223

javascript

plsql

oracle-apex

oracle-apex-5

oracle-apex-20.2

Votes: 0

Answers: 1

Latest Answer

From my point of view, I'd remove the "Validate" button entirely. modify validation so that it doesn't return TRUE/FALSE, but e.g. Error Text so that - if file is empty - validation display...
test-img

Littlefoot

Posts

Questions

Blogs

Jobs