Search found 55 matches

by sacgtdev
2021-11-14 04:34
Forum: Advanced Customizations > Hooks
Topic: Search Crashes when searching Views using global-search.php
Replies: 5
Views: 905

Re: Search Crashes when searching Views using global-search.php

Hi mohamed, I have similar objective as yours which is to allow user to view records which are inaccessible to them in the actual table. I think we can create the view for each table and edit the global-search.php where: /* get tables accessible by current user */ //$tables = getTableList(); //chang...
by sacgtdev
2021-10-08 05:04
Forum: Getting Started
Topic: Filter by selected in table view
Replies: 7
Views: 597

Re: Filter by selected in table view

Having querywhere set in hooks init, I am able to filter the record. But, if navigate from other page to the page that have querywhere set, the page will not load and require re-submission/refresh.
by sacgtdev
2021-10-08 00:18
Forum: Tips And Tricks
Topic: Audit Log
Replies: 112
Views: 92594

Re: Audit Log

I did the test before and after installation of audit log. However, I didn't meant that the flaw is from the audit log, it could be the conflict with existing setup. I will try on a fresh generated application using Appgini 5.97 (before and after) to confirm again.
by sacgtdev
2021-10-03 03:09
Forum: Tips And Tricks
Topic: Audit Log
Replies: 112
Views: 92594

Re: Audit Log

Hi, onoehring I am experiencing a little annoyance after install the audit log on Appginin 5.97. When I navigate to admin page after the first login attempt, it will return me to an login page again. I have to re-login in order to access the Admin page. May I know whether this is bug that ye to reso...
by sacgtdev
2021-10-02 02:44
Forum: Tips And Tricks
Topic: implement update_calc_fields in import csv
Replies: 0
Views: 170

implement update_calc_fields in import csv

How to implement update_calc_fields function in import-csv.php so that every record imported would have calculated field run automatically?
by sacgtdev
2021-09-28 08:11
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 777

Re: URL length limitation to filter records

Thank you for your kind suggestion.
by sacgtdev
2021-09-25 11:39
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 777

Re: URL length limitation to filter records

That should avoid the link send via email being truncated. A proxy link (shorter) to return the actual link (long). But, the long link will still limited by the browser url's length. I check on the https://youtu.be/7gMWoVh62wU?t=145. In appgini old version, it actually generate the POST form. May th...
by sacgtdev
2021-09-24 10:28
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 777

Re: URL length limitation to filter records

Hi, Oliveira. Can you elaborate more or give example/ any external reference? save query string on a temporary file - if it is temporary, that means it will not be persistent and access in future? request string on load with sessionStorage or localStorage - request strings is GET to the temporary fi...
by sacgtdev
2021-09-21 07:32
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 777

Re: URL length limitation to filter records

For example, I have constructed a url for a filtered records, as follows: http://localhost.com/abc_view.php?SortField=&SortDirection=&FilterAnd[1]=and&FilterField[1]=1&FilterOperator[1]=equal-to&FilterValue[1]=39&FilterAnd[2]=or&FilterField[2]=1&FilterOperator[2]=equal-to&FilterValue[2]=40&FilterAnd...
by sacgtdev
2021-09-20 02:10
Forum: Advanced Customizations > Others
Topic: URL length limitation to filter records
Replies: 9
Views: 777

URL length limitation to filter records

There is url length limitation: When the url was constructed and email to outlook, it tends to be truncated if length exceeded 2048. In addition, different browser also will put limitation on the url length. Is there any existing method in appgini, something like a POST method? I explore this https:...
by sacgtdev
2021-09-10 09:37
Forum: Advanced Customizations > Others
Topic: SQL query other than "case when...then"
Replies: 2
Views: 349

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

Thanks. Your suggestion work in php.

Just wonder how to implement this to the calculated field. As I now there is pesudo code for id, primary key and table..

but, how to custom a pseudo-code?
by sacgtdev
2021-09-09 13:38
Forum: Advanced Customizations > Others
Topic: SQL query other than "case when...then"
Replies: 2
Views: 349

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

Table A Value 3 How to do a sql query to assign 'medium' based on the value in the Table A? The category will be referenced from Table B. I can think of case when...then (hard-code) in the sql query. Is there any alternative way to write the query? Table B Category Min Max Low 0 2.99 Medium 3 4.99 H...
by sacgtdev
2021-08-25 04:09
Forum: Getting Started
Topic: How? Filter (or search?) table by click on cell
Replies: 13
Views: 1980

