Skip to main content
Solved

Invalid Identifier In Navigation From Lobby

  • August 1, 2022
  • 3 replies
  • 363 views

Forum|alt.badge.img+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?

Best answer by Link

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.

3 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • August 2, 2022

Hi @Erik.VanderLaan 

do you have any custom fields?

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


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • August 2, 2022

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


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • Answer
  • August 2, 2022

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.