Page 1 of 1

Cannot assign Reports, Forms, Procedures to a RUN object

Posted: Tue Jun 01, 2021 12:05 pm
by oli
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

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

Posted: Tue Jun 01, 2021 12:10 pm
by kev1n
Do the 3 nuBuilder views exist in the db?

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

Posted: Tue Jun 01, 2021 1:21 pm
by oli
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?

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

Posted: Tue Jun 01, 2021 1:46 pm
by kev1n
Check out nubuilder.sql. Extract the 3 view generation statements (CREATE VIEW ...) and run them in e.g. phpMyAdmin.

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

Posted: Tue Jun 01, 2021 2:52 pm
by oli
Thank you so much! That helps.