Re: How? Filter (or search?) table by click on cell

I think if using the same id columns for filtering multiple ids, it has to use 'OR' instead of 'AND".

Is there a limitation on url length? max is how many characters?
by sacgtdev
2021-08-04 08:57
Forum: Getting Started
Topic: How? Filter (or search?) table by click on cell
Replies: 13
Views: 1980

Re: How? Filter (or search?) table by click on cell

I have a slightly difference question.

Is there a way to encode a permalink for multiple ids?

something like filter with ids in {1,2,4,5,7}
by sacgtdev
2021-08-03 00:03
Forum: Bugs/annoyances
Topic: CSV import thousands records (bugs)?
Replies: 0
Views: 302

CSV import thousands records (bugs)?

I have using csv import for thousands of records. Below is my observation: 1) the data import quickly into the table as it was observed the data have already loaded into the db table even the process not complete yet. 2) the process of registering membership_userrecords takes much longer time. It to...
by sacgtdev
2021-08-02 23:41
Forum: Tips And Tricks
Topic: Audit Log
Replies: 112
Views: 92594

Re: Audit Log

I have test in other environment and it works fine. The audit log menu appeared at top right.

Thank you.
by sacgtdev
2021-07-24 00:41
Forum: Bugs/annoyances
Topic: After import csv, error message Sorry! You don't have permission to access this table. Please contact the admin.
Replies: 0
Views: 194

After import csv, error message Sorry! You don't have permission to access this table. Please contact the admin.

I am experiencing this:

After import csv data, error message turn up 'You don't have permission to access this table. Please contact the admin.'

I was logged-off by the system.

May I know is this still the bug?

Regards,
Stephen
by sacgtdev
2021-07-22 07:33
Forum: Getting Started
Topic: Lookup field, advanced SQL edit, memberInfo
Replies: 12
Views: 3733

Re: Lookup field, advanced SQL edit, memberInfo

May I ask whether the placeholder %%memberID%% in the advanced lookup query is workable?

Is there any other type of placeholders?

Code: Select all

 SELECT ... WHERE `addresses`.`Username`=%%memberID%% ORDER BY 2
by sacgtdev
2021-07-18 14:07
Forum: Bugs/annoyances
Topic: CSV import and lookup field contradict each other [5.97]
Replies: 1
Views: 177

Re: CSV import and lookup field contradict each other [5.97]

My temporary solution is :


include incFunctions.php in lib.php

create the following files in hooks:
import_csv.php
//create custom function for $transformFunctions

incFunctions.php
//create custom function for lookupQuery and pkGivenLookupText
by sacgtdev
2021-07-18 09:43
Forum: Bugs/annoyances
Topic: CSV import and lookup field contradict each other [5.97]
Replies: 1
Views: 177

CSV import and lookup field contradict each other [5.97]

I am trying to do csv upload for fields with cascading drop down. Advanced sql appended to the default: WHERE `tablename`.`field` = '1' // added before ORDER BY 2 -> the form entry still working The csv import not able to load the correct id from the primary table. Query log display the SQL syntax e...
by sacgtdev
2021-07-10 10:44
Forum: Bugs/annoyances
Topic: Print Preview- table view (show all records)
Replies: 1
Views: 228

Re: Print Preview- table view (show all records)

It is not a bug. Just filter the records before print preview.
by sacgtdev
2021-07-10 06:11
Forum: Tips And Tricks
Topic: Audit Log
Replies: 112
Views: 92594

Re: Audit Log

I would like to just share my own experience, despite encounter some clichés, but the overall audit is still functional. After plugin installation: I discovered that the menu was not showed up then I have to manually add it in the 'admin/incHeader.php' as shown in documentation pg. 11 section 3.2 I ...
by sacgtdev
2021-07-10 04:20
Forum: Tips And Tricks
Topic: Hide fields select box
Replies: 8
Views: 1550

Re: Hide fields select box

This code shall works at header-extras.php <script> \$j(function() { if (localStorage.getItem("columns-contact_view") === null){ const field = {"contacts-department_id":true,"contacts-name":true,"contacts-email":false,"contacts-phone":false} window.localStorage.setItem('columns-contact_view', JSON.s...