Answered

Universal Resource Scheduler - Not possible to edit Default Retrieve Constraints query

(2) Share

Report

Posted on by Splotchy0541

190

This old blog post suggests it is possible to edit the Default Retrieve Constraints Query. However, I cant see the described default settings menu.

Has this changed in the new XP. It doesn't appear to be possible.

Categories:

Microsoft Dataverse with Power Apps

All responses (4)

Answers (1)

Sort by

Suggested answer

Enmanuel Paredes 5 on at

Like
a
(0)

Report
Copy link

Link copied!

I´m being having the same issue, when clicking on "Schedule Types" you should be able to change the XML Query and change the value. Are you able to open that tab?

That's on the Scheduler Board -> Settings -> All Settings -> Schedule Type, when clicking is not opening (I review, and I have no customization that could delete the html from the DOM)

But, by looking into the Configuration table in the Dataverse you can find the Default Resource Constraint Query value, which you can technically update (I'll not recommend update the OOB, but rather create a new one). I haven't test it out yet, but you can update it and then go to the Booking Setup Metadata and use the new one.

I'll like somebody with more knowledge to give us more insight here, i want to change the constraints but i don't want to do it manually within the dataverse
Suggested answer

Enmanuel Paredes 5 on at

Like
a
(1)

Report
Copy link

Link copied!
I did it, try the following:

Go to the Configuration Table

Copy the Default Retrieve Constraint Query Value field

Open it in some code editor and change the flags or values that you want to change, example "<ignoreDuration>".

Create a new one with this value

Open table Booking Settings, and edit the "None" item Retrieve Constraint field and replace it with the new one

Tomorrow i'll tell you the name of the second table exactly.
Splotchy0541 190 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.
Sorry for the late reply. I have created my new query in the Configuration Table.

What is the table of the second table <3
Verified answer

Splotchy0541 190 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you so much I have fixed it full solution below for people coming to this in the future:

Go to the Configuration Table

Edit

Go to the Row For the Default Retrieve Constraint Query

Edit Row Using Form

Copy the Value

New

Any Name

Type Retrieve Constraint Query

Value paste existing

Edit the default e.g.:

<IgnoreDuration ufx-type="bool">true</IgnoreDuration>

Copy the Default Retrieve Constraint Query Value field

Save and Close

Open table Booking Setup Metadata

Show the Column Retrieve Constraints Query

Edit it Removing the Default

Select your custom query in the Dropdown

Glory be Enmanuel Paredes. thank you so much