Finance | Project Operations, Human Resources, ...

Query is not working on functional side

(0) Share

Report

Posted on by Laraib

131

I have update a query of Generate Earning in Payroll Module. Actually I have add employ type drop down in query (PayrollStatementGenerationQuery) and it is showing dropdown in developer side when i run the query but when i tried to open form it is showing previous version. I've also run CIL and full CIL but it is still not working.

Here are screen shots of query in which I have created new data source of HcmEmployment table.

query

when i run query in developer side then it is showing dropdown of employ type

query

but when I tried to do it from functional side it is showing old version of query here are the screen shot below

query

All responses (4)

Answers (0)

Suggested answer

Laraib 131 on at

Like (0)

Report

RE: Query is not working on functional side

This issue has been resolve via running Full compilation and full CIL.

Thanks Martin Drab for your guidance and help
Martin Dráb 231,772 Most Valuable Professional on at

Like (1)

Report

RE: Query is not working on functional side

Then look at the "Select query" lookup at the top. Unfortunately I don't remember the exact options there.

And of course, make sure that the change was correctly deployed to "functional side". I'm not sure what you mean by that.
Laraib 131 on at

Like (0)

Report

RE: Query is not working on functional side

Fist of all I would like to thank you for answering my question. Secondly I have done it as you said but it is still not showing.
Suggested answer

Martin Dráb 231,772 Most Valuable Professional on at

Like (1)

Report

RE: Query is not working on functional side

AX typically shows you the query that you used the last time, therefore you don't have to fill in ranges and such things again. But your new range wasn't there and that's why you don't see it.

I think it'll be solved if you simply press "Reset" button (can be seen in your second screenshot).