Ana
Ana

Ana

View Profile
  • 0
Professional
Asked:
  • 0

Hello Sir, I would like to implement the following. The user has the possibility to select a responsible person with a pop-up LOV, the responsible person can be either a staff member or a manager. Both are stored in different tables, but should be displayed to the user. I use the following sql query for the list of value: SELECT u.Lastname || ', ' || u.Firstname AS displayed, s.STID AS ID from STAFF s left outer join USERS u on s.UUID=u.UUID union SELECT u2.Lastname || ', ' || u2.Firstname AS displayed, m.MAID AS ID FROM MANAGER m left outer join USERS u2 on m.UUID=u2.UUID Depending on what the user selects for this column I want set the Foreign Key either to the table STAFF or to the table MANAGER. This implementation is desirable because the user has the possibility to see all possible responsible persons he/she chooses at once, without the need to specify (Is it a staff member or manager?). So in general, the question arises, can you automatically set a foreign key to the corresponding table based on a lov choise of the user? Another possibility: create two hidden page items, each has a foreign key constraint to the corresponding page. Depending on the return value of the list of value, ...

apexlovoracle
aadeeaan
aadeeaan

aadeeaan

View Profile
  • 0
Contributor
Asked:
  • 0

Hi There, I need to highlight font color of column values in interactive grid based on the below condition: Highlight font color of Column A when the value is not equal to the value of Column B. Dynamic action created on the column A, event - change, where client side condition given as Col A != Col B True action : set style, Style Name: color, Value: red. When I am running the page it is highlighting when I click to change the value of particular cell. When I don't select the particular cell It shows it's original font color rather than showing red in color even though the condition satisfies.

oracle apex
Ana
Ana

Ana

View Profile
  • 0
Professional
Asked:
  • 0

Hello Sir, I have the following issue. In a form, the user has the option to enter contact details for a user, but these are not stored in any table, as the user has to register in the system for the first time and give their consent for the first time. As soon as the user submits the forms, a summary of their data is displayed to them, I retrieve this from the tables. However, I cannot retrieve the data for the contact details because they are not stored anywhere. It doesn't work with Collections as it is deleted with each new session. Another idea would be to work with flags, for example, i.e. to first save the contact details and store them in the corresponding tables, but if nothing happens or there is no consent, the user should be deleted better say the data should be deleted. Have you already encountered such an issue and if so, how did you deal with it?  

apexdataoracle
Ana
Ana

Ana

View Profile
  • 0
Professional
Asked:
  • 0

Hello Sir, I have 3 types of users. These perform different actions in a process. Depending on the action, I want to record the pages in a seperate table (table2) (STATE=REQUESTED, PAGE=80,TBL1ID=1). Depending on user logging in, he can read only edit or read only some fields. I  created a trigger which creates a new row in the table (table2)  when an insertion is made in the other table(table1). However, as soon as an update is made to this table(table1), the row of the other table (table2) should be updated, not whole row columns of the table. So I would like to create a trigger which updates a row depending on value of column of the other table(table1). I tried something like this. create or replace TRIGGER INSERT_PAGE BEFORE update or insert on TABLE1 for each ROW begin if INSERTING THEN INSERT INTO TABLE2 (TBL1ID,STEP,PAGE) VALUES (:NEW.TBL1ID,:NEW.STEP,15); elsif UPDATING and :NEW.STATE='APPROVED' THEN update TABLE2 set PAGE=16 AND STEP1='TEXT123' where TBLID1 =TABLE1.TBL1ID; end if; end; But I am not sure whether a trigger should be the solution here and how in general a trigger with an update statement can be created depending on column value of other table. Can you give me suggestions here?:)

apexoracletrigger