web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archive) / error Query extended r...
Microsoft Dynamics AX (Archive)
Suggested answer

error Query extended range failure: Field (ValidFrom)

(0) ShareShare
ReportReport
Posted on by mohammed.mqi 2,016

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.

Categories:
Development / Customization / SDK
Other
  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 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
    Gunjan Bhattachayya 35,417 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
    mohammed.mqi 2,016 on at
    RE: error Query extended range failure: Field (ValidFrom)

    still same problem i even add this table

    HRMCompFixedEmpl

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

    Try this table -

    HRMCompFixedPlanTable.

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

    which table must give access to role?

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard > 🔒Ι Microsoft Dynamics AX (Archived)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans