Error in Template Functions

[caiolul]

Error in Template Functions

[arxdsilva]

Hi @caiolul , thanks for reporting, this is a valid problem that we dont solve right now. From what I can see in the code, we've opted to support queries only with this format:

https://.../_QUERIES/<folder>/<query>?field=<value1>&field=<value2>

As is said in this article, the RFC 3986 talks that web servers could have both the previous cited implementation and field=val1,val2 working, but neither are mandatory. Although I believe that having both working is great for us, so we definately should have it implemented in the future in prestd.

Thank you for reporting this, I'll keep this open so we can track this fix.

[vmesel]

@arxdsilva I'm going to work on this, if you want to pair, let me know!

[vmesel]

@avelino @arxdsilva can you guys take a look? I'm working with @caiolul at Mais Retorno and we went through this issue together

[vmesel]

Something we need to fix after solving this issue (if it's a real issue) is documenting this function better on the docs. Our docs don't offer a very descriptive way of using this function.

[vmesel]

As I spoke to @arxdsilva, it's not actually a bug. To send multiple parameters to inFormat function, you instantiate it with multiple calls of the same field on the URL.

An example:

I need to retrieve multiple hedge funds with IBOV and CDI as indexers, the query would be:

SELECT * FROM hedge_funds WHERE fund_benchmark in {{inFormat "benchmark_field" }}

And the URL to be called would be: /_QUERIES/your_awesome_query_folder/awesome_query?benchmark_field=IBOV&benchmark_field=CDI

[vmesel]

Solved!