CODEWITHSUNDEEP
oracle-apex
purple dalilah
purple dalilah

Reputation: 13

APEX 5.0.1 - interactive report using aliases give blank edit forms

So I've been working on an application in Oracle Application Express 5, in which I have multiple interactive reports with an update form. I have noticed that when I use aliases in the SQL query of the report, the edit on the report stops working. When I want to edit a row, I just get the blank form for adding a new entry, even though I can see in the URL that the primary key has been sent.

Is this a known issue, and is there any way to make this work?

My column names are partly Croatian abbreviations, so leaving the original column names would be too messy. Here's an example of my code which works:

select "SIFRA_A_P", "SIFRA_P", "NAZIV_P", "CIJENA" from "#OWNER#"."PJESMA"

Writing it like this

select "SIFRA_A_P" as "ALBUM", "SIFRA_P" as "ID", "NAZIV_P" as "TITLE", "CIJENA" as "PRICE" from "#OWNER#"."PJESMA"

makes it stop working properly.

Upvotes: 1

Views: 992

Answers (2)

Cristian_I
Cristian_I

Reputation: 1625

Go on your page where you have the problematic report, go at Report Attributes and in the Link Column section now you have something like this 

Name                       Value
Item 1:P3_SIFRA_A_P        Value 1: #SIFRA_A_P#
Item 2:P3_SIFRA_P          Value 2: #SIFRA_P#

Change the #SIFRA_A_P# to #ALBUM# and #SIFRA_P# to #ID# in the value column.

Upvotes: 1

Vance
Vance

Reputation: 897

include rowid in your select statement.

     select rowid,"SIFRA_A_P" as "ALBUM", "SIFRA_P" as "ID", "NAZIV_P" as "TITLE", "CIJENA" as "PRICE" from "#OWNER#"."PJESMA"

Upvotes: 0

Related Questions