Jump to content


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:



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:




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


Thanks in advance!






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:

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:
3. I tried exporting the records by clicking export and upon opening the excel file generated this error occurs:
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:
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:



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:



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