question Re: Catalog UI Policy - end date cannot be before start date in Developer forum

Catalog UI Policy - end date cannot be before start date

Bird Petcharayu — Fri, 30 Apr 2021 04:27:17 GMT

Hello,

I need help. I am trying to use Catalog UI Policy to set the condition on the end date field. What I need is the end date cannot be before start date.

The field is "date" not "date/time"

I applied the condition as below for "end_date_of_visit" is more than 0 days after "starting date of visit" and use the client script BUT it doesn't work. The end date of visit field still can fill in the date before starting date.

Not sure that for this case, it's wrong on the condition I set or from the client script ?

Re: Catalog UI Policy - end date cannot be before start date

AnirudhKumar — Fri, 30 Apr 2021 04:46:28 GMT

I don't think getMessage will work in your script.

Comment line 2, and check

Re: Catalog UI Policy - end date cannot be before start date

Sanika Subhash — Fri, 30 Apr 2021 05:11:16 GMT

Hi,

Here you can use client script and script include as well.

onChange of "End Date" field.

Use GlideAjax and Script include for this.

For Example : If i want to check "Start date should not be greater than end date" if yes then show alert or any message "do not submit" and if not then it will show "submit it".

Client script will be like:

var ga = new GlideAjax('scriptinclude_name');
ga.adddParam('sysparm_name',function_name);
ga.addParam('sysparm_sysid',sysID);
ga.addParam('sysParm_newValue'newValue);
ga.getXML(callbackfunction);

Script Include:

sunction_name function()
{
var newDate = this.getParameter('sysParm_newValue');
var gr=new GlideRecord('incident');
ge.addQuery('sys_id',thiis.getParameter('sysparm_sysid'));
gr.query();
if(gr.next())
{
if(newValue>gr.u_end_date)
{
return "do not submit";
}
else if(newVallue<=gr.u_end_date)
{
return "submit it";
}
}};

Please try to do same with your condition.

If it is helpful then please don't forget to mark it as helpful or correct.

Thank you,

Sanika Gaikwad

Re: Catalog UI Policy - end date cannot be before start date

Ankur Bawiskar — Fri, 30 Apr 2021 05:18:53 GMT

Hi,

did you just hard-coded the message in the showErrorBox

I think the condition looks good.

Regards
Ankur

Re: Catalog UI Policy - end date cannot be before start date

Bird Petcharayu — Fri, 30 Apr 2021 05:31:25 GMT

I modified script to be like this but still no error box.

function onCondition() {
g_form.showErrorBox('end_date_of_visit',"End date of visit can't be before Starting date of visit.",'error');
return;
}

Re: Catalog UI Policy - end date cannot be before start date

Ankur Bawiskar — Fri, 30 Apr 2021 05:32:10 GMT

@Bird Petcharayutporn

you can also use onSubmit Catalog Client Script

Applies to Catalog Item

UI Type - ALL

function onSubmit(){
	
	var start = new Date(g_form.getValue('start_date_of_visit')).getTime();
	var end = new Date(g_form.getValue('end_date_of_visit')).getTime();
	if(end < start){
		getMessage("End date should not be the day before the Start date", function(msg){
			g_form.showErrorBox('end_date_of_visit', msg);
			g_form.clearValue('end_date_of_visit');
		});
	}
}

Regards
Ankur

Re: Catalog UI Policy - end date cannot be before start date

Aman Singh_ — Fri, 30 Apr 2021 05:33:27 GMT

Hi,

Have you tried an alternative with the onchange client script on end_date.

function onChange(control, oldValue, newValue, isLoading) {


  if (isLoading || newValue == '') {


  return;


  }

 var dFormat = g_user_date_format;

var end = getDateFromFormat(g_form.getValue('end_date'),dFormat);
var sDate=getDateFromFormat(g_form.getValue('start_date'),dFormat);

if(end<sDate)


  {


  alert(getMessage("End date should not be before Start date"));


  g_form.setValue('end_date','');



  }


  


 



  }

Please mark Correct✅/helpful???? if applicable, thanks!!

Aman

Re: Catalog UI Policy - end date cannot be before start date

Ankur Bawiskar — Fri, 30 Apr 2021 05:34:00 GMT

Please check the script I shared just now

Re: Catalog UI Policy - end date cannot be before start date

Aman Singh_ — Fri, 30 Apr 2021 06:23:44 GMT

Thanks for marking the response as correct, please close all your threads by marking the appropriate response as correct.

Thanks,

Aman

Re: Catalog UI Policy - end date cannot be before start date

Bird Petcharayu — Fri, 30 Apr 2021 06:26:54 GMT

Thanks, it's workable.

Can you please help me one more ? I need start date cannot be before today.

Thanks.

Re: Catalog UI Policy - end date cannot be before start date

Aman Singh_ — Fri, 30 Apr 2021 06:30:09 GMT

Sure, but its better to raise a separate question, and close this thread since original question has been answered. This will now confuse the future readers.

Hope you understand!!

Thanks,

Aman

Re: Catalog UI Policy - end date cannot be before start date

Ankur Bawiskar — Fri, 30 Apr 2021 06:30:23 GMT

Hi,

you can re-use the same script by writing onChange on Start date?

update as this with just message change

I would recommend using onSubmit instead of 2 onChange client script

Regards
Ankur

Re: Catalog UI Policy - end date cannot be before start date

Aman Singh_ — Fri, 30 Apr 2021 06:34:12 GMT

Ankur please don't mess up the thread!!

Thanks,

AMAN

Re: Catalog UI Policy - end date cannot be before start date

Ankur Bawiskar — Fri, 30 Apr 2021 06:38:30 GMT

I don't think separate question is required as the follow up question relates to the same original question about the validation ..!!

Regards
Ankur

Re: Catalog UI Policy - end date cannot be before start date

Aman Singh_ — Fri, 30 Apr 2021 06:40:31 GMT

You can use the no-code approach to validate start date should not be before today

Create a UI policy as

Re: Catalog UI Policy - end date cannot be before start date

Bird Petcharayu — Fri, 30 Apr 2021 07:21:29 GMT

Appreciate, it's workable.

Re: Catalog UI Policy - end date cannot be before start date

Aman Singh_ — Fri, 30 Apr 2021 07:27:16 GMT

Glad to help!!,

Please mark the appropriate answer as correct and close the thread.

Thanks,

Aman

Re: Catalog UI Policy - end date cannot be before start date

Bird Petcharayu — Fri, 30 Apr 2021 07:40:54 GMT

Found 1 thing that maybe tricky. it seems still be able to avoid UI policy if enter the end date first and start date later. It's allowed to input.

Do we have a script to validate the form ?

Re: Catalog UI Policy - end date cannot be before start date

Ankur Bawiskar — Fri, 30 Apr 2021 07:44:00 GMT

@Bird Petcharayutporn

Hi,

As already mentioned and for better code maintenance you can use single onSubmit client script instead of 2 onChange client scripts.

I have already shared the script.

Did you get a chance to check on that?

Regards
Ankur

Re: Catalog UI Policy - end date cannot be before start date

Aman Singh_ — Fri, 30 Apr 2021 08:01:41 GMT

Update the client script as