Skip to main content

I need to use a filter in my extraction, but the field in the table I'm bringing it from has a separate name "Date Archived" Example.

When I use it like this "Date Archived" >= '2024-01-01 00:00:00', it doesn't load, I believe it's because of the space between the column name. Does anyone know how to solve this?

I've tried to put the column as a parameter, but I still can't.

 

Hi ​@douglas.souza

Do you see the error message when you press the ‘open logs’ button? 

An alternative error could be that you are mixing numeric comparison (‘>=’) with a string statement (date between single quotes), that throws a data type error. 

Best regards,

Jan-peter


Hi ​@janpeter.van.d, yes this type of error appears:

 


Interesting. You put the column with the space in it within double brackets (how is should be), but these double brackets are not used in the generated SQL statement. I would open a ticket for this. 

 

Best regards,

Jan-peter


Hi ​@douglas.souza

Perhaps two things to try in the meantime : 
 

  • Use time filter : Try applying your filter using  the time filter section (if available) and see what syntax appears there in the logs in the preview. You can then potentially apply this in the normal filter area afterwards. 
  • Add table name in front of field name: Many marketplace extractions use this type of syntax in filters  e.g. ADRP.DATE_FROM >= <%=startDate%> AND ADRP.DATE_FROM <= <%=endDate%>. So perhaps adding the table name in front of your field, all with double quotes, could help. 

Best

William


Hello everyone, thanks for your contribution. table.column solution, just as Willian suggested.


Reply