Search found 1034 matches

by onoehring
2021-10-08 05:32
Forum: Getting Started
Topic: Filter by selected in table view
Replies: 7
Views: 398

Re: Filter by selected in table view

Hi,

try to save the querywhere in a session variable. If the session variable is set just filter.
But make sure, that you/the user can clear this variable if needed ;-)

Olaf
by onoehring
2021-10-08 05:31
Forum: Tips And Tricks
Topic: Audit Log
Replies: 111
Views: 90365

Re: Audit Log

Hi,

I think this has not been reported as a bug. Maybe you want to do so (viewforum.php?f=11)?

Olaf
by onoehring
2021-10-07 06:26
Forum: Bugs/annoyances
Topic: 5.97 insert sometimes (!) fails
Replies: 0
Views: 150

5.97 insert sometimes (!) fails

Hi, I have a simple table....sometimes (I did not notice before) it's not possible to add a new entry even though it should be no problem. Please see the attached images for table definition and AG error. Unfortunately I can not say, what makes AG allow the addition and what breaks adding the new re...
by onoehring
2021-10-06 09:47
Forum: Tips And Tricks
Topic: How to Open a New Blank Page when Clicking on a Record?
Replies: 1
Views: 158

Re: How to Open a New Blank Page when Clicking on a Record?

Hi Mohamed, you could do two things a) remove all "base"-links in the tableview. This would require either 1. changing the base file AG uses to generate the tables layout (probably in /templates/tablename_TemplateTV). Be aware, that this file will be regenerated, once you (re)generate your app. You ...
by onoehring
2021-10-06 07:05
Forum: Getting Started
Topic: auto insert query in function table_init()
Replies: 5
Views: 154

Re: auto insert query in function table_init()

Him

just an idea.
I have not seen "$db->autocommit(FALSE);" yet.
So you turn off autocommit, and turn it on later on again - ok ... but do you commit your SQL at some point in between?
I can not find any command that looks like you do.
Thus - as you do not commit, no SQL is executed ;-)

Olaf
by onoehring
2021-10-06 06:59
Forum: Tips And Tricks
Topic: Audit Log
Replies: 111
Views: 90365

Re: Audit Log

Hi,

I, sometimes, experience the same problem, but I don't think it's connected to the AuditLog.
What makes you think it is?

Olaf
by onoehring
2021-09-28 15:53
Forum: Tips And Tricks
Topic: Create Multiple Records in a Table from one form
Replies: 4
Views: 754

Re: Create Multiple Records in a Table from one form

Hi, as pbötcher wrote: use the /hooks/tablename.php -> after_update function to a) read the entry from the database that has just been created. For this you use the $Selected_ID variable that AG provides in that function. Something like this (pseudo code): $record = sql("select * from yourtable wher...
by onoehring
2021-09-26 08:09
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 582

Re: URL length limitation to filter records

Hi, POST can be used from a from in direct exchange with the server. GET can be used to create bookmarks and links that can be exchanged. For your purpose, sending someone a link you are forced to use GET .... but ... you can make AG transform this and handle it yourself: a) create a short link and ...
by onoehring
2021-09-26 08:02
Forum: Getting Started
Topic: unread or new records count on home page.
Replies: 5
Views: 266

Re: unread or new records count on home page.

Hi, thank you Jan for your very nice explanation. Yes, using a count in the menu, by simply adding the code to the /hooks/links-navmenu.php is very easy. You can simply pull the requested value using SQL directly from the database and show it next to the navigation. Nevertheless, I am using both met...
by onoehring
2021-09-25 08:12
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 582

Re: URL length limitation to filter records

Hi,

just an idea: You could also build yourself an URL shortener into you application. A simple table that connects a short string with the full URL. Then, check if a shorturl is given and return the long.

Olaf
by onoehring
2021-09-25 08:10
Forum: Advanced Customizations > Hooks
Topic: SingleEdit: Prevent concurrent edits on records.
Replies: 13
Views: 1271

Re: SingleEdit: Prevent concurrent edits on records.

HI itlow,

I had no time to check yet. I downloaded your files. When I find time, I will look into it. I might wait until AG 6.0 is released though.

Olaf
by onoehring
2021-09-21 06:10
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 582

Re: URL length limitation to filter records

Hi,

please explain what you are trying to do. Maybe this way we can find a solution.
The document describes a workaround. Probably you could send come cryptic data using GET and do some stuff according to your cryptic data ... but that's poking in the dark, so: What are you trying to do?

Olaf
by onoehring
2021-09-16 05:31
Forum: Advanced Customizations > Hooks
Topic: SingleEdit: Prevent concurrent edits on records.
Replies: 13
Views: 1271

