Posted: 15 Jun 2015 14:20 EDT Last activity: 17 Jun 2015 16:43 EDT
Accessing Data Page from Database defined in Data Model
Under a POC I am doing - I defined a database in the data model. The database has 7 rows.
A field in the database is ReqID.
I want to populate unique values in the ReqID onto a dropdown i defined in a section.
I have changed the type to a dropdown. Defined the type in list source as data page, pointed the data page to the positionlist that i defined when i created the database and also pointed the "property for value" as .ReqID.
In the PRPC tutorials the above is what is required to populate unique values in the ReqID onto a dropdown i defined in a section.
Check the Parameters tab of the data page. Did you define a parameter?
Then, back on the Definition tab of the data page, did you pass a parameter Value?
fwiw, it seems as if your POC is a duplicate of an exercise in SAE1, so consider going back to that exercise and reviewing your work to ensure it matches the solution; at least in terms of where to define the parameters and where to map them.
It is that exact excercise. I have validated the steps that the excercise mentions but it is exact.
When i check the "create data pages" and i mention the Lookup data page and list data page when i create a data model I was under the assumption I dont have to define parameters in the data page as it lookups the data from the data table
Also - I am getting the following error when i look up the list I am trying to access.
An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 58P01 Message: ERROR: could not access file "pljava": No such file or directory