Solved

Invalid Identifier In Navigation From Lobby

  • 1 August 2022
  • 3 replies
  • 229 views

Badge +2

In a lobby, I am pulling in data to count the number of scheduled parts for the current and future week. the lobby is able to see the data and it works how I expect, however when I added navigation functionality, it brought up a  Invalid Identifier error. 

Error on linked screen
Data Source designer
Element Designer

Could this be a permissions issue?

icon

Best answer by Link 2 August 2022, 15:34

View original

3 replies

Userlevel 7
Badge +22

Hi @Erik.VanderLaan 

do you have any custom fields?

If yes you then you need to use the custom view. Please check it.

Badge +2

There are custom fields, but I don’t use any of them. Also it is pulling in the data correctly, but the error occurs when linking to the relevent page. 

I think that it has to do with “Schedule date” not being a field that I am able to search by. Is there a way to add this field? I can’t use an SQL where expression to sort by schedule date either as the same error pops up

Userlevel 7
Badge +22

Then you have to use the view line_sched_receipt_cfv and you need to make at least one custom field visible to avoid this error message. You can test the view with pl/sql at first.

Reply