Hi,
I’m trying to create a search chip on a dashboard to filter my BAQ based on a list of ‘Job + Assembly’ that a user selects. However, the search chip turns gray and unclickable when I preview the dashboard.
The EpBinding field is coming from my ReportParam dataview, and the data table is JobMtl.
Any ideas on what I might be doing wrong? Maybe I need to create my own data table for the search chip instead of using an existing table?
Usually when things are grey, its because the dataview isn’t initiated yet.
Create an event with a trigger for after form_onload (or whatever you can find to use that runs when the form opens up).
Add a Row-Update setting ReportParam.JobNum to blank/empty (“”).
That should initiate the dataview and the column should “wake-up”.
Sorry for my late response.
That’s it! Thank you, David. I created an on_Init event with a row update on the Ep Binding field, and now it allows me to click and search for jobs.
Emm… I’ve seen some posts about filtering the BAQ based on the value in the search chip. So, I’ll need to call a function to convert the values in my DataView into a format that SQL can read. After that, I can go into the BAQ options to set the filter.
The question is, how do I combine both values coming from the search chip into one? For example, JobNum and AssemblySeq are listed separately, and I’d like them to be combined into something like ‘46901-100’—essentially, JobNum + AssemblySeq.
Do I need to create another DataView and use a RowAdd event to update it? Or I just need to create a single field in my TransView to include both JobNum and Assembly?
