[Mohammad Abu Musa]

Hello Everyone, I have this query I want GroceryCRUD to show it only with search and navigation without editing or deleting how can I archive this   

 

SELECT * 

FROM local_call_log LEFT JOIN provider_call_log ON local_call_log.eventdate = provider_call_log.eventdate

WHERE (

IF(provider_call_log.id IS NOT NULL ,(TIMEDIFF( local_call_log.eventtime, provider_call_log.eventtime ) <90

AND TIMEDIFF( local_call_log.eventtime, provider_call_log.eventtime ) > -90

AND provider_call_log.EventDate = local_call_log.EventDate), 

TRUE)

AND local_call_log.HeroNumber = 8585855858588

)

 

 

is it possible to be done with it?

[jinbatsu]

Hello,

 

If you want use grocerycrud with a complex query like that, and only use for searching.

It is better if you use create view in your MySQL.

Then, just unset_add and unset_edit.