⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Disable dropdown in search filters and change to text input



Indeax

Indeax
  • profile picture
  • Member

Posted 26 November 2018 - 21:59 PM

Hello,

 

I have just purchase grocerycrud enterprise and started to migrate from opensource version.

 

I found an small issue, when I set a relation from a field id to another table, the referenced table can have a lot of records (in this cade more than 100mil) so the list page can be really slow because the dropdown searchable on column.

 

The select filter is a nice feature but in some case it have to be disabled because performance problems. I have not found an options to change it to text input without select like in open source version. There is a way to do it ?

 

Thanks.

 


Indeax

Indeax
  • profile picture
  • Member

Posted 27 November 2018 - 08:33 AM

Hello,

 

I also see that "setRelation" don't have "where" option like on free grocery version.

 

Some times the user need to see only a small portion of related entries. This and the select filter on column with "all" entries are a really privacy problem and limit the multiuser/privileges operations with grocery enterprise that can be done easily with free version.

 

Please, can you give a solution for this like on free version ?

 

Thanks for you work.


larasmith

larasmith
  • profile picture
  • Member

Posted 29 November 2018 - 00:27 AM

Hello,

 

I also see that "setRelation" don't have "where" option like on free grocery version.

 

Some times the user need to see only a small portion of related entries. This and the select filter on column with "all" entries are a really privacy problem and limit the multiuser/privileges operations with grocery enterprise that can be done easily with free version.

 

Please, can you give a solution for this like on free version ?

 

Thanks for you work.

 

Hi! There is "where" condition for setRelation.

Kindly check this: https://www.grocerycrud.com/enterprise/api-and-function-list/setRelation


Indeax

Indeax
  • profile picture
  • Member

Posted 30 November 2018 - 08:31 AM

Hello larasmith,

 

thanks, I see now the where clause on setRelation function. This is ok. But the problem with the "huge" select on relational tables persist. Moreover, now it's not possible to filter relational fields with a containing string has before.

 

This was a really important feature on free version + bootstrap theme that is not possible to do now.

 

Please take in considerations this feature for future releases.

 

Thanks.