Cannot assign Reports, Forms, Procedures to a RUN object

oli · Unread post by **oli** » Tue Jun 01, 2021 12:05 pm

Helllo,

I'm facing following issue:
When I try to assign a report, form or a procedure to any RUN object I cannot select anything (of course there are many reports and forms available).

Screenshot 2021-06-01 115741.jpg

This behaviour occured after importing the complete database.
It's strange that it's still possible to use already defined reports and forms but I cannot see the assigned report or form on the RUN object!

Can someone help me please? I don't see any errors in nuDebug or in the console.

Thanks in advance!

BR,
Oli

Unread post by **kev1n** » Tue Jun 01, 2021 12:10 pm

Do the 3 nuBuilder views exist in the db?

oli · Unread post by **oli** » Tue Jun 01, 2021 1:21 pm

You are right . 3 Views are missing :
zzzzsys_run_list
zzzzsys_report_data
zzzzsys_object_list

Is there any way to re-build the views or do I have to import an older state?

Unread post by **kev1n** » Tue Jun 01, 2021 1:46 pm

Check out nubuilder.sql. Extract the 3 view generation statements (CREATE VIEW ...) and run them in e.g. phpMyAdmin.

oli · Unread post by **oli** » Tue Jun 01, 2021 2:52 pm

Thank you so much! That helps.

nuBuilder Forum

Cannot assign Reports, Forms, Procedures to a RUN object

Cannot assign Reports, Forms, Procedures to a RUN object

Re: Cannot assign Reports, Forms, Procedures to a RUN object

Re: Cannot assign Reports, Forms, Procedures to a RUN object

Re: Cannot assign Reports, Forms, Procedures to a RUN object

Re: Cannot assign Reports, Forms, Procedures to a RUN object