Sytax of pre-filter

[karlis]

Is my syntax correct for a pre-filter query:
SELECT * FROM vdc_amati
WHERE indekss BETWEEN 120 AND 190;
Have checked and doublechecked the variables. Table is correct, column is correct, but does it need to be vdc_amati.indekss?

 

[cheesegrits]

Are you trying to do an "IN" filter, like ...

Field: something
Condition: IN
Value: SELECT * FROM vdc_amati [... etc ...]
Type: Query

If so, then you need to select a single field, not *. Specifically, the field that you want to match "something" against.

Field: something
Condition: IN
Value: SELECT something FROM vdc_amati [... etc ...]
Type: Query

If you are matching against a join element, you would usually choose the "something (raw)" field option, which says to use the FK (the value), not the label of the field.

-- hugh

 

[karlis]

No I'm trying to find a range of numbers from (indekss) that are stored in (vdc_amati). Its not an join field. That's why I thought I want to use a BETWEEN x AND y. I tried grouping a greater than and less than, but the greater than and less than went on to include other operators in the prefilters.

 

[cheesegrits]

Not sure what you mean by "including other operators". If you append & fabrikdebug=1 to the url, and look at the getData query, what does the WHERE clause look like?

Sent from my HTC6545LVW using Tapatalk