SeedCode Support Forum

I just recently got this pop-up while trying to omit different status'. What does this mean?

Hi Illysa,

This error is usually from a problem with the field mapping set-up on the "Source No x" Layout or the Source set up in the script: Load Source Settings at Startup --- Describe Your Sources Here ---

These two set-ups are used to build a SQL query to return the appropriate events by date range and filters. If the Query throws an error, then we show this error.

I would check those sections against the stock copy and make sure everything looks right.

Let us know if that helps,
-Jason

I just ran into this same problem and can't seem to get it right.

The $$sc_Query1 is:
SELECT a."zscTimestampStartCalcNum", ''||a."id", a."start_date", a."date_due", a."start_time", a."end_time", ''||a."id_project" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."id_project" LIKE '%465%' and a."zscTimestampStartCalcNum" Between 63526291200 and 63529919999
Union
SELECT a."zscTimestampStartCalcNum", ''||a."id", a."start_date", a."date_due", a."start_time", a."end_time", ''||a."id_project" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."id_project" LIKE '%465%' and a."zscTimestampEndCalcNum" Between 63526291200 and 63529919999
Union
SELECT a."zscTimestampStartCalcNum", ''||a."id", a."start_date", a."date_due", a."start_time", a."end_time", ''||a."id_project" , 1, a."zscTimestampEndCalcNum" FROM "SampleEvents" a where a."id_project" LIKE '%465%' and a."zscTimestampStartCalcNum" < 63526291200 and a."zscTimestampEndCalcNum" > 63529919999
Union
SELECT c."zscTimestampStartCalcNum", ''||c."id", c."meeting_date", c."meeting_date", c."time_start", c."time_end", ''||c."id_project" , 3, c."zscTimestampEndCalcNum" FROM "SampleMeeting" c where c."id" LIKE '-----' and c."zscTimestampStartCalcNum" Between 63526291200 and 63529919999
Union
SELECT c."zscTimestampStartCalcNum", ''||c."id", c."meeting_date", c."meeting_date", c."time_start", c."time_end", ''||c."id_project" , 3, c."zscTimestampEndCalcNum" FROM "SampleMeeting" c where c."id" LIKE '-----' and c."zscTimestampEndCalcNum" Between 63526291200 and 63529919999
Union
SELECT c."zscTimestampStartCalcNum", ''||c."id", c."meeting_date", c."meeting_date", c."time_start", c."time_end", ''||c."id_project" , 3, c."zscTimestampEndCalcNum" FROM "SampleMeeting" c where c."id" LIKE '-----' and c."zscTimestampStartCalcNum" < 63526291200 and c."zscTimestampEndCalcNum" > 63529919999 ORDER by 1

It looks normal and I've compared it to the stock copy of the calendar and still no luck. If you could direct me to the right script or procedure to debug this that would be awesome.
I've already made sure that the field mapping is correct.

Thanks!!

Make sure your primary and foreign key fields are all Text fields and see if that helps. If not, send me your files at [email protected] with full-access login information and I'll have a look.

Running into this same issue - do you have an update on what solved your problem?

Hi Garrett. Did you make sure your primary and foreign key fields are all Text fields? If that's not it, send your files to me at [email protected] (with full-access login information) and I'll see if I can help you figure it out. -Jeff