为什么这个应用程序被拒绝？(Why Was This App Rejected?)
苹果拒绝了这个应用程序，甚至在解析中心提供了一个长时间的解释，但我不确定为什么。 有人可以帮我翻译吗？
2.23
我们发现您的应用不符合iOS数据存储指南，这是每个App Store评论指南所必需的。
特别是，我们发现，在发布和/或内容下载时，您的应用商店下载了媒体（MP3文件）。 要检查您的应用程序存储的数据量：
- 安装并启动您的应用程序
- 转到设置> iCloud>存储和备份>管理存储
- 如有必要，请点击“显示所有应用程序”
- 检查你的应用程序的存储
iOS数据存储指南指出，只有用户使用您的应用创建的内容（例如文档，新文件，编辑等）可以存储在/ Documents目录中 - 并由iCloud备份。
应用程序使用的临时文件只能存储在/ tmp目录中; 请记得在用户退出应用程序时删除存储在此位置的文件。
可以重新创建数据但必须持续保持应用程序正常运行的数据 - 或者因为客户希望它可供脱机使用 - 应该标记为“不备份”属性。 对于NSURL对象，请添加NSURLIsExcludedFromBackupKey属性以防止备份相应的文件。 对于CFURLRef对象，请使用相应的kCFURLIsExcludedFromBackupKey属性。
有关更多信息，请参阅技术问答1719：如何防止将文件备份到iCloud和iTunes？
有必要修改您的应用以符合iOS数据存储指南的要求。 对于不同的代码级问题，您可能希望咨询Apple开发者技术支持。 请确保：
- 包括您的拒绝问题的完整细节
- 准备任何符号化的崩溃日志，屏幕截图和步骤以重现DTS工程师跟进时的问题。
有关如何符号化和读取崩溃日志的信息，请参阅技术说明TN2151了解和分析iPhone OS应用程序崩溃报告。
如果您在重现此问题时遇到困难，请尝试按照https://developer.apple.com/library/ios/qa/qa1764/使用Xcode的存档功能测试工作流程中所述测试工作流程。
Apple rejected this app, and even provided a long explanation in the Resolution Center, but I am not certain why. Could someone help me translate?
2.23
We found that your app does not follow the iOS Data Storage Guidelines, which is required per the App Store Review Guidelines.
In particular, we found that on launch and/or content download, your app stores downloaded media (MP3 files). To check how much data your app is storing:
- Install and launch your app
- Go to Settings > iCloud > Storage & Backup > Manage Storage
- If necessary, tap "Show all apps"
- Check your app's storage
The iOS Data Storage Guidelines indicate that only content that the user creates using your app, e.g., documents, new files, edits, etc., may be stored in the /Documents directory - and backed up by iCloud.
Temporary files used by your app should only be stored in the /tmp directory; please remember to delete the files stored in this location when the user exits the app.
Data that can be recreated but must persist for proper functioning of your app - or because customers expect it to be available for offline use - should be marked with the "do not back up" attribute. For NSURL objects, add the NSURLIsExcludedFromBackupKey attribute to prevent the corresponding file from being backed up. For CFURLRef objects, use the corresponding kCFURLIsExcludedFromBackupKey attribute.
For more information, please see Technical Q&A 1719: How do I prevent files from being backed up to iCloud and iTunes?.
It is necessary to revise your app to meet the requirements of the iOS Data Storage Guidelines. For discrete code-level questions, you may wish to consult with Apple Developer Technical Support. Please be sure to:
- include the complete details of your rejection issues
- prepare any symbolicated crash logs, screenshots, and steps to reproduce the issues for when the DTS engineer follows up.
For information on how to symbolicate and read a crash log, please see Tech Note TN2151 Understanding and Analyzing iPhone OS Application Crash Reports.
If you have difficulty reproducing this issue, please try testing the workflow as described in https://developer.apple.com/library/ios/qa/qa1764/Testing Workflow with Xcode's Archive feature".
原文：https://stackoverflow.com/questions/10759779
最满意答案
所以你希望用户有3个ID，只要其中一个ID不是D.怎么样;
select user from table group by user having count(*) = 3 and max(ID) <> 'D'HAVING子句在这种情况下很有用。 只要排除的ID是最大值（或最小的简单更改），此方法就可以工作。
根据您的评论，如果最小/最大（ID）方法不可行，那么您可以使用NOT IN;
select user from table where user not in (select user from table where ID = 'D') group by user having count(*) = 3在更新的问题之后，如果我已经正确理解了初始示例和现实之间的映射，那么查询应该是这样的;
SELECT user_id FROM user_id_type WHERE user_id not in (select user_id from user_id_type where user_id_type in ('1','2','3','4','5')) GROUP BY user_id HAVING COUNT(user_id_type)='16'奇怪的是，您似乎在表中同时具有同名“user_id_type”的表和列。 这不是最清晰的设计。
So you want users with 3 IDs as long as one of the IDs is not D. How about;
select user from table group by user having count(*) = 3 and max(ID) <> 'D'The HAVING clause is useful in situations like this. This approach will work as long as the excluded ID is the max (or an easy change for min).
Following your comment, if the min/max(ID) approach isn't viable then you could use NOT IN;
select user from table where user not in (select user from table where ID = 'D') group by user having count(*) = 3Following the updated question, if I've understood the mapping between the initial example and reality correctly then the query should be something like this;
SELECT user_id FROM user_id_type WHERE user_id not in (select user_id from user_id_type where user_id_type in ('1','2','3','4','5')) GROUP BY user_id HAVING COUNT(user_id_type)='16'What is odd is that you appear to have both a table and a column in the table with the same name 'user_id_type'. This isn't the clearest of designs.
相关问答
更多-
对于特定类别，您希望这样做： db_query("UPDATE v2_dl_search SET category = '3' WHERE v2_dl_id in (select v2_dl_id from v2_dl where category = '3')"); 适用于所有类别： db_query("UPDATE v2_dl_search SET category = (select category from v2_dl where v2_dl_search.v2_dl_id = v2_dl.v2 ...
-
这实际上取决于您使用的基础数据库。 我不认为rails有一个很好的方法来做到这一点。 我有一个应用程序，我在做同样的事情。 在Redis ZSET中存储ID，然后需要按顺序获取它们。 由于我们使用MySql，我们可以利用字段功能 。 Model.where('id in (?)', ids).order("field(id, #{order})") PS：确保您的order变量已经过消毒！ It really depends on the underlying database you are using ...
-
您的案例称为Multiplexing ans在特殊注意事项中涵盖使用中间件，事务服务器和多层体系结构： 有时，组织开发的网络场景使用各种形式的硬件和/或软件，以减少在特定服务器上直接访问或使用该软件的设备或用户的数量，该软件通常称为“多路复用”或“汇集”硬件或软件。 使用这种多路复用或池化硬件和/或软件不会减少访问或使用SQL Server软件所需的客户端访问许可证（CAL）的数量。 对于每个不同的设备或用户，复用或池化软件或硬件前端都需要CAL。 无论运行SQL Server的服务器与最终使用其数据，服务 ...
-
您可以继续使用您的想法。 唯一的区别是删除where子句并增强having子句： SELECT u.Username FROM UserPermission up JOIN UserAccount ua ON ua.UserID = up.UserId JOIN Permission p ON p.PermissionId = up.PermissionId GROUP BY up.UserId,u.Username HAVING SUM(CASE WHEN p.na ...
-
要获取具有最高编号的5个用户的列表，您可以使用： list = Person.objects.filter(name=name).order_by('-reputation')[:5] 获取每个可用于循环的ID： for user in list: userID = user.id To get a list of the 5 users with the highest number you can use: list = Person.objects.filter(name=name).or ...
-
SQL - 我需要查看有多少用户与一组特定的ID相关联(SQL - I need to see how many users are associated with a specific set of ids)[2023-04-21]
所以你希望用户有3个ID，只要其中一个ID不是D.怎么样; select user from table group by user having count(*) = 3 and max(ID) <> 'D' HAVING子句在这种情况下很有用。 只要排除的ID是最大值（或最小的简单更改），此方法就可以工作。 根据您的评论，如果最小/最大（ID）方法不可行，那么您可以使用NOT IN; select user from table where user not in (select user from ... -
做一个GROUP BY并且要求（ HAVING ）多个不同的id_group被发现 SELECT u.* FROM user u JOIN user_x_group x ON x.id_user = u.id WHERE id_group IN ('1', '2') group by u.id having count(distinct id_group) >= 2 如果需要，您可以轻松调整到3个或更多个id_groups。 替代HAVING子句，恰好为2组： having max(id_group ...
-
您可以使用变量来模拟ROW_NUMBER窗口函数，这在MySQL中不可用： SELECT ArticleId, UserId, UserName FROM ( SELECT a.id AS ArticleId, u.id AS UserId, u.name AS UserName, @row_number:= IF (@uid = u.id, IF (@uid:=u.id, @row_number+1, @row_number+1) ...
-
那这个呢？ SELECT DISTINCT [Email] FROM [dbName].[dbo].[Users] INNER JOIN dbo.Orders on dbo.Orders.CustomerId = dbo.Users.UserId INNER JOIN dbo.OrderLines on dbo.OrderLines.OrderId = Orders.OrderId WHERE Users.SubShopID = 1 AND OrderLines.ProductId <> 1 ORDE ...
-
过去我使用的一种技术是将ID放入临时表中，然后使用它来驱动一系列查询。 就像是： BEGIN; CREATE TEMP TABLE search_result ON COMMIT DROP AS SELECT entity_id FROM entity /* long complicated search joins and conditions ... */; -- Fetch primary entities SELECT entity_id, entity.x /*, ... */ FROM ...