Re: SingleEdit: Prevent concurrent edits on records.

Hi peebee, did you consider adding a extra column(s) to a record where you save a locking information? Like person who locked and timestamp? This way it should be quite easy to check in the _init / _before_update if this/these column(s) have a value, and if do some other checks (like: _init: disable...
by onoehring
2021-09-15 14:59
Forum: Getting Started
Topic: Items Per Storage Location
Replies: 7
Views: 340

Re: Items Per Storage Location

HI,

you are welcome and thank you for reporting back

Olaf
by onoehring
2021-09-15 08:18
Forum: Advanced Customizations > Hooks
Topic: SingleEdit: Prevent concurrent edits on records.
Replies: 13
Views: 1271

Re: SingleEdit: Prevent concurrent edits on records.

Hi peebee & ltlow thanks for your replies. I will take a look at the code and try to fix it. I am happy for all feedback as we are all working to make AG even better. I believe it was Jan who has already written about all problems with row locking in a browser based environment in this forum. I am n...
by onoehring
2021-09-15 08:05
Forum: Getting Started
Topic: Items Per Storage Location
Replies: 7
Views: 340

Re: Items Per Storage Location

Hi,

just create a "dummy table" with the name of the view. AG will access the data that is available in the view as it would be the table. Of course, you can not add to that "table" in AG ;-)

Olaf
by onoehring
2021-09-13 15:22
Forum: Getting Started
Topic: Items Per Storage Location
Replies: 7
Views: 340

Re: Items Per Storage Location

Hi, I am not sure if I understand you correct. You should check the MySQL "if" function (https://www.w3schools.com/SQl/func_mysql_if.asp and https://www.mysqltutorial.org/mysql-if-statement/). Once you have, you should be able to multiply the quantity by +1 or -1 (depending on "incoming" / "outgoing...
by onoehring
2021-09-13 13:21
Forum: Advanced Customizations > Hooks
Topic: SingleEdit: Prevent concurrent edits on records.
Replies: 13
Views: 1271

Re: SingleEdit: Prevent concurrent edits on records.

Hi,

what you mean by "data corrupted"?
Did you follow the installation instructions?

Olaf
by onoehring
2021-09-09 17:04
Forum: Advanced Customizations > Others
Topic: SQL query other than "case when...then"
Replies: 2
Views: 279

Re: SQL query other than "case when...then"

Hi, try something like this (pseudo code) $sql = "select category from tableB where min <= " . $value . " AND max >" . $value . ";" $result= sqlValue($sql) PS: You need only min or max in your table, as the other one automatically is pure logic - your SQL will probably get more complex PSPS: You sho...
by onoehring
2021-09-09 05:23
Forum: Tips And Tricks
Topic: I want the user to access the tables just by entering their password.
Replies: 1
Views: 178

Re: I want the user to access the tables just by entering their password.

Hi,

since you can use htaccess .. I do not understand why you don't use htaccess and simply disable the member login in AG:
Zwischenablage01.png
Zwischenablage01.png (87.17 KiB) Viewed 146 times
Olaf
by onoehring
2021-09-04 05:44
Forum: Getting Started
Topic: Changing table group appearance
Replies: 8
Views: 403

Re: Changing table group appearance

Hi,

in my application I do not have a home-custom.php

OLaf
by onoehring
2021-09-02 14:27
Forum: Getting Started
Topic: Changing table group appearance
Replies: 8
Views: 403

Re: Changing table group appearance

Hi, thanks for the detailed explanation. I want to give a short answer only: This is not possible (afaik) with AG settings. I believe you will need to change /home.php - but - this file is generated when generating your application and you would need to change it again. You might also be able to cha...
by onoehring
2021-09-01 18:00
Forum: Advanced Customizations > Hooks
Topic: Email sent to each message
Replies: 3
Views: 265

Re: Email sent to each message

Hi,

take a look at the /admin/incFunctions.php, function sendmail. Utilize this in the /hooks/tablename.php -> after_insert (and/or after_update) function.

Olaf
by onoehring
2021-09-01 17:56
Forum: Advanced Customizations > Others
Topic: QR code generator
Replies: 1
Views: 174

Re: QR code generator

Hi, I would suggest looking at this: https://github.com/kreativekorp/barcode The software can generate QR and provides an example for this. As you are asking in "Advanced customization" I suppose you will be able to incorporate this ;-) I would think you will need to place code in the hooks/tablenam...
by onoehring
2021-09-01 17:52
Forum: Getting Started
Topic: Changing table group appearance
Replies: 8
Views: 403

Re: Changing table group appearance

Hi,

AG main page:
Zwischenablage01.png
Zwischenablage01.png (17.44 KiB) Viewed 389 times
Olaf