Skip to main content

I am getting an error when trying to navigate to a page from a lobby element. When I check the sql query, it seems to be ok and I can get the data from the database correctly. But when I click on the lobby element, it says that some columns are invalid identifier.

An example:

  • I have this element. When i click on the preview button, i can see the data:
  • This is the SQL query:

select CF$_EXPLANATION,
  CF$_MODE,
  CF$_DATE,
  CF$_TYPE,
  CF$_CREATED_BY,
  CF$_MOORDERNO,
  CF$_MO_ORDER_NO,
  CF$_ASKED_PERSON CF$_QUESTION_ISSUE,
  CF$_ORDERNO
from
  &AO.REVISIONS_CLV.REVISIONS_CLV
where cf$_type ='Question'
and cf$_orderno like '%*%'
and (select cf$_mo_site
  from ifsapp.customer_order_line_cfv
  where order_no=
    &AO.REVISIONS_CLV.cf$_orderno
  and line_no =
    &AO.REVISIONS_CLV.cf$_line_no
  and rel_no =
    &AO.REVISIONS_CLV.cf$_del_no
  AND ROWNUM =1) in ('SPFL','SPDE', 'WDUK', 'ALIM','SPAT')
and ((select OBJSTATE
  from ifsapp.customer_order_line_cfv
  where order_no=
    &AO.REVISIONS_CLV.cf$_orderno
  and line_no =
    &AO.REVISIONS_CLV.cf$_line_no
  and rel_no =
    &AO.REVISIONS_CLV.cf$_del_no
  AND ROWNUM =1)<>'Cancelled' )

  • When i navigate to the page, it gives this error:

 

@Sena Kayıkçı I see you enabled navigation by using Data Source condition. Normally the system wants to navigate to the Customer Order page and tries to filter by Order_No, but in your case the column name is CF_order_no. Could you try to relabel the column name to Order_No and see if it works?

I did as you said but unfortunately it didn't work. It still gives the same error. I also tried to filter this way but that didn't work either. Since CF$_ORDERNO is a custom field in the view, I cannot change it directly from the database.

 

Filter:

page/CustomerOrder/Form?$filter=OrderNo eq $$Order_No]

 

 

@Sena Kayıkçı  since you’re using custom fields, you would need to deactivate Use Datasource Condition in the Navigation section of the Lobby Element. 

Could you try with the below filter:

page/CustomerOrder/Form?$filter=OrderNo eq $NCF$_ORDERNO]

It works now, thank you for your help.

@Sena Kayıkçı I’m glad it worked. Please mark this post as Solved so that it could be useful as future reference for other users when they’ll deal with a similar issue.

Reply


Terms & ConditionsCookie settings