Page 2 of 3
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 12:57 pm
by kev1n
Inspect the Browse SQL of your embedded Browse form with the developer console to verify that it gets updated and the syntax is correct.
browse_sql.png
I created a "Browse Filter" demo at
https://test.nubuilder.cloud/
Login credentials (Admin rights in Demo Mode)
User: test
Password: nutest
User Home -> "Browse Filter"
for reasons of simplicity, I use strings for the departments (Department1, Department2) rather than Ids and Pks, Fks.
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 2:15 pm
by kknm
I realized how far we do not understand each other
)
In your example, you do this on an EditForm, but I created an empty form on the 'Report with criteria' form as in the nuBuilder tutorial and of course I don't have an EditForm.
The fact is that I have a program in my office that collects data from all offices and uploads data to the database when the equipment changes. But I still need to maintain all this peripherals and, in addition to this data, keep service magazines based on 'departments', 'computers', 'printers', etc. ... I do not change anything in these directories, so I do not need to edit them - just Keep a log using their data. Now, as I understand it, I need to create magazines (BrowseAndEdit) and carry out all the manipulations in them. This is a little different ... I would like to first have an overview of all peripherals and choosing either 'Department', 'Computer', or 'Any device' to do further operations in different magazines by type of equipment.
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 2:17 pm
by kev1n
If you don't have an Edit Form, what is it then? My example also works on a Launch form.
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 2:23 pm
by kknm
kev1n wrote:If you don't have an Edit Form, what is it then? My example also works on a Launch form.
I do not see any objects and forms on your form, except for an empty table with the headers 'text' and 'select'.
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 2:25 pm
by kev1n
I see this when I log in with the test user:
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 2:36 pm
by kknm
I saw it ... But before that you need to click the Add button to get into the EditForm.
I don't have this button ...
wind.png
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 2:38 pm
by kev1n
You can turn this Edit/Browse form into a Launch form. Let me do it...
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 2:39 pm
by kev1n
It's now a Launch form.
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 3:03 pm
by kknm
Now I figured it out - the id of the form 'Departments' ('fltr') matched the filter in SQL for 'Computers'
Code: Select all
SELECT
COMPUTERS.*
FROM
COMPUTERS
WHERE
((DEPARTMENT_ID ='#fltr#'))
Thanks !!!!
Re: Show several functional directories on the form
Posted: Wed Mar 24, 2021 3:14 pm
by kknm
Everything works, but for some reason it writes in the debugger:
VM11788:5 Uncaught ReferenceError: iniFrame is not defined
at <anonymous>:5:1
at b (jquery.js?ts=20210324170715:2)
at Pe (jquery.js?ts=20210324170715:2)
at S.fn.init.append (jquery.js?ts=20210324170715:2)
at nuAddJavascript (nuform.js?ts=20210324170715:3416)
at nuBuildForm (nuform.js?ts=20210324170715:189)
at successCallback (nuajax.js?ts=20210324170715:117)
at Object.success (nuajax.js?ts=20210324170715:17)
at c (jquery.js?ts=20210324170715:2)
at Object.fireWith [as resolveWith] (jquery.js?ts=20210324170715:2)