Search found 38 matches
- 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!
- 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?
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?
- 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
https://www.loom.com/share/fdf2bcc24ecf ... b223384c47
Log is attached
- 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...
- 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...
- 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.
- 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...
- 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...
- 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 ...
- 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.
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.