Query Generator Variable Alias

[Former Member]

Hi,

How can I create an alias for variables in scripts made with query generator? For example, if i include where clauses such as begin date and end date using greater/less than, they will be both shown in the criteria selection box as "Posting Date." This may be confusing to users unfamiliar with the query format. Can I change these prompt names? Thank you.

[Former Member]

Hi Allen,

If you mean the selection box when you run query to input values, then the answer is no. The selection box will only desplay the field description like you can see in DTW template.

For the query results, I am sure you know how alias can be assigned

Thanks,

Gordon

[Former Member]

Hi Gordon,

Yes, I am referring to the selection box that pops up, and not the column names in the results. Thanks for your help anyway.

[Former Member]

Hi Allen ,

If you are talking about query you have written in B1 through query generator ,then answer is yes

you can do it two ways

1. using as

for x as y

2. To.Docdate

you have to change docdate to plandate

To.DocDate [Plan Date]

Your problem will be solved

Thank you

Bishal

[Former Member]

Hi Allen

I realise that plandate is underlined , put that in bracket ,it will work.

Thank you

Bishal