Re: [libreoffice-users] Re: Can I reload a form based on a parameter query?

Howdy Peter,

I'm only a user of the software. Anyone can request a change and it is
pretty easy to do.
Likely getting one of the developers to want to code it will be a bit more
of a trick, but there is a process and if no one ever enters a request it
certainly won't happen.

Just in case:
- the project uses a ticket system called Bugzilla to track defect reports
and enhancement requests found at https://bugs.documentfoundation.org
- you don't need to create an account in that system if all you want to do
is view what is in the works, but you will need to create one to open a new
request or report a bug.
- there is an explanation of the bug entry process here:
https://wiki.documentfoundation.org/QA/BugReport
--  for an enhancement the only difference is enter a severity level of
'enhancement'

Anyway, I haven't said boo here in a long while but recently have been
looking at the issue tracker and I noticed that there is some talk of
adding a 'search and replace' feature for Base which is what got me
thinking it might be a good moment. On the other hand there is a big push
to finish up the support for a different db engine so an RFE might get lost
in the noise of that..

But hey it sounds like a good idea and if you want to start the process
great, if not, I just might..

Best wishes,






On Sat, Jan 28, 2017 at 5:37 AM, ptoye <LO@ptoye.com> wrote:

> Hi Drew,
>
> I'm very happy to hear that Base is being worked on. It's always struck me
> as the Cinderella app in the suite.
>
> Would you like me to issue a RFE or will you do it yourself?
>
> IMHO, even more important than this would be Update and Delete queries.
> It's been decades since I used MS Office, but I remember them as being
> available in about 2000. And very useful as one doesn't have to learn SQL.
>
> Best regards,
>
> Peter
> mailto:lo@ptoye.com
> www.ptoye.com
>
> -------------------------
> Friday, January 27, 2017, 5:43:50 PM, you wrote:
>
>
> howdy,
>
> Ah, considering that the project is actively working on the Base module at
> the moment this might be a great time to open a Request For Enhancement.
> In this case a request to add a ReloadWith (for example) function on the
> data set (form) which would reload the data using the current parameter
> variables entered on the initial load.
>
> Just a thought and it couldn't hurt. I think your use case is common enough
> that merits a discussion at least.
>
>
> On Fri, Jan 27, 2017 at 10:21 AM, ptoye <[hidden email]> wrote:
>
> > Hi Robert,
> >
> > I've had a look at some of your forms now, especially
> > filter_without_macros and I'm a bit puzzled. I see that the table in the
> > Display part of the form is populated by the "filterquery" query, which
> > references "filter". The table "filter" has one entry - the selection(s)
> I
> > made in the listbox. But I can't see how the listbox selections get put
> > into the "filter" table. Can you please help me there? I also can't
> > understand why there are two columns in the "listbox_n_simple", but
> that's
> > of less importance.
> >
> > Best regards,
> >
> > Peter
> > mailto:[hidden email]
> > www.ptoye.com
> >
> > -------------------------
> > Tuesday, January 24, 2017, 4:47:52 PM, you wrote:
> >
> >
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Hi Peter,
> >
> > have a look here:
> > http://robert.familiegrosskopf.de/lo_hb_en/Example_Search_and_Filter.odb
> >
> > You don't need anything elese but a form and a subform. The example
> > includes different forms, some of them working without any macro.
> >
> > Regards
> >
> > Robert
> > - --
> > Homepage: http://robert.familiegrosskopf.de
> > LibreOffice Community: http://robert.familiegrosskopf.de/map_3
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v2
> >
> > iQIcBAEBAgAGBQJYh4UDAAoJELDKYwaoS9AIy1oP/R1xM/+twczhn62h/pW5zO0k
> > bUmslOk2lYV6kkAQmFi3XoW6AMt9hr4sFsmPuJ0CB3eSsNl/T3OdA+h4BZRMah5N
> > huQJkY2WrjiKFda94TXlqKUG4NgFvJ5Gl1PL7DK/3hi4NMLS/kDbpJcvzto9LM3q
> > alJi9rZfq6IZ3Cdq198l+biawMxJ7DbDxfzynx6G8x59G89rmA3iBs67jP2ZRYpL
> > SNuOZYLE/FCmseqktrkbS5BBgANckb37uh89sTh3XSe3OXGTQkzel+51ndky7Qs6
> > rUbRReaG6+JFgl883mzIDroSsQjcJyQk+sapv53P8OkUiMhyUPvT1KdrUDdVTIOQ
> > gJzPyo8EqXtvajmf2xe5O9zTirR0XZfca1KdtdbVjFv4iTZRgW93HWzwnwGl48W3
> > q8qdRz++FmskI0J3zxE6LbL0ff3bf1LDsaa1vub+IKIzOhDGZ1Lf+Q7U15vx5eBd
> > hexDVCgvu1suiDtJ9rh95IZcyEHFk6BBAOokE97hpbwjlfBsLMlluJ6etsNDYxwa
> > 3gozscxhLkzQpFAopp+76MxlI39/ktrCFgUGQfTBajj/74Dfvf1j0dQwoYh41fz5
> > JFeDTm/YN4ZRsw7BEvE+FQuOoG08F5v02DesZ+2+8euA3hVMynb/PQI47o024WDd
> > ILXQuH+aT+/Mas+L4BdB
> > =zULF
> > -----END PGP SIGNATURE-----
> >
> > --
> > To unsubscribe e-mail to: [hidden email]
> > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> > unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
> >
> >
> > If you reply to this email, your message will be added to the discussion
> > below:
> > http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> > parameter-query-tp4206066p4206117.html
> > To unsubscribe from Can I reload a form based on a parameter query?,
> click
> > here.
> > NAML
> >
> >
> >
> > -----
> > Peter
> > --
> > View this message in context: http://nabble.
> documentfoundation.org/Can-I-
> > reload-a-form-based-on-a-parameter-query-tp4206066p4206363.html
> > Sent from the Users mailing list archive at Nabble.com.
> > --
> > To unsubscribe e-mail to: [hidden email]
> > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> > unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
>
> If you reply to this email, your message will be added to the discussion
> below:
> http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-
> parameter-query-tp4206066p4206380.html
> To unsubscribe from Can I reload a form based on a parameter query?, click
> here.
> NAML
>
>
>
> -----
> Peter
> --
> View this message in context: http://nabble.documentfoundation.org/Can-I-
> reload-a-form-based-on-a-parameter-query-tp4206066p4206418.html
> Sent from the Users mailing list archive at Nabble.com.
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted