Posted Fri, 13 Sep 2024 09:37:09 GMT by Miquel Sanz Vargas Técnico
I'm trying to get the supplier code ( from a FC that is not asigned to this Workflow ) using the following method (see attched file). 
I get nothing out of that, it doesn't return anything, like it's not comparing the GV and the index field. I've double-checked and the GV and the index field have the same value. 

Thanks in advance
Posted Tue, 17 Sep 2024 12:36:08 GMT by Gerardo Lisanti Team Leader Product Management
Hi Miguel,

The field DW_NOMBRE is probably a text field. Therefore, its value should be enclosed in single quotation marks, like this:
DW_NOMBRE = 'GV_Empresa'

Viele Grüße / With best regards,
Gerardo Lisanti
Posted Thu, 19 Sep 2024 08:48:19 GMT by Miquel Sanz Vargas Técnico
Thanks! That worked. 

But there's something else I want to ask you if you don't mind.

Instead of using "=" it would fit better using "like", sometimes the name isn't equal to the data in our database,  I've seen that you have to use "&" and "%". I've tried but I don't get anything but an error.
Posted Fri, 20 Sep 2024 13:07:29 GMT by Gerardo Lisanti Team Leader Product Management
Hi Miguel,

you have to provide the SQL WHERE clause in SQL Syntax.
So the correct syntax for a query using the LIKE operator is:
DW_NOMBRE LIKE '%GV_Empresa%'

See also: LIKE (Transact-SQL) - SQL Server | Microsoft Learn

Viele Grüße / With best regards,
Gerardo Lisanti

You must be signed in to post in this forum.