Custom Part Context Menu Open With

[jbooker (Josh Booker)]

Here’s an example of passing with app-open using ValueIn property.

Getting Custom Application Errors after this weekend's update

Lucas, try this: You’ll need to define the Value In property, if it’s empty. Use a {}. [image] If you need to pass values in, they’ll need to go through Value In as well. [image] To pick them up on the custom receiving layer, you can reference them like this: “%session.context.initialValueIn.ValueIn.SelectedJob%” “%session.context.initialValueIn.ValueIn.SelectedOpr%”

EDIT: Nevermind

The issue you may run into on the receiving side is that BAQ options in the gridModel/providerModel/viewOptions don’t seem to evaluate Where expressions - or any expressions for that matter. So you can’t go:

Where: "PartNum = '%session.context.initialValueIn.ValueIn.PartNum%'

Not within the Baq options of a grid anyway, AFAIK. You’ll probably have to modify your whole dashboard to rip out and change over to a ‘vanila’, non-baq dataview, recreate grid provider, and create explicit events to load your dashboard dataview. It’s kind of messy. Easier to start over with a blank app (non-wizard) really.

Okay I did some testing and found the problem prevously mentioned was specific to WHERE IN() clause.

My approach would be to break it down:

1. Dashboard Prep: first get your dashboard independently filtering on TransView.PartNum, then
2. Handle ValueIn: pass a valueIn (automatic), receive it, and set TransView.PartNum.

something like so:

#1 - Dashboard Prep

• Add a TransView dataview
• add a PartNum Textbox to the grid panel header area. (optionally set isSearch=true & handle search-show, search-value-set at a later time)
• epBind that input to TransView.PartNum
• edit your grid.ProviderModel or ViewOptions > BaqOptions > Where List >
  PartNum = ‘?{TransView.PartNum}’
• add event TransView.PartNum_onChange with event-next > refresh_yourView event, this is so the grid refreshes automatically when you change the value.

Test this and get it working independently. Fix up grid.columns, etc. Now your dashboard is using TransView.PartNum as criteria for your grid and is ready to handle a passed valueIn.

#2 Passing ValueIn
Add another event Trigger: Event > After > window

with a condition:

context && context.initialValueIn && context.initialValueIn.ValueIn

and row update TransView.PartNum:

%session.context.initialValueIn.ValueIn%

This should set TransView.PartNum and trigger your refresh event.

EDIT: The passing of ValueIn appears to be automatic from Context Menu so all you have to do is make your dashboard criteria use TransView and grab the ValueIn and set it in Transview as described above.