If I hard code the parameter value then I can get a row of data and populate into the other components. IF, I bind the value to the view.params.p_item then it does not work.
p_item gets the value passed from an on row click event via event.valuve["ItemID"].
I bound one label to p_item. Then, created a custom property in the view, bound to the named query in the image. (I marked the previous thread as solved because I was able to get data into each component, but that only seems to work if I hard code the queries parameter value.)
So, if I can’t use the view.param.p_item to pass into the query, and I can’t use a bound components value, what can I use?
It looks like you are trying to bind from the query result to use in the query’s own parameters? You can’t circularly bind like that (well, not without extreme difficulty). Use separate queries, if necessary, to provide options to pick from.
Or just make your user type in the catalog number.
you can use p_item, but make sure to “commit” you parameter changes in the Expression input in the binding dialog; you have to actually press Enter to commit typed text.
Before hitting Enter, and even after clicking around in the dialog:
I don’t know why it doesn’t like it now. Does not make sense.
FYI - i created a new view with a table, same data, and new popup than what was used in the first post, so I could add one component/property/binding at a time and try and find what the issue is.
If there is no row in .a_item to start with, you should wrap that whole thing with a try() expression. That can supply an initial value until .a_item is populated.
You'll change your mind when you get over the newbie hump.
If your catalog number is actually a number (your NQ param is an int), then the try() fallback should also be a number. try() needs to deliver the same datatype as the working expression would deliver.