I have a panel card grid (PCG) that is being populated by a BAQ but I am unable to re-arrange the columns. Is this intentional? I have been messing around with trying to add the columns manually with a dataview loaded (doesn’t seem to be required if I use BAQ in the Provider Model, but I tried anyway). Any advice for this?
And a bonus question: to offer more context, I created a BAQ that linked together SNTran, RMARcpt, RMAHead, RMADtl, and RMADisp together and it gives me all the data I need. I used that BAQ in a PCG and added a Where clause SN_Tran.SerialNumber = ‘??{KeyFields.SerialNumber}’. This is for the Serial Number Details screen. I had another question because this only works if I have Serial Number as a display field in the BAQ, which makes it a bit redundant because I am already on the Serial Number screen. Any way around that?
An update:
I thought I would be able to rearrange the columns if instead of BAQing the data into the PCG I BAQ’d the data into a dataview. I know the BAQ is working with the provided data because I mapped one of the results of the BAQ to a text box and it returns the correct value but when I try mapping the dataview field to a column (Grid Model or Provider model) they both show nothing.
Am I missing something? Is there a reason to prefer BAQ to PCG vs BAQ to Dataview to map?
I found a solution. Don’t know if it’s BEST but it does what I need it to, but it’s a pain:
I load the Baq ID in Provider Model and click into Baq Options and set my ‘Where’ clause
I back out to Grid Model and in the Columns I have to manually type each field from the BAQ (SNTran_SerialNumber for example) and then in the Title name it what I want. I created the columns in the order I wanted them displayed in the grid and everything is working fine. It is tedious but it’s there. I used a combination of some info on here and the Application Studio PDF from Epicor to figure it out. Hope this helps!
Glad I got your sign off on this, I was sitting on another post you helped someone with on a BAQ to Panel Card Grid, which got me where I needed to be, but with no ordering.
I’ve seen some users on here claiming success with changing the column order within the Application Studio layout and saving it (like you were personalizing the grid (manually dragging the columns around), but within App Studio).
There was a discussion about this a short time ago but now I can’t find it. It may have been a side-discussion within a thread of a different topic so I’m probably not using the right search terms to get to it now.
But… if you want to test it… once your columns are added… in the layout of app studio, move some columns around manually and save. Then go back into your grid model > columns, and they MIGHT be in the order you set them to in the layout.
So, you can’t reorder them in Grid Model > Columns, but moving them in the layout and saving (if I remember correctly) might re-order them when you go back into Grid Model > Columns.
