I have a report option field (PartMtl.PartNum) and I want the users to be able to use search for this Mtl Part Num on the right click.
I tried the following:
1) Created a BAQ that will bring the data and it has this PartMtl.PartNum selected in the BAQ Search LIKE on the BAQ Search sheet.
2) On my Report Option field right click, Quick Search, press New and I see that
Context Key Like field gets filled in automatically with "BAQReportParam.field1".
3) Select the BAQ I created earlier and a Return column which matches the LIKE in the BAQ i.e. PartMtl.PartNum and on Save it gives me error message:
"The like table / field is not valid."
Q. what does it expect for the BAQReportParam.field1?
If I try adding a new quick search on any other object's field e.g. tracker I don't see this issue...
Any experience with achieving Search on a report Option field or suggestions?
Thanks in advance!
I tried the following:
1) Created a BAQ that will bring the data and it has this PartMtl.PartNum selected in the BAQ Search LIKE on the BAQ Search sheet.
2) On my Report Option field right click, Quick Search, press New and I see that
Context Key Like field gets filled in automatically with "BAQReportParam.field1".
3) Select the BAQ I created earlier and a Return column which matches the LIKE in the BAQ i.e. PartMtl.PartNum and on Save it gives me error message:
"The like table / field is not valid."
Q. what does it expect for the BAQReportParam.field1?
If I try adding a new quick search on any other object's field e.g. tracker I don't see this issue...
Any experience with achieving Search on a report Option field or suggestions?
Thanks in advance!