A possible bug where a virtual column reports the correct number of records but doesnโt display all records. I have a virtual column called Pattern Results that is looking for products that have a specific Taxonomy code.
So to look for a taxonomy code โlikeโ the following pattern: โYFSCโ, I use the expression below since there isnโt a โlikeโ function. The expression is as follows:
Select(
ProductDefinition[ProductUUID],
LEFT([TaxonomyCode], LEN([_THISROW].[Pattern])) =
[_THISROW].[Pattern]
FALSE
)
The App correctly reports there are 19 matching products that have a similar taxonomy code, but it only displays 17 in the table. The products NEXO and Tiberius are missing. See screen grab below.
This can be verified by running a query against the database. See screen grab below:
The ProductUUID must be valid for the missing products, otherwise they would not work in the database query and would be missing from the query results. In addition, there is no validation restrictions on the virtual column, to possibly filter out the missing products. See screenshot below:
The virtual column select statement appears to work in returning 19 records. Is this a possible bug?
Solved! Go to Solution.
Missing comma.
Wow, surprised it ran in the first place, with the missing โ,โ comma. The two missing records have now appeared. Itโs easy to see how even in a โno-codeโ environment these little errors can catch you out.
Many thanks.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |