Kinetic BAQ/RDD Report: How to allow user to enter multiple items, paste-insert gone?

[systemcoord (Jeff Hines)]

Please tell me there is a way to let users paste in a list of Parts, or whatever else into a Kinetic BAQ or RDD Report filter instead of playing carpal tunnel speedrun any% clicking a potentially massive number of items in the Search Results list.

For reference, everyone in my company is a certified Wizard with the Paste Insert functionality in the Classic UI, which appears to only be available in grids:

[GabeFranco (Gabriel Franco)]

With the UI that’s built by the out of box “Wizard”, I don’t believe so. You’d need to go into app studio and create a custom layer to add that, then add your customized layer to the menu (or override the existing one)

That search box only takes input of one PartNum at a time, the search dialog allows for multi select but no functionality to paste in a selection list that i’m aware of.

[bderuvo (Bryan DeRuvo)]

It works okay for me.

[dcamlin (David Camlin)]

This works for Job Traveler because the system has a “validateFilter.Jobs” process that it runs.

If you’re just using a BAQ report, its not so friendly.

I was able to hack around it, if you’re interested. Unfortunately, I couldn’t get it to right-click paste insert… but I COULD get it to work with CTRL+V.

You’ll need a custom layer on your BAQ Report Form.

I added a custom textbox where a user could paste in their excel values. We need a “Paste Here” text box because we need to modify the list coming from Excel (or other sources):

I gave the textbox an ID of Filter1PasteInsert… and then bound that to TransView.Filter1Paste.

I then created an event:

Trigger is onBlur of that added textbox

Row-Update #1: I’m taking my pasted value from TransView.Filter1PasteInsert and cleaning that up. When you paste in from excel, it contains carriage returns, line feeds, etc. So, the row update is going to take your pasted value and write the new value to a second TransView field I called “CleanFilter1”

Here is my full expression:
"{TransView.Filter1Paste}".split("\\r").join("~").split("\\n").join("~").split(" ").join("~").replace(/~~+/g,"~").replace(/^~|~$/g,"")

The end result SHOULD be a tilde (~) delimited list.

ON SUCCESS of that row-update… perform Row-Update #2

This one takes the “cleaned” tilde delimited list from TransView.CleanFilter1 and passes that value to ReportParam.Filter1.

Here’s the preview results… I pasted in (3) values copied from Excel. The row updates turned that into a tilde delimited list… and the ReportParam.Filter1 accepted those as individual values.

Again… not pretty… but if your users are “paste-dependent”… it will work.

[Randy (Randy Stulce)]

That’s a keeper for my tips bookmarks!

[systemcoord (Jeff Hines)]

David, I appreciate the effort and insight. I’ll give this a shot and report back, maybe tweak the idea a bit.

[jbooker (Josh Booker)]

Very Nice David!

I looked at the JobTrav and turns out it’s a fancy component called a Search Chip Selector.

You bind it to a dataview column and optionally set the labels.

Then you create an OnSearch event

having a search-show action:

validation json:

{
	"validateFilter": "JobNum = '%value%'",
	"errorMessage": "Invalid Job"
}

and a search-value-set action:

Done.

[dcamlin (David Camlin)]

Yes, and that is set up exactly like @bderuvo’s original example using Job Traveler. There is a built in validation filter for Jobs and the Search Chip Selector is bound to ReportParam.Jobs.

The problem is doing this with a BAQ report and the provided “Filter” Search Chip Selector is bound to ReportParam.Filter1… and you end up with an error:

[jbooker (Josh Booker)]

Does it work if you put this in the validation property?

{
“validateFilter”: “JobNum = ‘%value%’”,
“errorMessage”: “Invalid Job”
}

[dcamlin (David Camlin)]

Not if I’m not filtering job numbers.

I don’t have a BAQ report that attempts that.

There may be other stock validationFilters… like Part, or Sales Orders… I’m not sure. But I attempted to use validateFilter of ProdCode and it puked.

[jbooker (Josh Booker)]

Makes sense. Too bad we’re stabbing in the dark without proper docs. I’ll try some things when I get around to it. I bet it works like:

{
“validateFilter”: “1=1”,
“errorMessage”: “Never invalid”
}

but that kinda defeats the purpose.

!!! EDIT: Don’t do this keep reading !!!

[systemcoord (Jeff Hines)]

{
“validateFilter”: “1=1”,
“errorMessage”: “Never invalid”
}

Just tried the above, it loaded every single part (I know, big yikes) into the ReportParam.PartNum field:

If I use PartNum = '%value%' the entire pasted list is evaluated in the validation rule:

Still haven’t worked out how to split the pasted data and validate each part.

[jbooker (Josh Booker)]

@systemcoord

Still haven’t worked out how to split the pasted data and validate each part

Are we sure it’s meant to? JOBTRAV doesn’t. AFAIK.

Does PartNum = ‘%value%’ work for your BAQ?

[systemcoord (Jeff Hines)]

Are we sure it’s meant to?

Does PartNum = ‘%value%’ work for your BAQ?

I have no idea. Still testing things out, reading the documentation helps slightly but… only just slightly.

[jbooker (Josh Booker)]

@systemcoord

it loaded every single part (I know, big yikes

Yikes is right. Sorry about that. At least now we know what that does. Says: lookup entity I’m searching, where validateFilter returns true. Rather than: is this a valid filter string syntax.

[jbooker (Josh Booker)]

FWIW, this does seem to work well. see:

Custom Part Context Menu Open With

PSS- I got the grid.ViewOptions > BAQ Options > WHERE expression to work for IN() clause using this technique with this syntax Part_PartNum IN (?{TransView.PartsSQL}) So now it works for a Context Menu ValueIn and a multi-select searchResult with mutli-paste using SearchChipSelector component: [ContextMenu-SearchChip]

[systemcoord (Jeff Hines)]

FYI I’m swamped, haven’t had a chance to try this yet.