Jump to content


larasmith

Member Since 04 Jul 2014
Offline Last Active Feb 12 2020 05:33 AM
*****

Topics I've Started

setRelation Where Condition (Input Statement) doesn't work at v.2.7.9

12 September 2019 - 06:08 AM

Dear @web-johnny,

 

 
Hi there! I observed that the setRelation Where Condition (Input Statement) doesn't work anymore at v.2.7.9.
My code goes something like this:
$crud->setRelation('el_CourseId', 'set_course', '{course_Title} - [{course_RefNo}]', ["set_course.course_Id = '1522' OR set_course.course_Id = '1519'"]);

The old versions support this type of where condition. I need this feature because I need  an "OR" operator on one field that I am selecting data from.

 

The error displayed was:

 

 upload.png

I also tried putting parenthesis in my code so it becomes like this:

$crud->setRelation('el_CourseId', 'set_course', '{course_Title} - [{course_RefNo}]', ["(set_course.course_Id = '1522' OR set_course.course_Id = '1519')"]);

but the same error occurs. This is a major issue for the system that I am currently working now.

Is this a bug? If it is, then I hope it will be fixed soon. If there's a workaround, kindly teach me on how to do it.

 

Thank you very much and more power! 

:)

 

 


Field type Hidden Not working in Grocery CRUD Enterprise v.2.7.4

10 June 2019 - 03:11 AM

Hi Everyone!

 

I would like to ask if you experience using fieldtype hidden and notice if it is functioning or not? See my sample below:

 

$crud->fieldType('fld_Name','hidden');

 

That API supposedly hides the specified field but now it does nothing in GroceryCRUD Enterprise v.2.7.4 

 

Thanks in advance!

 

-Lara

 

 

 


Filter Bugs in v.2.6.10

10 January 2019 - 03:39 AM

Hi there @web-johnny!

 

I got several findings regarding v.2.6.10. I hope these get fixed:

 

1. Applying multiple filters and then sorting the result removes the filters applied. Refer to the image below:

Q1-Sorting-Resets-Filters.png
 
 
2. A float field (in my case Grade) has different criteria from integer so I cannot filter the field using the criteria: greater than, less than etc. refer to the image below:
Q2-Float-Criteria.png
 
 
3. I tried exporting the records by clicking export and upon opening the excel file generated this error occurs:
Q3-Exported-Data-Corrupted.png
 
 
4. Since I have many records (4671 to be exact), upon clicking print, I noticed that it only printed almost 500 records and upon clicking export, I noticed that it only exported 1000 records. I saw in the forum: https://www.groceryc...g-1000-records/ I tried it and it works. I also tried it in PrintState and modified const MAX_AMOUNT_OF_PRINT = 500; to 10000. It also worked but the output table has no lines. Refer to the image below:
Q4-Table-Lines-Missing.png
 
 
5. Also, if I applied filters, I noticed that during print and export, all the records are still displayed and not the filtered results. Refer to the image below:

Q5-Filter-Failed-During-Printer.png

 

I do hope these issues get fixed. Thanks for the support! 


Bugs in Displaying setRelation Field when Showing More Than One Field in v.2.6.10

09 January 2019 - 03:01 AM

Hello Sir Johnny!

 

Happy New Year! I just went back to programming and applied the version: 2.6.10. I have the following setRelation code:

$crud->setRelation('vdr_Course', 'set_course', '{course_Title} [{course_RefNo}]');

I noticed that the data displayed in the datagrid was the actual field and not the combined field just like the one displayed in the dropdown as I was trying to showing more than one field. Please refer to the image below:

set-Relation-display.png

 

Is this a bug? If so, I hope this gets fixed immediately. The users may get confused if this is not fixed.