Pipeline shows 0 records found?

Question

Made a scheduled pipeline to look at a "formula - duration" field on Table A (Calendar) that signifies how many days until an event there are.&nbsp; If it is between 0-75 days, it should create a new record on Table B (Project Manager).&nbsp; For some reason, however, its just returning 0 records, and going through as successful.&nbsp; Even though I have a record where the column is 5 days away.&nbsp; I will continue to work on this, but I didn't know if anyone might have some ideas why it is not seeing this record on Table A and making a new one on Table B?

markshnier__you · Answer

If the field you are comparing to in native, Quickbase is a duration field then you're being tripped up by the unit of measure issue. There is some possibility that if you compare the range to 75 days instead of 75 it might work. But if that doesn't work, then I suggest you make a new formula numeric field in native. Quickbase called [duration in days]; with the formula of

ToDays([My duration field])

that will give you a nice clean numeric field to use for the comparison in a pipeline

bradyakers · Answer

Yes it was initially set to smart units, where I set the filter up as "0 days to 75 days" but it completely failed doing that.&nbsp; So I switched it to just being "Days", which gives the numeric value. But now it runs fully but it discovers no records.

bradyakers · Answer

Just set up a formula numeric field like you suggested and it worked!&nbsp; Very strange.

mez · Answer

I've ran into something similar with trying to determine if a record is less than a duration value. I'm not sure why but it appears the function for seconds is adding zeros (000). When you set the duration field to seconds, it will display appropriately. However, if you use the formula builder, you'll see 3 extra zeroes added. This value is also true in pipelines, even though you might expect the value for a full day in seconds to be 86,400, you'll get 86,400,000.

One of my examples was to look at something within a duration of 4 days. In pipelines if I multiple the total seconds by 1000, I get results that I'm looking for.

Very strange indeed.

markshnier__you · Answer

It's not strange.&nbsp; It just means that they store Duration fields in Milliseconds.

Forum Discussion

Pipeline shows 0 records found?

Related Content

Three Words of Advice on Pipelines

Pipelines: Lookup newest record?

create pipeline to create new records based on current record

Button to Add Record via Pipeline, and refresh Record

Pipeline to add Parent record from child import