Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

error Query extended range failure: Field (ValidFrom)

(0) ShareShare
ReportReport
Posted on by 2,030

greeting everyone

i'v created a new role for user and it's work fine but when try to select plane from this form

HRM.JPG

i got this error 

Query extended range failure: Field (ValidFrom) is not visible.

  • Gunjan Bhattachayya Profile Picture
    35,421 on at
    RE: error Query extended range failure: Field (ValidFrom)

    Mohammed,

    Were you able to resolve the issue adding these tables to your role/privilege?

  • Gunjan Bhattachayya Profile Picture
    35,421 on at
    RE: error Query extended range failure: Field (ValidFrom)

    Just checked the lookup method on the control. Could you try adding these tables as well -

    HRMCompEligibility

    HcmPositionDetail

    HcmJobDetail

  • mohammed.mqi Profile Picture
    2,030 on at
    RE: error Query extended range failure: Field (ValidFrom)

    still same problem i even add this table

    HRMCompFixedEmpl

  • Gunjan Bhattachayya Profile Picture
    35,421 on at
    RE: error Query extended range failure: Field (ValidFrom)

    Try this table -

    HRMCompFixedPlanTable.

  • mohammed.mqi Profile Picture
    2,030 on at
    RE: error Query extended range failure: Field (ValidFrom)

    which table must give access to role?

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,421 on at
    RE: error Query extended range failure: Field (ValidFrom)

    Hi Mohammed,

    Does the role have access to the table being queried for the Plan lookup?

    Please check if you can access the form associated to this table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,892 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,772 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans