hymal7
(Himal Gurung)
September 17, 2018, 11:21am
1
Hi all,
I have a simple BAQ that displays the operations (and other job details) on a job. On the example attached, there are 5 operations, therefore the BAQ displays 5 lines.
Is it possible to modify this where there will be only one line per job, and one column that shows all the operation sequences and/or another column that shows all the operation codes?
Thanks for your help.
Hymal7
hymal7
(Himal Gurung)
September 17, 2018, 12:54pm
3
Thanks for the link @ckrusen
ckrusen
(Calvin Krusen)
September 17, 2018, 12:59pm
4
I used it for a BAQ that groups together Order lines with the same Product Group.
The upper pane is summary (Lines with the same Product Group on the same order), the lower shows the individual lines.
1 Like
hymal7
(Himal Gurung)
September 17, 2018, 3:51pm
5
Thanks @ckrusen finally got it working…however I still get a comma at the end of the results. do you know how to get rid of it?
ckrusen
(Calvin Krusen)
September 17, 2018, 4:06pm
6
I think I made a calculated field that took that value and just trncated it if the last character was a comma.
Case when substring(Lines, len(Lines), 1) = ',' then substring(Lines, 1, len(Lines)-1) else Lines end;
Lines
is the field that holds the comma sep text.
2 Likes
hymal7
(Himal Gurung)
September 18, 2018, 9:30am
7
ckrusen:
Case when substring(Lines, len(Lines), 1) = ‘,’ then substring(Lines, 1, len(Lines)-1) else Lines
thanks this worked ! (P.S. added “end” at the end of the code)
1 Like
J_P1
(J P)
April 26, 2023, 1:01am
8
Hi Hymal7, Do you mind sharing you JobHead, JobOper BAQ? Thanks