Prefilters Query Type Issue

[teoyh]

In one of my list I had added the following prefilter;

Join : Where
field : codeno
Condition : In
Value : select substring(sapno,3,8) from employee
Type : Query
Apply : Registered

But I the following error;

You have an error in your SQL syntax;
....
FROM `attendance`
WHERE (attendance.codeno IN (select substring(sapno,'3','8) from stm_employee') ) LIMIT 0, 10

Any reason why substring cannot be used ?

 

[troester]

Are you sure
select substring(sapno,3,8) from employee
this is exactly what is in your "Value"?

 

[cheesegrits]

Confirmed this one. It's in our "defensive" coding that attempts to make sure certain structures are quoted.

Working on it.

-- hugh

 

[cheesegrits]

Should be fixed as of this commit:

https://github.com/Fabrik/fabrik/commit/4e63ad6eae85c2abeb0fa0e7d7d0cd28d2414138

-- hugh

 

[teoyh]

Super appreciate your prompt action , I am doing a migration from an super old joomla and Fabrik to the new Joomla and Fabrik and I had experience awesome features in the new version of Fabrik.

Thank you so much for all the time and effort.

 

[cheesegrits]

Feel free to express your gratitude in the form of a Pro sub for a month.

-- hugh

 

[teoyh]

Done as per your request hahaha, hope that will make your day

 

[cheesegrits]

Well, it'll get me a tank of gas.

Thanks.

-- hugh