LIKE ? USED IN QUERY

[Former Member]

Hello Experts,

I am very new to this Esourcing and was going through the Help document for Query Definition. I came across the syntax in the query as Alias.Tablename LIKE ? and sometimes Alias.Tablename = ?. Kindly help me in undestanding what is that Like and ? used for and what is the purpose of it.

Can I also get any link showing different syntax that can be used while writing the query.

Thanks,

rythm

[vikram_shanmugasundaram]

Hi Rhythm,

The LIKE condition is standard SQL that allows you to use wildcards in the where clause. In your example, you say u201CAlias.Tablename LIKE ?u201D. Note, the LIKE condition is used in the where clause and not in the from clause.

? is a Sourcing specific and is a placeholder for the filter parameter. Depending on which version of Sourcing you are on, the usage is different. My suggestion would be look at the help section which explains this very well.

Hope this helps.

Regards,

Vikram

[Former Member]

Hello Vikram,

I am using Sourcing 7.0 version.

I have one more question. If I need to add one filter prompt, do i need to add it in the result set definition or just in the query.

Thanks,

rythm