Set a TransView column to be "Like" an Erp table column?

I’d like to right click on a text box bound to TransView.VendorID and be able to right-click / “open with” the standard search.

Anyone been able to set a TransView column like this?

Thanks,

Joe

1 Like

No but I have a workaround.

Make your own “TransView” type dataview, and define it from a BAQ.
(Make sure you add a row)

Add the fields you want.

If you want to do Calc fields, put them in a subquery and add that query to the top and then you can use the field attributes editor to set a like on them as well.

2 Likes

That’s interesting.

I suppose you could have a single utility BAQ with multiple Like columns and add columns as you need them.

Thanks.

Joe

That’s kind of what I was thinking.

With app studio, sometimes you gotta think outside the box.

Think Outside The Box GIF by The Roku Channel

1 Like

Are you just looking for the search functionality?

You can bind your textbox to TransView and when you create the OnSearch click event… you can call any search you want.

But, if you want FULL context menu functionality (“open with…”), then yes, you need to work around it some other way as the standard “Like” functionality are driven by the object/table metadata server-side… not in the UI where a temp view like TransView lives.

In which case, I like @klincecum’s approach!

3 Likes

And you can do custom context menu options on a TransView Column and wire up all the events to launch Supplier Entry passing VendorID, for example, but it’s a lot of work to recreate all the ootb ‘Like’ options so Kevin’s loading from BAQ is easier.

1 Like

Thanks, all for the suggestions!

Joe

1 Like

I can’t remember when or where. However I have once used the debug Ctrl + Alt + L to dump out the component of a field that has the like I wanted. In there is a section that has the like column.

Then used property set to set this on my own component which then gave it its right click context menu.

This is component based rather than database field based. But if I remember rightly it was for a search field on a dashboard.

3 Likes

Ahh yes. extendedProps.like

…went looking earlier but ctrl alt L was busted. :wink:

3 Likes