Please allow us to help you.
Could you give us more details on what you are trying to do? A sample query and table would be great if it can be provided.
Also you mentioned the official document. Can you tell us which doc / page that was not helpful? I could see if it can be improved in the future.
Hello Yi, thank you for your answer, the query that we are trying to build is as follows:
Select sum(amount) from table, where attr1=[@att1] and attr2=[@att2] and date=[@dateatt]
where attr1, attr2 and dateatt are elements of the model which are changing.
We have lloked for the proper sql table look up syntax in the af server user manual but have not found anything, also we've searched in the pisquare, tech support and internet but still have no answer.
Hope you can help us, thank you.
Thank you everybody, I've solved my problema after digging A LOT, I believe that a separate document explaining all the features of the table look up needs to be done.
The only thing I did was declare my date attribute as a "Configuration Ítem" in the properties section. Then I use the "regular" sentence explained above, and worked!.