Hello,
I created a BAQ and add the baq to the dataview and then bind the dataview into a panel card grid. when I run it, the result doesn’t show up. in the trigger, which type of trigger I should give to the dataview in order to load the baq.
thanks,
Eddy
Hello,
now, I can display the baq. but how can I assign the value to the baq parameter automatically. I don’t want to get popup. in my case, I need entery job num but I am in the Job entry. how can I assign the job num to my baq parameter in the grid.
thanks,
Eddy
I’m a hack, not an expert… but you can try the below…
Grid Properties > Data > Grid Model > Provider Model > BAQ Options > Where
[your BAQ column] = [query value]
Example: UD02_Key1 = ‘?{JobHead.JobNum}’
If I’m reading your post correctly, you’re adding this to Job Entry… so you may need to use:
‘?{KeyFields.JobNum}’
Hello,
still can not see the data from the dataview in the grid. I don’t know if the field value is set properly.
thanks,
Eddy
I don’t think you need an event. The BAQ dataview should pull the data into the grid natively. You’re not triggering anything to happen. The data should just be there.
Can you post images of your grid settings?
Here is one of mine, as an example:
Grid Properties:
Grid Model:
Provider Model:
Baq Options:
I think this last bit is where you enter the key that is driving your BAQ. In my case, my BAQ was grabbing info from my UD02 table… and displaying that based on the PartNum selected on the form.
So my expression was UD02_Key1 = ‘??{KeyFields.PartNum}’
You’ll have to figure out your expression here based on the field you’re trying to match up, but it should be like: Table_Field = ‘??{KeyFields.JobNum}’
Here is my BAQ (showing my link of UD02_Key1 = PartNum):
Do you have that Parameter built into your BAQ? You may need to delete it.
In the BAQ, you’re asking the user to enter the JobNum to get the results. In the dashboard, you want that value to come from the KeyField of the Job you’re already looking at… so you don’t need the BAQ Parameter at all (no user input required).
So, I would edit your BAQ and remove that parameter and see if your grid populates.
thanks a lot,
it works and my dashboard is working too in kinetic.
regards,
Eddy
