SAP Business One - Query Generator

[former_member391531]

SAP B1 9.2 PL7

If you use query generator to create a query, save & execute a new query. (works well)

Then at later date you need to edit some of the fields on that query. Is there any way to reload it back into the query generator so you can use that to select the fields you want to add or remove?

A user can manually edit the sql script itself in the Query manager by adding or removing fields but some users do not want to do this if possible.

[kothandaraman_nagarajan · Accepted solution]

Hi,

No way to load saved query in query generator again to modify the query. Recreate same query from scratch with additional tables/fields.

Regards,

Nagarajan

[former_member391531 · Accepted solution]

Thanks for responding Nagarajan, appreciate the reply.