Search found 38 matches

by weitau
05 Sep 2021, 20:55
Forum: Discussion
Topic: Update issue
Replies: 5
Views: 404

Re: Update issue

I did not need to manually update from 2.7 to 2.8, but going from 2.8 to 2.9, I got the client ID error. All good now. Thanks to all!
by weitau
29 Sep 2020, 08:13
Forum: Bug Report version 2.7
Topic: Error deleting 25 records out of 10,100
Replies: 2
Views: 426

Re: Error deleting 25 records out of 10,100

Yes, this worked! Thank you Sergey!

I selected the Check all box, and I deleted all 10,000 records. Not what I was intending, but the database performance was pretty darn good!

There is no option to set the check all to only be the 25 records on the page, no?
by weitau
27 Sep 2020, 10:02
Forum: Bug Report version 2.7
Topic: Error deleting 25 records out of 10,100
Replies: 2
Views: 426

Error deleting 25 records out of 10,100

When I select 25 records out from the Tasks table containing over 10,000 records, my session crashed.

https://www.loom.com/share/fdf2bcc24ecf ... b223384c47

Log is attached
by weitau
27 Sep 2020, 09:23
Forum: Discussion
Topic: Filter not working
Replies: 3
Views: 427

Re: Filter not working

BTW, my entity type field is a drop down list that used the Global list. The Global list has index starting with 1. To use my Entity drop-down list (ajax), I used a LIKE expression because this field (Drop down multi-select) could have multiple values (e.g. "1,15,33"). But using LIKE would...
by weitau
27 Sep 2020, 09:12
Forum: Discussion
Topic: Filter not working
Replies: 3
Views: 427

Re: Filter not working

I'm also using this field for Entity drop-down list (ajax). It has no problems picking up all the investor records. It also has no problem when the table is used for reports. The only place where it appears that the filtering problem only exists if the table (being top level) is in the Menu. By savi...
by weitau
27 Sep 2020, 08:46
Forum: Discussion
Topic: Filter not working
Replies: 3
Views: 427

Re: Filter not working

If I edit the Investor record that were not found (Tesla here), remove the attribute, save, then add Investor back into it, then the record miraculously appears.
13 records with field_241 = 115
13 records with field_241 = 115
only 2 records appear in search
only 2 records appear in search
by weitau
26 Sep 2020, 10:27
Forum: Discussion
Topic: Filter not working
Replies: 3
Views: 427

Filter not working

This has me stumped. I have two records, both with the same value in the database myPHPadmin.png In the UI, I searched for "Investor" which in the Global list has the value 115 Entity type choice.png But only one of the records appear in the result. One record returned.png The only differe...
by weitau
18 Sep 2020, 06:11
Forum: Discussion
Topic: MySQL Query returns FK to Global List
Replies: 7
Views: 894

Re: MySQL Query returns FK to Global List

Yes, I understand your reasoning. Someone could mistype Country and you have data integrity issues. My suggestion was to have a new List type field store not the index value, but the actual lookup value itself. So the field dropdown allows the user pick France, and instead of storing an Integer valu...
by weitau
17 Sep 2020, 07:31
Forum: Discussion
Topic: MySQL Query returns FK to Global List
Replies: 7
Views: 894

Re: MySQL Query returns FK to Global List

SOLVED I think you have to use field type Formula where you create supquery to app_global_lists_choices table to get value that you need. Open phpmyadmin to check app_global_lists_choices table Thanks, I created the subquery as you suggested. I figured out that the MySQL Formula runs only on update ...
by weitau
17 Sep 2020, 06:54
Forum: Discussion
Topic: Portfolio Management Template
Replies: 1
Views: 269

Portfolio Management Template

Has anyone downloaded this template?

I thought it was something that a project management office would use, but it's pretty much worthless.
Full of tables that have just a few fields and relationships that don't make any sense.